LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default Multiple Occurences within a range

I am checking a cells to see if they have hard coded data
in them (i.e. A2 + 1). However, I have a lot of annual
dates in my spreadsheets that are generated by adding 1 to
to the value in the preceding column(i.e. B2 = A2+1). So
the "+ 1" will get picked up in this query.

Is there a way to check and see if the cell that I am
evaluating is within a range of cells that all have the
same formula type (i.e. a cell with "+ 1" within a range
of cells with "+ 1" would be flagged and ignored in my
query)
Thanks
 
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
Count occurences over range if a certain criteria met Richhall[_2_] New Users to Excel 6 December 31st 09 06:41 AM
How to count the occurences in my range with 2 characters only? Jen[_4_] Excel Worksheet Functions 5 June 27th 07 09:30 AM
counting occurences in data range (e.g 31-60) Chuck Excel Worksheet Functions 2 June 28th 06 02:09 PM
How do I count occurences in a date range? Jeremy Excel Worksheet Functions 2 July 8th 05 11:21 PM
Number of Occurences In range markawmaw Excel Programming 1 September 26th 03 01:14 PM


All times are GMT +1. The time now is 12:28 PM.

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

About Us

"It's about Microsoft Excel"