| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to match and sort
help requested!!
Column A holds a value of Div1, Div2 or Div3 Column B holds a value from Level1 to Level6 Repeats in either column are allowed. A sample is shown below. I need to place (in N1, O1, P1,...) the UNIQUE Levels in Division 1 (no doubles), preferably in alpha order. In the example, this would be Level2, Level3, Level5 A B ... N O P ... Div1 Level5 Level2 Level3 Level5 Div1 Level2 Div2 Level5 Div3 Level2 Div1 Level5 Div1 Level3 Div2 Level6 This is part of a process that I currently do manually. I'd love to do this by code, but I'm really stuck. Thank you in advance for any assistance. anny |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort & match | Excel Worksheet Functions | |||
| Match and sort | Excel Worksheet Functions | |||
| Match and sort | Excel Programming | |||
| How to match and sort | Excel Discussion (Misc queries) | |||
| Sum if or some sort of match formula | Excel Worksheet Functions | |||
Threaded Mode
