Hi,
I have a large table of data from which I am pulling out random selections.
My first random selection is random-random for which I am using =INDEX($G$67:$G$1092,ROUND(RAND()*COUNTA($G$67:$G$1092),0))
This works perfectly.
Column G has a concatenate of 3 values, vendor+purchase order+invoice
My next selection has to be a random selection of the vendor.
I dont want to be pulling the data into another table, I'd love to be able to get a singular formular to do this.
I have tried inputting Countif instead of count A and using the "*"&"vendor"&"*" - this does not work.
I have also tried nesting the Match function in various locations but this also is not working.
The RandBetween function only works with numerical values as far as I can understand.
Does anyone have any suggestions - all the posts I have read only seem to pertain to numerical values.
Help would be very much appreciated.
Bookmarks