Vlookup vs index

B

Bill

I have the 3 columns of data in columns "m", "n", and "o" (No headings, data
starts in row 1). There are 216 rows starting in row 1. From the example
below, I will create in column "r", the heading FB2. Under the heading, I
want to
see each 3 digit number that corresponds to FB2, with out repeating the same
3 digit number.
M N O p Q
R
000 0.198407405 PO3 FB2
001 0.207502916 CV3
002 0.984589896 CV3
003 0.715903627 FB2
 
B

Bill

Bill said:
I have the 3 columns of data in columns "m", "n", and "o" (No headings, data
starts in row 1). There are 216 rows starting in row 1. From the example
below, I will create in column "r", the heading FB2. Under the heading, I
want to
see each 3 digit number that corresponds to FB2, with out repeating the same
3 digit number.
M N O p Q R

000 0.198407405 PO3 FB2
001 0.207502916 CV3
002 0.984589896 CV3
003 0.715903627 FB2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top