imagine this data in cells A1:F4
A A F A
A A F A
2 A F A
A A F A
E A F A
E A E F
I am looking for a dynamic range formula that will include only those rows that have F in column C (I.E highlighted in red). The first set of cells in column C will always be F, how do I insure the range always ends where they stop?
Thanks
niceguy21,
I'm a bit confused. A1:F4? Do you mean A1:D6? If that is what you meant (4 columns using 6 rows of data), then give this a try:
Note that this formula assumes the cells in column C will start with "F" and be a continuous block until they are no longer "F" and that there are no other occurrences of "F" after that.
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
What about if the cell range is D8:G13 ?? this isnt working in that instanceOriginally Posted by tigeravatar
niceguy21,
I'm a bit confused. A1:F4? Do you mean A1:D6? If that is what you meant (4 columns using 6 rows of data), then give this a try:
Note that this formula assumes the cells in column C will start with "F" and be a continuous block until they are no longer "F" and that there are no other occurrences of "F" after that.Please Login or Register to view this content.
Last edited by niceguy21; 11-02-2012 at 01:00 PM.
Of course not, the formula is looking in columns A:D with they key column being C where is counts the occurrences of "F". You have to tell the formula what columns to look in and provide it with the key column. You should be able to adapt the provided formula.
here is some code you can use / customize. The code identify the first row that does not have an F in column C.
Please Login or Register to view this content.
=offset($d$8, 0, 0, countif($f:$f, "f"), 2)
This isnt working..
Last edited by niceguy21; 11-02-2012 at 01:00 PM.
Looks like that offset formula should work just fine also. Great job!
working now! just looked wierd when we referenced it in a cell.Looks like that offset formula should work just fine also. Great job!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks