Delete cell value in ColE based on value is ColA
All,
I have a work sheet with data like this
Col A___________Col B___________Col C___________Col D___________Col E
9812___________ Joe____________________________________________125 .00
*blank*__________
____________________________________________125.00
*blank*__________
____________________________________________125.00
Total __________ ____________________________________________
375.00
What I want to do is delete value in Col E if the value in Col A of
the same row IS NOT = Total
Thanks
Steve
|