LinkBack URL
About LinkBacks
Hello,
I'm looking for a formula that help me return non-repetitive value as it has same lookup value. It's a bit hard for me to explain but if you can see my attached. I will make sense what I'm looking for.
sample test.xlsx
Hello,
I'm looking for a formula that help me return non-repetitive value as it has same lookup value. It's a bit hard for me to explain but if you can see my attached. I will make sense what I'm looking for.
sample test.xlsx
I looked at your file.
I have no idea what you're wanting to do!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I think you could do this by adding a helper column (I used E - you can hide it if you want)....
E4=D4+COUNTIF($D$4:D4,D4)/1000
copied down
Thenb to pull out your data...
G4=INDEX($C$4:$C$18,MATCH(F4+COUNTIF($F$4:F4,F4)/1000,$E$4:$E$18,0))
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Similar to FDibbins solution another way. This is without a helper column.
In H4 this array-entered formula filled down.
=INDEX($C$4:$C$18,SMALL(IF(F4=$D$4:$D$18,ROW($C$4:$C$18)-MIN(ROW($C$4:$C$18))+1),COUNTIF($F$4:F4,F4)))
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.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks