I have values in Col C and need the values that match to be deleted as follows
1) Where there is a value in Col C with say a positive value eg 2150 and there is a single value that is negative -2150 then the rows containing these values are to be deleted (I have highlighted all the items in yellow where the positive value and negative values equal to zero). I have also put numbers next to each of the yellow items that match off
2) Where there are several values in Col C that sums to say R 925.45 and there are several other values that sums up to these but they are opposite in value for e.g. if the sum of several values is say R 25000 and there are negative values adding up to- R 25000 then these must be deleted. I have shown these with different colours where several say negative values sums up to several positive values and vice versa
It would be appreciated if someone could kindly assist me
Bookmarks