Looking for non-array formula to extract unique extract values from A2:B100 into E2:F100. Looking for a second non-array to sort unique values in E2:F100 into H2:I100.
Sample file attached.
Thanks
Looking for non-array formula to extract unique extract values from A2:B100 into E2:F100. Looking for a second non-array to sort unique values in E2:F100 into H2:I100.
Sample file attached.
Thanks
I have done with array formula.
In "E2"Formula:Please Login or Register to view this content.
In "F2"Formula:Please Login or Register to view this content.
Above is for unique.
In "H2"Formula:Please Login or Register to view this content.
In "I2"Formula:Please Login or Register to view this content.
File attach.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
In E2
=LOOKUP(2,1/(COUNTIF($E$1:E1,$A$2:$A$68)=0),$A$2:$A$68)
in G2 (helper)
=COUNTIF($E$2:$E$66,"<=" &$E2)
in H2
=INDEX($E$2:$E$66,MATCH(SMALL($G$2:$G$66,ROWS($1:1)),$G$2:$G$66,0))
You can get the "Origin" with VLOOKUP
Enter regular formula in E2 and copy down
Formula:Please Login or Register to view this content.
This formula will remove duplicates and will soft in ascending order
Please see attached file with formula in Col E
Last edited by AlKey; 03-17-2018 at 03:11 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks