| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting Row() digits?
Hi all
In the Calculation below =IF(RIGHT(B108,10)="Receipt"&" "&ROW()-1 how can I turn the 10 into 11 when the row() goes from 99 to 100 and also 11 into 12 when the row() goes 999 to 1000 etc etc Thanks Stewart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| counting digits, not numbers | Excel Worksheet Functions | |||
| Counting Starting Digits | Excel Worksheet Functions | |||
| Counting indvidual digits | Excel Discussion (Misc queries) | |||
Threaded Mode
