
New Member

April 7, 2020

Hi Philip,
In between cells this is due the removal of duplicates using this formula : =IF(COUNTIF(G$2:G2,G2)=1,G2,"*")
COLUMN G
@carige.it
@ceresioinvestors.ch
@bancaditalia.it
@bancaditalia.it
@bancagenerali.it
@mediolanum.it
@mediolanum.it
@popso.it
@bancobpm.it
@yahoo.it
@bancaditalia.it
@yahoo.com
COLUMN I
=IF(COUNTIF(G$2:G2,G2)=1,G2,"*")
@carige.it
@ceresioinvestors.ch
@bancaditalia.it
@bancagenerali.it
@mediolanum.it
@popso.it
@bancobpm.it
@yahoo.it
@yahoo.com
ON COLUMN J ( the results that I want it to look like is like this) what formula should I use?
@carige.it
@ceresioinvestors.ch
@bancaditalia.it
@bancagenerali.it
@mediolanum.it
@popso.it
@bancobpm.it
@yahoo.it
@yahoo.com
Thank you so much!

VIP

Trusted Members

December 7, 2016

Hello,
Depending on what version of Excel you use, if you use Excel 365 then chances are that you can use the new functions. Here are some good articles about them.
https://www.myonlinetraininghu.....nique-list
https://www.myonlinetraininghu.....mic-arrays
https://www.myonlinetraininghu.....r-function
https://www.myonlinetraininghu.....e-function
https://www.myonlinetraininghu.....t-function
Also depending on what you are to do with the result, but if you only want a unique list you can use a Pivot Table.
Based on what I see in your sample file I would use Power Query to get needed data.
Br,
Anders
1 Guest(s)
