Home 
Search 
Today's Posts 
#1




Counting specific number following decimal point in a row
Hi Everyone,
I have the following dataset 150.1 153.2 154.3 155.1 155.1 157.1 157.4 I would like to count how many cells have 0.1 given the condition that they are between those cells that start with 0.3 and end with 0.4 So in the above example the answer would be 3. I tried COUNTIF function but am having trouble. Can someone help? Thanks Cherian 
#2




Counting specific number following decimal point in a row
On Tuesday, 24 March 2015 07:11:22 UTC+11, wrote:
Hi Everyone, I have the following dataset 150.1 153.2 154.3 155.1 155.1 157.1 157.4 I would like to count how many cells have 0.1 given the condition that they are between those cells that start with 0.3 and end with 0.4 So in the above example the answer would be 3. I tried COUNTIF function but am having trouble. Can someone help? Thanks Cherian Could you try to explain this a bit more clearly? You start off with a particular dataset, but then it seems this dataset is just an example ("in the above example ..."). So what does a typical dataset for your problem look like? Are the numbers always ordered from left to right? Is there always one number ending in .3 and later one ending in .4? And are you only looking at the numbers after the decimal points? Howard 
#3




Counting specific number following decimal point in a row

Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
starts with decimal point only if number is like 0.###...  Excel Worksheet Functions  
Number format still uses decimal point  New Users to Excel  
Show decimal point only if not a whole number  Excel Discussion (Misc queries)  
Converting 2place decimal value to floating point decimal number with leading zero  Excel Discussion (Misc queries)  
How do I round last number without a decimal point  Excel Worksheet Functions 