Need help to find Customer names that has same values

[Richmond88]

For GOOGLE SHEETS

In my spreadsheet that I have attached, some of Customer A to K have the same sales value.
How do I show multiple customer names that has the same values (Column highlighted in orange)
Right now it shows the first customer that has that certain value

[oeldere]

1 option

With a pivot table.

See the attached file.

[wk9128]

Cell E3 formula

Please Login or Register  to view this content.

Only cell F3 formula , Drag down

Please Login or Register  to view this content.

[Richmond88]

Cell E3 formula

Please Login or Register  to view this content.

Only cell F3 formula , Drag down

Please Login or Register  to view this content.

Thanks alot! It works on excel, but I'm trying to use it on Google Sheets. Any way to work around this because Google Sheets doesn't have the aggregate function

[wk9128]

Hi Richmond88

Never used GOOGLE SHEET FUNCTION , GOOGLE SHEET FUNCTION can accept ARRAY FORMULA ?

cell F3 but array formula , Drag down

Please Login or Register  to view this content.

[HansDouwe]

An other way try this formula:

Please Login or Register  to view this content.

Or if you want the columns to be the other way around, use 2 separate SORTBYs:

Please Login or Register  to view this content.

[AliGW]

Thanks alot! It works on excel, but I'm trying to use it on Google Sheets.

1. No mention of this in your opening post!
2. Yoour forum profile tels us you are using Excel 365.
3. You posted in the Excel section of the forum.

Not really surpsrising, then, that the solutions offered are for Excel!

I am moving this to the correct forum section.

[Richmond88]

Hi Richmond88

Never used GOOGLE SHEET FUNCTION , GOOGLE SHEET FUNCTION can accept ARRAY FORMULA ?

cell F3 but array formula , Drag down

Please Login or Register  to view this content.

Thank you! It works now

[Richmond88]

An other way try this formula:

Please Login or Register  to view this content.

Or if you want the columns to be the other way around, use 2 separate SORTBYs:

Please Login or Register  to view this content.

Sort Function is much easier and simple, thank you for solving my problem

[Czeslaw]

Fornula

Please Login or Register  to view this content.

[wk9128]

@Richmond88 You're Welcome. Glad to help . Thank You for the feedback and rep.