-
I have 2 worksheets. WkSht1 has 1 column A Client name Bob Tom WKSHT 2 has two columns Col. B has multiple client IDs per Client in Col. A A B CLIENT CLIENT ID Bob B123 B456 B789 Tom T321 T654 T987 There are variable numbers of IDs per Client I need a lookup to match on the client from WKSHT1 and retrieve...
-
Last week I was on holliday and we had to divide 3 bottles of wine among ten friends. We could have written our names on little papers and draw 3 names from the lot, but why do something like that when you have a computer with excel. So I wrote a array function that returns a permutation from a set of...