RA 1.42 Sonar Profile XLS layout

Pisces · 07-26-17, 03:22 PM

Imho, the order in the list does not matter. Select all the columns and use the sort and filter function of Excel (2010, but all versions have it I think). Then you can select all applicable frequencies from a pull-downlist when you click on the column header. Or better you can even use compound relational filters (frequency larger than X and lower than Y). Only those rows with frequencies (cell values in general) that match show up in the list.

07-26-17, 03:22 PM	#1
Pisces Silent Hunter Join Date: Dec 2004 Location: AN9771 Posts: 4,904 Downloads: 304 Uploads: 0	Imho, the order in the list does not matter. Select all the columns and use the sort and filter function of Excel (2010, but all versions have it I think). Then you can select all applicable frequencies from a pull-downlist when you click on the column header. Or better you can even use compound relational filters (frequency larger than X and lower than Y). Only those rows with frequencies (cell values in general) that match show up in the list.