Hello, Thank you all for your help.
I have one more question before I am finished with this project.
I have keywords in column A, and dates in column B.
When A and B are equivalent more than once in the rows. I want a macros to delete these rows with duplicate values, and what remains is one row with the unique A & B and the average of all the values for the respective rows with duplicate A and B values. The other columns have unique numbers. I have attached a spreadsheet so you can better understand what I am referring to, since its a simple idea. I would also like to have on the right in a column the # of articles that were used in taking the average.
Bookmarks