Hello all learned people, I do not have a clue where to even begin.
I have a w/sheet with data in col A through G. I need to be able to find out if there are any duplicates in any rows in col D. if there are, then count how many times they appear (in the rows) and take the total and place it in A70, copy the text of the duplicated item and paste it into D70 and then delete all rows where the duplicates appeared.
if there are many different texts, then paste the results in the next available row after row 70, then after 71 etc.
As I said, I don't even know where to begin, and your help will be greatly appreciated.
I have a w/sheet with data in col A through G. I need to be able to find out if there are any duplicates in any rows in col D. if there are, then count how many times they appear (in the rows) and take the total and place it in A70, copy the text of the duplicated item and paste it into D70 and then delete all rows where the duplicates appeared.
if there are many different texts, then paste the results in the next available row after row 70, then after 71 etc.
As I said, I don't even know where to begin, and your help will be greatly appreciated.