Forum Discussion
Remove duplicates within multiple columns without removing adjacent data
I currently have 178 columns total filled with dates ranging from June to September. I need to remove the duplicate dates within each column and still select all of the columns.
How can I remove duplicates within each individual column by selecting multiple columns at once and so that excel doesn't compare the data to each column. Let me know if that makes sense.
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 ) ),"")
18 Replies
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?
