Sep 08 2020 07:41 PM
Hello!
I have a multiple lists of items that I've combined into one
At the moment it looks like this
I'm wondering if there's a way to consolidate the list.
I've tried the consolidate function, but I can't quite seem to get it to work at least not the way the list is
(Extra detail: The tops of the columns have headers so it can be filtered)
Thanks!
Sep 08 2020 09:08 PM
@Jettek What exactly do you mean by "consolidate the list"? Do you want a list of unique items only, and perhaps sum/count how many of each there are in the list? If so, a pivot table could do that. Alternatively, is you are an MS365 subscriber, you could use the UNIQUE function and combine it with SUMIF or COUNTIF. Please clarify.