## Solution - Challenge 70 - Find Duplicates and Show the Count

Below is a possible solution to the problem **Challenge 70 - Find Duplicates and Show the Cou**nt

Use a helper column in which put following formula -

=LEFT(SUBSTITUTE(IF(ISNUMBER(FIND("(",A2)),SUBSTITUTE(A2,"("," "),SUBSTITUTE(A2&"-","-","%")),

" ","%",2),FIND("%",SUBSTITUTE(IF(ISNUMBER(FIND("(",A2)),SUBSTITUTE(A2,"("," "),

SUBSTITUTE(A2&"-","-","%"))," ","%",2))-1)

In the last column, put following formula -

=IF(COUNTIF($B$1:B2,B2)=1,COUNTIF(B:B,B2),"")

The solution work can be downloaded from **Solution - Challenge 70 - Find Duplicates and Show the Count**

## Solution - Challenge 69 - Need Help in Not Showing Comments

By eforexcel|Tuesday, February 20th, 2018|Categories: Solutions|Tags: Comments|0 Comments

Below is a possible solution to

Challenge 69 - Need Help in Not Showing CommentsThese are not comments but Data Validation Messages..

Select the cell where pop up message is appearing > Data tab > Data Validation > The pop message is in the Input Message > Either you can remove messages or just say clear all.

To remove them in block -

1. Select rows 1 to 7 > Data tab > Data Validation > Clear All

2. Select rows 20 to 22 > Data tab > Data Validation > Clear All