| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If alternative
I have a list of over 300 accounts #.
100000 Cash 100100 Petty Cash 200100 A/R etc... Each range represents a different category. The ranges are 100000-199999 is an A, 200000-29999 is a B. 300000 - 319999 is a C, 320000-399999 is D etc... I need to identify each row as being an A, B, C etc... so I can sort and add/subtract depending on its identifyer. I know I can combine several "if" statement but is there an easier way? I do not know VBA so would rather avoid it. Thx! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative to Indirect | Excel Worksheet Functions | |||
| Case specific LOOKUP alternative | Excel Discussion (Misc queries) | |||
| Quickest alternative for shortcut of PasteSpecial then Values | Excel Worksheet Functions | |||
| Alternative Printer Button | Excel Discussion (Misc queries) | |||
| Seeking an alternative to blank ("") cell in IF arguments | Excel Discussion (Misc queries) | |||
Threaded Mode
