Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup / Index / Match Function
Hi,
I have a worksheet with the following 4 columns: Cell A 1 Cell A 11 Cell A 2 Cell B 12 Cell B 3 Cell B 13 Cell B 4 Cell B 14 Cell C 1 Cell B 15 Cell C 2 Cell C 16 Cell C 5 Cell C 17 What I am trying to do is organize them in the following manner across 3 columns: Cell A 1 11 Cell A 2 Cell B 3 12 Cell B 4 13 Cell B 14 Cell B 15 Cell C 1 16 Cell C 2 17 Cell C 5 So, the idea is that I will have the identifying qualifier (eg; Cell A, B,C) in one column and have 2 unique lists which have values related to either Cell A,B,C. I can do this via VBA code using a While loop and arrays to store the information but I was hoping someone could help me do this task without code. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP, MATCH, INDEX? | Excel Worksheet Functions | |||
Not sure what to use? Lookup / Index / Match etc | Excel Discussion (Misc queries) | |||
Lookup or Index/Match | Excel Discussion (Misc queries) | |||
Match Index Lookup | Excel Discussion (Misc queries) | |||
MATCH, INDEX, LOOKUP - Help! | Excel Worksheet Functions |