Vlookup vs index
 

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

Vlookup vs index
 

"Bill" wrote:

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

Vlookup vs index
 

See your other post

--
Biff
Microsoft Excel MVP


"Bill" wrote in message
...
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