| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Case Sensative Subtotaling
I have a situation where I have multiple contracts which are 2 characters and
are case sensative. Example.... Contract #1 = 'AE' (both uppercase) Contract #2 = 'aE' (lowercase a, uppercase E) Contract #3 = 'Ae' (uppercase A, lowercase e) Each contract has multiple lines of sales dollars and I need to sum according to each specific contract, maintaining the case sensativity. Is there a way, without changing the characters, to do this?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change data of entire column from small case to upper case | Excel Worksheet Functions | |||
| Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
| Case sensative list validation | Excel Discussion (Misc queries) | |||
| do formulas have to be case sensative when searching words | Excel Discussion (Misc queries) | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
Threaded Mode
