Hi all,
Please take a look at my attached spreadsheet.
I need to select 50 of the records that are marked Paid in column EE, by clicking the corresponding cell in column EG - I have already selected 48 (marked RK) and tallied in cell EN2. The macro would then randomly select 13 of the remaining Paid records and mark them RD.
However, the value in column EC should be greater than 10.00 in order for that record to be randomly selected, and only if there are not enough records satisfying that condition would other records (i.e., whose value in column EC is less than or equal to 10.00) should be selected in order to reach the required randomly selected 13 records.
Any help, please?
Thank you,
Gos-C
Bookmarks