Hi all - is excel clever enough to: Unique range, filtered for greater than zero/blank, sort ascending AND return all the values in ever other row? if so, how would that be done?
e.g:
1
miss a row
2
miss a row
3
miss a row....etc.
many thanks.
e.g:
1
miss a row
2
miss a row
3
miss a row....etc.
many thanks.