bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
Hello
My range of data is E12:E75 in worksheet "Data" contains city names (they repeat a few times)
In my "Calculation" worksheet, I would like to show the names only appear once from the list in E12:E75.
Is there any formulas? can someone pls advise.
thx you!
My range of data is E12:E75 in worksheet "Data" contains city names (they repeat a few times)
In my "Calculation" worksheet, I would like to show the names only appear once from the list in E12:E75.
Is there any formulas? can someone pls advise.
thx you!