hello all
i have attached a Excel sheet where i have four employees in it.
i want to generate atleast 2 random samples of each employee without repeat.
i want that entire row in the output.
please help...
thamks.
hello all
i have attached a Excel sheet where i have four employees in it.
i want to generate atleast 2 random samples of each employee without repeat.
i want that entire row in the output.
please help...
thamks.
you have 19 employees there
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
In the attached example, the samples are in cells A24 and A25
Gary's Student
In this version the complete data is sampled
thanks for the reply but
let me say in the excel sheet which i have posted, from the A2 to A4 cells have the employee details with similar last names (smith), from A6 to A11 (jackson), A13 to A17 (henderson) and from A18 to A19 (douglas).
together there are four last names.
now i need the 2 samples of each last name without repeat.
hope u got my question.
please help
thanks.
Here are two sample of each name
that does not work if a2=Douglas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks