Removing duplicates with a formula. Is the Unique formula an option?

[Pibsandsquibs]

Hello

I am using the filter formula to create a dashboard of todays events from our main spreadsheet. The problem I have is each line for each order comes through and some orders could have up to 20 lines. I was looking at using the unique formula in the filter to remove the duplicates (which would be the order number in column A). But not sure where it put it in the formula I already have. Could someone please advise or if there is another option that I can use.

Below is the formula currently in place that I want to remove the duplicates from. Many thanks

=FILTER('[Log.xlsx]Log'!A:CH,('[Log.xlsx]Log'!AW:AW>=TODAY())*('[Log.xlsx]Log'!AW:AW<=TODAY()))

 

[RoryA]

If every column is the same for the duplicates, then you can use UNIQUE. If not, what output are you expecting for the other columns?

 

[Pibsandsquibs]

@RoryA

Thinking about it I would choose columns that I want to see in the filter using a formula you have helped me with. So every column would be duplicated as the columns that return different information won't be pulled through.

As per below, but I would only want the information to appear once in line 4.

I've amended the formula slightly to

=CHOOSECOLS(FILTER('[Log.xlsx]Log'!A:CH,('[Log.xlsx]Log'!AW:AW>=TODAY())*('[Log.xlsx]Log'!AW:AW<=TODAY())),1,10,33,34,38,47,49,50,53)

 

[RoryA]

In that case, just wrapping that in UNIQUE should work:

=UNIQUE(CHOOSECOLS(FILTER('[Log.xlsx]Log'!A:CH,('[Log.xlsx]Log'!AW:AW>=TODAY())*('[Log.xlsx]Log'!AW:AW<=TODAY())),1,10,33,34,38,47,49,50,53))