Hi All
I have a excel sheet which has 4 column, i would like to delete rows based on some criteria's.
My columns are Record #, Amount, Note 1 and Note 2.
My Criteria will be : Some time Note 1 or Note 2 will have record #.
I have attached example file, in that first row having some note 1, which is a record # we can find it in Row no : 22.
In this case sum of these amount is Zero, so i need to delete both rows. Similarly i need to check all rows which has Note 1 and Note 2 against Record # and Amount,
I have a excel sheet which has 4 column, i would like to delete rows based on some criteria's.
My columns are Record #, Amount, Note 1 and Note 2.
My Criteria will be : Some time Note 1 or Note 2 will have record #.
I have attached example file, in that first row having some note 1, which is a record # we can find it in Row no : 22.
In this case sum of these amount is Zero, so i need to delete both rows. Similarly i need to check all rows which has Note 1 and Note 2 against Record # and Amount,