Not able to figure this out in an older version of excel.... =UNIQUE not availble.
Any help would be appreciated.
Not able to figure this out in an older version of excel.... =UNIQUE not availble.
Any help would be appreciated.
Last edited by pubjay; 07-16-2020 at 08:32 PM.
andPlease Login or Register to view this content.
but pivote table can be beter for youPlease Login or Register to view this content.
I guess I don't know how to make it work. When I look at your example, it's there. Whe I try to replicate it in another tab of the example, doesn't work.
I just paste the =IFERROR into cell I2 and drag down? Or it should populate itself?
Figured it out!
I guess you need to use CTRL + SHIFT + ENTER on the formula (array formula)
First time I've ever done that.
BMV your examples worked perfectly after that, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks