|
|
#1
11-24-2022, 08:57 PM
|
|||
|
|||
what is formulas for counting value after max digit
I have data for water indicator, what is the formula for make 001-999 counted as 2 not -998 (assume max digit is three)? 
|
| Tags |
| excel 2019, formulas |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Trying to change the last digit in a column of 10 digit entries
|
arkansawyer16 | Excel | 10 | 04-06-2020 02:03 PM |
| long digit error | Midasbelize | Excel | 1 | 05-16-2017 10:14 AM |
| Regex/wildcard search for dates with 2-digit and 4-digit years | Marrick13 | Word VBA | 2 | 01-29-2016 07:04 AM |
|
A challenging digit by digit manipulation, rotate the digit in range of 0 to 9
|
laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |
| Counting unique visitors by ward, counting monthly visits by status, editing existing workbook | JaxV | Excel | 9 | 11-14-2014 12:25 AM |
Windows 11 
Office 2019
Threaded Mode