| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elimination of Duplicates in an Array and its reduction.
I have two large columns arrays A1:A4000 and B1:B4000
A: contains words alphabetically sorted and B: their corresponding page numbers. I need to reduce all duplicates of a word to one row with all their number occurences on adjacent column cells of the same row. For example A B C D E F word A 21 word A 21 25 word A 25 to word B 10 15 17 word B 10 word C 3 word B 15 word B 17 word C 3 How do I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Offset() formula with height of 1 returns duplicates? | Excel Worksheet Functions | |||
| Gauss elimination | Excel Worksheet Functions | |||
| array formula with duplicates | Excel Discussion (Misc queries) | |||
| Mathematical elimination | Excel Worksheet Functions | |||
| Gaussian Elimination | Excel Worksheet Functions | |||
Threaded Mode
