Hi,
I need to get random cases from a list of cases and is using this so far
=INDEX($A:$A;RANDBETWEEN(2;526))
That what is working fine as long as have not filtered.
What I would like to add is to only pick based on the name in Column 3, like if name =" john, paul, sean" as example, but I cant seem to figure it out
Right now as a work around I filter copy and paste in new sheet, would like to avoid that step
I need to get random cases from a list of cases and is using this so far
=INDEX($A:$A;RANDBETWEEN(2;526))
That what is working fine as long as have not filtered.
What I would like to add is to only pick based on the name in Column 3, like if name =" john, paul, sean" as example, but I cant seem to figure it out
Right now as a work around I filter copy and paste in new sheet, would like to avoid that step