| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting Row() digits?
Try this:
8+LEN(ROW()) Hope ths helps. Pete On Jan 16, 1:45*pm, stew wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting Row() digits?
Thanks Pete
Does the Job Stewart "Pete_UK" wrote: Try this: 8+LEN(ROW()) Hope ths helps. Pete On Jan 16, 1:45 pm, stew wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting Row() digits?
You're welcome, Stewart - thanks for feeding back.
Pete On Jan 16, 3:19*pm, stew wrote: Thanks Pete Does the Job Stewart |
| Reply |
| 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) | |||
Linear Mode
