Hi there,
i am trying to figure out the best formula or formulas that can bring me multiple results based on one cell.
My data has a table with Quarters, amounts and currency.
I want to summaries the data according to the currency and if cell K3 is quarter 2 then i want the formula to pick up quarter 1 and quarter 2. If cell K3 equals 3 - then i want the data to bring up Quarter 1,2 and 3.
I hope someone can help!
Bookmarks