| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count within Cell
I have a ticket number and I need a count within a cell.
I have 2000 lines of tickets and I need to make sure that the count within a cell does not go over number. Example:(Must be in this format) LMN000001234567 KLM000000012345 Some entries of the ticket numbers sometimes are not inputted correctly. I need highlights to show the wrong entries if there are more zeros in LMN and KLM. Also if the digits in LMN goes over or under 7 digits and KLM goes over or under 5 digits. They have to be in this format. If not they are wrong. I need LMN to have 5 zeros with 7 digits which means there is not a 0 infront of the 7 digits. I need KLM to have 7 zeros with 5 digits which means there is not a 0 infront of the 7 digits. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| make text in one cell count as 1 in another cell | Excel Discussion (Misc queries) | |||
| count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Threaded Mode
