I have an issues with a formulae I have written to measure two factors;
A; How many different countries appear within a certain date range.
B; What countries are they.
I tried a unique list, but could not get it to work within a range? I dont particuarly care how the data is pulled through as long as I do it. At the moment I have become stuck in 'Unique Ranges' and have n given up, does anyone have any ideas why this does not work?
The formulae issue is in the tab "Problem_Formulae", the dat in the sheet 1, and the date ranges in sheet 2. Also, just to make life a bit more challenging pivot tables are a no go :(.
Thank you for any guidance in the right direction for this.