Hello everybody
I have values in Range("G4:G79") There are duplicates for every value ..
I want to get rid of duplicates except for the first value
for example : In range("G4:G22") there is the value 15 I want to clear all the values of 15 except the first which is in G4 and so on for the rest of values
And if the value is unique remains as it ..
The results should be in its place not to collect all uniques ...
G4 = 15 and blank cells till G23 =20
Here's an attachment
Bookmarks