| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-Fill Data in alphabetical order?
Hi,
I'm working for LCD company. I'm looking for the easier way to input 'panel ID's. Here is the example. 4NJ8CD001AA 4NJ8CD001AB 4NJ8CD001AC ..... Even though I thought Auto-filling function should work, Unfortunately, it didn't seem to work. Instead, it generate the data like this. 4NJ8CD001BA 4NJ8CD002BA 4NJ8CD003BA 4NJ8CD004BA 4NJ8CD005BA 4NJ8CD006BA 4NJ8CD007BA Does anyone know how to solve my problem? Please, help me. It's annoying to input thousands of panel ID one by one. -- Thanks for your concerns! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to auto arrange in alphabetical order-excel sheet | New Users to Excel | |||
| Alphabetical order possible? or not | Excel Discussion (Misc queries) | |||
| sort rows in alphabetical order and move the corresponding data | Excel Worksheet Functions | |||
| Changing the auto fill order from ascending to descending | Excel Discussion (Misc queries) | |||
| Using a macro to sort your data in alphabetical order? | Excel Discussion (Misc queries) | |||
Threaded Mode
