excelquestionphoto.jpg
Ive looked everywhere on this forum and I can't find an answer. So- here goes. I will fall off my chair if someone can solve this Excel dilemma.
I need to remove duplicate rows based on values of one cell in the row.
For instance- I need to delete or hide all but one row of each duplicate PO ID I get (Column H).
However- I do need to keep the total at the top the same. So I need the hidden cells to still be calculated.
Does that make sense?
Bookmarks