Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I need to create a formula/macro that will scroll down a column, counting the number of instances of data. I think this is better explained by the example below 1 1.1 1.2 1.3 2 2.1 2.2 2.3 2.4 2.5 I need to count the number of whole numbers and also the number of decimals under each one. Each set of numbers is variable in length, 1 may have 3 steps and another 100s. If any one can help that'd be much appreciated. Thanks Simon -- simonkf ------------------------------------------------------------------------ simonkf's Profile: http://www.excelforum.com/member.php...o&userid=15821 View this thread: http://www.excelforum.com/showthread...hreadid=273137 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Rainfall Data | Excel Discussion (Misc queries) | |||
counting instances of words in a worksheet cell | Excel Discussion (Misc queries) | |||
Counting With Blank Rows | Excel Discussion (Misc queries) | |||
counting non occur entries | Excel Discussion (Misc queries) | |||
Counting instances in a cell | Excel Discussion (Misc queries) |