Hi,
I have a set of tabs named JAN, FEB, MAR and so on... and then the Summary tab
In one of the cells on tab Summary - let's say it's cell A1 - I have set up data validation so that it contains a drop down list with names of all the other tabs: JAN,FEB,MAR....
How can I add a formula in cell A2 on that Summary tab so that it pulls unique entries from column B on any tab I select for a given month? In other words,
=UNIQUE(JAN!B2:B50) works just as well as =UNIQUE(FEB!B2:B50), but I'd rather have it along the lines of =UNIQUE(TEXT(A1)!B2:B50), so that when I select JAN in A1, it pulls data from tab JAN, and when I select FEB it does the same from FEB tab...
Ideally, a solution that would work in Excel 2007, but 365 is great, too!
I have a set of tabs named JAN, FEB, MAR and so on... and then the Summary tab
In one of the cells on tab Summary - let's say it's cell A1 - I have set up data validation so that it contains a drop down list with names of all the other tabs: JAN,FEB,MAR....
How can I add a formula in cell A2 on that Summary tab so that it pulls unique entries from column B on any tab I select for a given month? In other words,
=UNIQUE(JAN!B2:B50) works just as well as =UNIQUE(FEB!B2:B50), but I'd rather have it along the lines of =UNIQUE(TEXT(A1)!B2:B50), so that when I select JAN in A1, it pulls data from tab JAN, and when I select FEB it does the same from FEB tab...
Ideally, a solution that would work in Excel 2007, but 365 is great, too!