| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advance level of sorting data? by Ting
I have got a column of data like below:
Y Y Z X Z X Y X how could I use the excel function to make it becomes the following? A B C D 1 Y X Y X 2 Y Z 3 Z X The rule is, 1) once there is a change from X to Y / Y to X , new column will be applied. 2) Z will stick with the previous result in the same column Please help cause I have so many data need to be proceed now |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Shuffle the data at ROW level. | Excel Discussion (Misc queries) | |||
| Problem with search and replace data,thanks for you help in advance. | Excel Discussion (Misc queries) | |||
| how to eport health level 7 data to excel | New Users to Excel | |||
| Advance function of excel to get sorted data | Excel Worksheet Functions | |||
| Pull data - Advance Filter | Excel Worksheet Functions | |||
Threaded Mode
