Prev: Please help to get cross reference with another sheet
Next: Multiple Pivot Tables based on the same data
From: robin.coe on 12 Apr 2010 15:43
I have an Excel spreadsheet with 30 rows in it. I need to write a
formula or macro that will compare the value of cell C1 to C2. If the
value is the same then I need it to look at cells E1 and E2 to see if
the value of either is ZZ. If the value is NOT ZZ then I need it
compare cells C2 to C3 etc to the bottom of the worksheet. If the
value is ZZ then I need it to delete rows 1 and 2. Can someone help
with how to accomplish this?
 | 
Pages: 1
Prev: Please help to get cross reference with another sheet
Next: Multiple Pivot Tables based on the same data