Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/Match or Vlookup | Excel Worksheet Functions | |||
VLOOKUP or maybe INDEX | Excel Worksheet Functions | |||
Should I use VLOOKUP? IF? INDEX? | Excel Worksheet Functions | |||
VLOOKUP, INDEX, or ....? | Excel Worksheet Functions | |||
INDEX? VLOOKUP? | Excel Discussion (Misc queries) |