ninadunn
02-12-2007, 05:13 PM
Hi there,
How do i manipulate a range so that i can ignore certain cells based on the variable criteria without affecting the data in the range.
If the cells don't meet the criteria i don't want the cell to be set to zero or deleted, i just want the cells skipped
For example I want to search through two data series (Range A, Range B). Anything which does not meet my criteria in Range A, i want the 2 rows skipped in both Ranges A & B.
Thanks
How do i manipulate a range so that i can ignore certain cells based on the variable criteria without affecting the data in the range.
If the cells don't meet the criteria i don't want the cell to be set to zero or deleted, i just want the cells skipped
For example I want to search through two data series (Range A, Range B). Anything which does not meet my criteria in Range A, i want the 2 rows skipped in both Ranges A & B.
Thanks