| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index Match ?
In my worksheet I rows of values as follows in individual cells
ABC 72 30 DEF 67 20 GHI 77 33 JKL 80 12 DEF 77 23 GHI 77 34 ABC 73 31 JKL 81 13 and so on.... The same text will not always be in the same column What I'm trying to do, is then create a list that will return the values as follows: ABC DEF GHI JKL ABC DEF GHI JKL 72 67 77 80 30 20 33 12 73 77 77 81 31 23 34 13 Hope this has made sense |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Threaded Mode
