-
I am hoping someone can help. I need the formula to do the following: Column A Column B Column Ctext text number (acct ID) I want to match the text in ENTIRE Colimn B to ENTIRE Colimn A (named account name), when there is a match by account name, write the ACCOUNT ID FROM COULMN C tHANKS!
-
To simplyfie bentleybob's suggestion you can have a look at this add-in: http://www.mrexcel.com/chal/pareto.zip All of the formulas in B are =RAND() functions. Click the checkbox to recalc, and a whole series of dynamic range names cause the chart to redisplay sorted values. It also make it possible...
-
I'm hoping you can help me with a formula. I have a workbook that has 3 tabs. The first is the main log, the second I want to extract certain information on a line that's tied to 2 criteria (product name and tract number) and the third I want to have extract based on 3 criteria (product name...
-
Hi, I've need to derive counts on a large spreadsheet. In the dummy example below, I need to know how many male poodles? How many desexed females etc? Sex Breed Desexed Male Poodle y Male Poodle n Male Alsatian n Female Cairn Terrior y Female Cairn Terrior n Male Smthfield y Female Alsatian n I've...
-
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...