Google Spreadsheet Post #890
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 25, 2012
user Guy Pilkinton said:(http://productforums.google.com/forum/?zx=jnm1y5sz2w47#!category-topic/docs/spreadsheets/_mUbRmTuHvk)
Find a name and number in a cell and put the number into the column dedicated to the name.
Hi I want to Find Names and numbers in a cell which includes other text. Then I want to put the number into a cell column headed with the name.
Find a name and number in a cell and put the number into the column dedicated to the name.
Hi I want to Find Names and numbers in a cell which includes other text. Then I want to put the number into a cell column headed with the name.
I want a funtion that will mean L4 reads "7", M5 reads "4", and N6 reads "7". Is there a function that will automatically do this for me?
-------------------------------------------------------------------------------------------------
following is a solution to the problem ... there is a slight discrepancy in your expected response, so I have altered the names in row 1 to match your expected response
No comments:
Post a Comment