N
NM
I’m using the following formula to and am wondering if it can be used more
efficiently, or if I need something completely different.
=INDEX($A$12:$A$43,MATCH(Q12,$N$12:$N$43,0))
Data from column N is sorted from highest to lowest into column Q in my
Excel spreadsheet.
I have duplicates in column Q, so the above formula I’m using isn’t working
like I need it to. I need the formula to continue to the next occurrence in
column N when a duplicate is encountered and place that result from column A
into column S. I need this to continue as such as need be. I have over ten
duplicate numbers in column Q, but those duplicate numbers represent ten
different items.
For example I have this data:
1 DMWF
1 DMWF
1 DMWF
0 CC
0 CC
0 CC
However, it should look like this:
1 DMWF
1 HD
1 P (LC)
0 CC
0 LTC
0 HTOAC
Any help would be appreciated.
Thank you.
efficiently, or if I need something completely different.
=INDEX($A$12:$A$43,MATCH(Q12,$N$12:$N$43,0))
Data from column N is sorted from highest to lowest into column Q in my
Excel spreadsheet.
I have duplicates in column Q, so the above formula I’m using isn’t working
like I need it to. I need the formula to continue to the next occurrence in
column N when a duplicate is encountered and place that result from column A
into column S. I need this to continue as such as need be. I have over ten
duplicate numbers in column Q, but those duplicate numbers represent ten
different items.
For example I have this data:
1 DMWF
1 DMWF
1 DMWF
0 CC
0 CC
0 CC
However, it should look like this:
1 DMWF
1 HD
1 P (LC)
0 CC
0 LTC
0 HTOAC
Any help would be appreciated.
Thank you.