Hello Excel friends
as you can see from this picture i need to extract the unique duplicates value
as you can see in this case are only 2
I have excel 2016
Please only with formula, because i'm learning formula
\1
Hello Excel friends
as you can see from this picture i need to extract the unique duplicates value
as you can see in this case are only 2
I have excel 2016
Please only with formula, because i'm learning formula
\1
Last edited by GerryZucca; 09-13-2020 at 05:04 PM.
Hi
Try this approach with two helper columns.
In H3 use the following formula and drag down to H12
Formula:Please Login or Register to view this content.
In I3 use and drag down the following formula
Formula:Please Login or Register to view this content.
In D3 drag down and forward the following formula
Formula:Please Login or Register to view this content.
See the file for clarification
hi Jose
Works fine, it's ok with the helper column..
Thanks so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks