|
|
#15
06-13-2020, 07:15 PM
|
|||
|
|||
It is becuase of the size of the number - excel can only deal with (i think) 15 significant figures and anything else is rounded.
For exmaple if you put 377540323190869743517.9993055556+0 in an other cell it will show as 3.7754e+20, then increase decimals to the max and you will see the cell is actually showing 3.775403231908690000000e+20.. Drop off the zeros and filter for 377540323190869 and you will get 16, which is how many the count is counting. Now to get around that....... 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Grouping Lines by Project number on a separate page | taholmes160 | Excel | 2 | 04-17-2019 03:57 AM |
 How to count words in a text, arrange them in separate lines and put the grammar class ?
|
Marcway | Word | 6 | 12-14-2018 04:25 PM |
| Trying to add space between lines of bulleted text and a new header but both lines are moving??? | Martin_d35 | Word | 2 | 02-10-2017 07:13 AM |
|
Getting the Count formula to count all rows
|
Jennifer Murphy | Word Tables | 11 | 08-23-2016 09:37 PM |
|
Pivot table grouping problem 2 tables need different grouping
|
differentdrummer | Excel | 3 | 12-10-2013 01:19 AM |
Windows 10 
Office 2019
Threaded Mode