Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
starts with decimal point only if number is like 0.###... markx Excel Worksheet Functions 3 September 14th 07 12:10 PM
Number format still uses decimal point BecknRoos New Users to Excel 3 April 9th 07 06:32 AM
Show decimal point only if not a whole number Exceler Excel Discussion (Misc queries) 2 July 11th 06 01:40 PM
Converting 2-place decimal value to floating point decimal number with leading zero Kermit Piper Excel Discussion (Misc queries) 3 March 18th 06 06:20 PM
How do I round last number without a decimal point rollover22 Excel Worksheet Functions 1 July 26th 05 04:35 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017