Trace precedents of datatable
I have used the {=table(cell ref,)} datatable function to calculate a range of outputs from a range of inputs. Now I wish to check the calculations but trace precedents does not work with this function. The function itself only shows the input cell and not the output cells - and it is those cells I need to trace to check that my calculation is sound. I have drawn a blank with searching for this answer. Any ideas?
Basic Join Issue
I'm doing what I think is a super basic query in Power Query Editor. I have a table of products. I have another table of Customers and Products. I want to get a merged query list showing null values of products customers don't own yet. My research shows this should be a Left Join on the Product column in both tables. When I do this I get no null values, I only get matched values. Example ProductCustomerOwns Customer1 | Product 1 Customer1 | Product 2 Customer3 | Product 1 ProductTable Product 1 Product 2 Product 3 Product 4 The result I am looking for is this merged query table: Customer1 | Product 1 | Product 1 Customer1 | Product 2 | Product 2 Customer1 | Product 3 | null Customer1 | Product 4 | null etc etc What I'm getting instead is this: Customer1 | Product 1 | Product 1 Customer1 | Product 2 | Product 2 I've tried so many variations (anti-joins, picking the wrong columns, all kinds of stuff) and I cannot get the query to work. Here's what the Merge query looks like: let Source = Table.NestedJoin(ProductsByCustomer, {"Product Allocation Group"}, Products, {"Product Allocation Group"}, "Products", JoinKind.LeftOuter), #"Expanded Products" = Table.ExpandTableColumn(Source, "Products", {"Product Allocation Group"}, {"Product Allocation Group.1"}) in #"Expanded Products"
Analysis Toolpak on Excel issues on Mac
I recently used Analysis Toolpak on Excel for Mac. I ran a "rank and percentile" analysis on data, and it hung for some reason. I had to force quit excel. When I restarted excel, I noticed that some issues started to occur, including: The default paste function (Command-V) was only pasting unformatted text only. Weirdly enough Ctrl-V worked perfectly fine. Also, paste special > all works fine as well. Pressing return on a cell did not move down to next cell. By default, it was like pressing F2 instead. I turned off the analysis toolpak. The cell return issue disappeared, but command-v was still only pasting values. I tried reinstalling excel to no avail. Anybody have any suggestions on how to get my default paste function back to normal?
Excel for Microsoft 365 for Mac - copy/paste issue
Hello, I am on a Macbook 16" using Excel for Microsoft 365 for Mac version 16.42 Just recently I am unable to copy-paste while keeping formulas, merged cells, cell colors and general formatting when pasting into the same sheet. I can still create a copy of the whole sheet, but I need to compare the data on 2 versions of the same information. You can see in my sample doc that formatting does not paste correctly and the pic shows that I don't seem to have as many special options as I remember in the past. I would be so grateful if someone could help. Thank you, KSinKCNames of chart worksheets tabs have disspaeared
The tab names I had given to worksheets that are charts have disappeared and they are now just named 'Chart1', 'Chart2' ... 'Chart10'. Does anyone know why Excel would do this? Yesterday I moved the file to a different folder by 'dragging and dropping' and have noticed this since then. My workbook has about 15 worksheets, of which 10 are charts, it is 40 MB in size, the worksheets with spreadsheets in them have kept their tab titles as they were. I am using an iMac.
Profit/Loss per Day Calendar
Hi All, I am looking for formula for these 2 items. 1. Want total Profit/Loss per date in Calendar (E.g. Total Profit on 02 Feb 2022 was -90.65). 2. If Profit Cell to be Green, If Loss cell to be Red Link to Excel Sheet. https://1drv.ms/x/s!AlvQCyQGg78NgkNEsm2PYzAfJIEo?e=bF7ctcExcel for Mac applying filters to Pivot Table automatically
Hi, Not super experienced with Excel but my company use a historic document to analyse sales data with a lot of Pivot Tables. When selecting values with a filter, it is automatically deselecting the values that aren't within the range I've typed in the keyword search: So I typically enter a MM/YYYY in this box and it lets me deselect values but keeps the remaining values that aren't within the filter selected. My colleague is running the same version of Excel and I have checked our Pivot Table settings which are identical. Functionality has been fine until Monday when this change seemingly got pushed to my version? Any help to resolve this would be amazing, and sorry if my explanation isn't very technical! Thank you
