Hi all,
I have match a date range and get 3rd unique value.
But I am getting answer "C" Actual answer is "D". Excel book is attached.
Please help me to get the correct answer.
Regards
Rudswa
Hi all,
I have match a date range and get 3rd unique value.
But I am getting answer "C" Actual answer is "D". Excel book is attached.
Please help me to get the correct answer.
Regards
Rudswa
3rd unique value is A
I want the unique value. like in the series "A A A B B B C C C" , "C" is the third unique value.
Try this
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Not working as intended sir.
Last edited by AliGW; 09-29-2019 at 06:14 AM. Reason: Please don't quote unnecessarily!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It is giving "3rd value in the series" not the 3rd "unique" value in the series.
So what exactly does post #2 mean, then? You need to be clear.
Helper column C used
In C2 then copy down
In F11Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks it is working. But is it possible to do without the helper column.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks