Log In
Register
Home
New Member
April 7, 2020
Offline
I was trying several formulas but I wasn't able to find the right formula that will remove the extra spaces due to removal of duplication on the previous cell. I'll be uploading the file here for reference.
October 5, 2010
Offline
Hi,
I'm not sure where these spaces are that you refer to, you haven't been clear. But if you are trying to remove spaces from the start and end of strings you can use TRIM().
Regards
Phil
New Member
April 7, 2020
Offline
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
Offline
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)
