Remember Me?

#1
March 23rd 15, 08:11 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2015 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
March 24th 15, 02:37 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2013 Posts: 16
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
March 24th 15, 06:31 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,872
Counting specific number following decimal point in a row

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post markx Excel Worksheet Functions 3 September 14th 07 12:10 PM BecknRoos New Users to Excel 3 April 9th 07 06:32 AM Exceler Excel Discussion (Misc queries) 2 July 11th 06 01:40 PM Kermit Piper Excel Discussion (Misc queries) 3 March 18th 06 06:20 PM rollover22 Excel Worksheet Functions 1 July 26th 05 04:35 PM

All times are GMT +1. The time now is 11:05 PM.