LinkBack URL
About LinkBacks
Good morning to the community
I work on the file "Test".
I would like to calculate the number of unique values in the data range A2:D48 and display the result on the cell E1.
The result should be 60.
Thank you very much for your help!
Good morning to the community
I work on the file "Test".
I would like to calculate the number of unique values in the data range A2:D48 and display the result on the cell E1.
The result should be 60.
Thank you very much for your help!
Last edited by Luu4466; 02-06-2023 at 09:04 AM.
The file uploaded does not look like the image and has a formula in column D.
Please review the sample file.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry TMS for this failure in the upload.
Thank you for your help.
I edited the correct file.
How aboutwhich comes to 58 not 60Formula:
Please Login or Register to view this content.
Thank you Fluff13, you formula is working perfectly. In France, it is
Please Login or Register to view this content.
Last edited by Luu4466; 02-06-2023 at 10:15 AM.
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks