Forum Discussion
Remove duplicates within multiple columns without removing adjacent data
Yes, sorry, that is
=IFERROR( INDEX( A$2:INDEX(A:A,COUNTA(A:A)), AGGREGATE(15,6, 1/(COUNTIF(I$1:I1,A$2:INDEX(A:A,COUNTA(A:A)))=0)* (ROW(A$2:INDEX(A:A,COUNTA(A:A)))-ROW(A$1)),1 ) ),"")
aangus07 I am a little bit confused. What I understand is that for some reason, excel is duplicating the dates, and you dont want it to do that.
May I take a look at your formula?
negative; I extracted the dates across multiple columns; each column has a header with an item.
the dates are when that item was sold.
Multiple of the same dates is just because that item was sold more than once on that day to different customers.
I now need to remove the duplicates in each column individually. I'm asking if there is a way to do that quicker than just selecting each column and removing the duplicates and then selecting the next column and removing the duplicates.
can i select all of the columns and remove the duplicate dates in each individual one at once?
example: there would be one "Wednesday June 3, 2020" in each column above.
then it would leave one "June 9" in the left column and one "June 10" in the right column etc.
So what you are saying is that for each item, if it was sold on a certain date, you just want it to display the date once, not everytime someone buys the item?
aangus07 Can I see the sheet? Or if there is confidential information, a sheet like that?
Exactly, each column is a different item (i have 178 columns)
I want each item to have the dates listed without duplicates.