View Single Post
 
Old 03-03-2021, 12:46 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Not exactly what you asked, but I think close enough!

You can hide helper columns (ones colored differently) in datatable.
Currently when same city is attached to same name several times, all occurrences are returned, and a city counts for every occurrence. Probably it is possible to ignore multiple occurrences, but this will demand much more time than I'm ready to spend.
Attached Files
File Type: xlsx Excel question - updated.xlsx (16.3 KB, 9 views)
Reply With Quote