Hello Excel Gurus
I'm back, I thougt was easy but is not, I know how to do a unique list with a FREQUENCY function from one column but when there are two column like in this case is difficult form me, I'm stuck
In column D is the expected result
Can you Help me please?
Thank You!
A B F C V G Z
1) Paste the following array entered formula* into D2:2) Simultaneously press the Ctrl, Shift and Enter keys,Formula:
Please Login or Register to view this content.
3) Copy down.
*If you skip step 2 you'll get a #Value error.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
This formula is quite a bit longer. It is array entered also. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:Please Login or Register to view this content.
Perhaps this is clearer to read:
=IFERROR(INDEX(IF($A$2:$A$18<>"",$A$2:$A$18,$B$2:$B$18),SMALL(IF(FREQUENCY(IF($A$2:$B$18<>"",CODE($A$2:$B$18)),IF($A$2:$B$18<>"",CODE($A$2:$B$18))),ROW($A$2:$A$18)-MIN(ROW($A$2:$A$18))+1),ROWS($2:2))),"")
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks