So, I'm using Google Sheets to study UK railway timetables to try and work out how many unique stations are served by trains from a particular railway station. The example I'm showing is of my analysis of London Euston station. It is laid out as follows: However, I'm now trying to filter this spreadsheet so I can get a concise list of the 45 counted unique stations, but I believe the =UNIQUE function works in rows or columns rather than the desired cells. I have already researching how to do it, but Google isn't being very helpful and is always leading me down the =UNIQUE pathway. Is there any way to do what I'm trying to do in Google Sheets?
Screenshotted below is my latest attempt, following yet another tutorial from Google, and yet again running into the "Would overwrite data in another cell" error from Google Sheets.
You may try:
=unique(tocol(B3:AF30,1))