Last seen: Jun 25, 2026
@ukdj Oh, sorry. Should have explained better. "Table4 is just the name Excel gave the table when I formatted the data as a structured table. The f...
@karenfry Oh, I hadn't noticed that B had numbers in it and three conditional formats based on these (10, 20, 30). Not sure I though how these tie ...
@karenfry Indeed, you can't 'look-up' color formats. Best to change the template so that column B contains the status in words. Do that with data va...
@univer I would do that with Power Query as demonstrated in the attached file. Edit: Thought of a formula solution as well. Enter the formul...
@ukdj Thanks, that worked. I replaced the formulas in B3 and E8 with ones that create the sequences you had in mind, though without dynamic array fu...
@ukdj Structured tables don’t allow dynamic array functions that spill results into multiple cells. It defies the whole nature and purpose of struct...
@patrick-leibovichgmail-com I believe it was the attached one.
@carthyeilygmail-com Great! After I posted my previous answer, I thought that you can actually achieve a very similar result without the need for P...
@carthyeilygmail-com Thought very hard about it and couldn't figure out a manner to achieve what I believe you want in the way you described. But t...
@carthyeilygmail-com Could you upload the data table as you had it in your original post. And the sales table that 'belongs' that that data? I.e....
@bee Perhaps best to demonstrate in a working model. Does the attached file contain the solution you need? If not, what would be the end result you...
@jessica5 Ah, I see. That combination makes it difficult indeed. The only solution I can offer is by creating the bar chart from a structured data ...
@jessica5 Sort the pivot table in ascending order by sport first, then by value in ascending order. A bar chart will then display in descending valu...
@bee Not entirely sure on how you built your schedule as your data doesn't seem to be in a structured table. I would recommend you do that. Regard...
@carthyeilygmail-com I've added the Excel formulas to your file so that I could compare the PQ outcome. The query is quite basic though requires som...