Unique Value Function

[Fredbugatti]

Hi,
I need a unique value function that will extra unique values from Column B to D and return results of unique values and summing up the total amount.
please see attached for example.

[MarvinP]

Hi Fred,

If you use the Advanced Filter tool on the Data Tab it has a check box for Unique. That will filter out all the duplicate rows. Then you could do a sum on the result.

https://support.office.com/en-us/art...1-8daaec1e83c2 or
https://www.sageintelligence.com/tip...lues-in-excel/

[Fredbugatti]

Hey.
Is there a formula that will extract them and sum the duplicate values since I have over 10,000 rows .

[MarvinP]

Hi Fred,

If you had the latest version of Excel it has a newer Unique function but you have an older version.

https://www.spreadsheetweb.com/excel-unique-function/

So I guess for your version of excel the answer is NO!

Time to learn Advanced Filters?

[AliGW]

So I guess for your version of excel the answer is NO!

This is somewhat misleading! There is no specific function, but of course there is a way pre-2019, however you have to be sensible about it.

@Fred

First, make the data entry table into an Excel table so that it grows as you add lines to it - you should NEVER pre-define thousands of rows in anticipation of data - that's really bad practice. Name the table 'Source'.

Next, use this in H2 copied down:

=IFNA(INDEX(Source[ORDER NUMBER],MATCH(0,INDEX(COUNTIF($H$1:H1,Source[ORDER NUMBER]),0,0),0)),"")

See the second tab of the attachment.

[Fredbugatti]

Hey, Sorry for back and forth, I do have the latest excel version.