Hi all,
I would appreciate any help on this issue:
I am trying to select a random row from a list of rows in excel, after the rows have had an AutoFilter applied to them.
I have round the function to select a random row (with the help of INDEX) and RAND(), but I want the function to work on the filtered results, not all the results.
Any help of the matter would be greatly appreciated!
George
PS: I have uploaded the spreadsheet for convenience
Bookmarks