Search results for query: *

how do I do average in column that has data but exclude the cell that don't have data? Thanks in advance

hi i want field A-(field B + field c + field d)and if the result is positive then enter result in field E and if negative then enter field F. Please help Thank You in advance

Is there the way in excel file when I move a mouse over the cell then the comment popup but the list is in other worksheet? for example in the worksheet A when I move the mouse over cell a1 then the comment from worksheet B cell a1 popup. Thanks for your helps

How do I create the if funtion that if field A Field B Field C a 10 b 5 c 10 d 8 I like to make Field C that if field A is a then field B*.2, if field A is b then field B*.4, so on Please help Thanks

Thank you skip

how do I replace data from 1 cell from one to another example: col1 col2 1 a 2 b 3 c I like to replace in col1 cell2 with data from col2 cell2 so in col1 look like this col1 col2 1 a 2 b 3 c Thanks for your help

Thanks Zathras.. it close to what I want but from your I figure out =IF((AND(a1>5,a1<11))*(b1>=2),1,0) and it work for me Thanks again

colA colB colC 12 3 11 1 in colC I try to get if a1 has value is >5 but < 11 combine with b1 >=2. I use =if(a1>5<11)*(b1>=2) but result in c1 is 0, what do I do wrong...please help

I need help... I try to using the macro on excel and in the script include open new worksheet, so when I execcute it give me debug at Windows(&quot;Book23&quot;).Activate I have to change the book to one numer ahead to make it work. what should I change so it work and I don't have to debug...

I finally got it work but not complete... How do I keep the reccord number in whole like 00001 instead 1... my reccord number is auto serial Left(Institution,1)&Reccord number&Left(Tissue type,1) & number sampling&Left(Speciment type,1)&&quot;-&quot; & Left(Lesion pancreatic,2 )

cell A1 is 00001 cell B1 is c in cell c1 I enter: =b1&a1 then result is c1, is there a way that can give me a result as C00001 Thanks

I try to make a drop down list when I click the cell but have no I idea how.. please help

Hi schlogg, I have try this but it said too few )? here what I try: case(left(Institution)&(Reccord number)&left(tissue type)&(number sampling)&left(speciment type) please help

Hi Schlogg, Thanks your respond I try your sugest but it's not work... Here my real situation: field1 is INSTITUTION: University or Work field2 is RECCORD NUNBER: auto number start from 00001 field3 is TISSUE TYPE: Tumor, lymph node,.. field4 is NUMBER SAMPLING: 1, 2, 3, or 4 field5 is...

ow do calculate the age from date of birth in excel? Thanks

I have 5 fields a b c d e and F. b is containe YES or NO c is number validation auto generate start with 00001 d is contained DOG, CAT, or CHICKEN e is contained Number of animals f is contained LIVE, DEATH, or SICK in a I lke to have result like this: - if b is YES then enter Y00001 -...

colB and colC has to match to each other first and use the match value to see where it stand in colA and put the value there

in the first post

what I like to do is to find the value in colC or colB match to each other(like 2b and 4d) with the match value then match again with colA and result in the same row of colA but in colD

colA colB colc colD 1a 2b 1a 2b 3c 2b 2b 3c 4d 4d 4d 5e 5f 4d Please help, what is function that I can use in colD that the value either in colB or colC match each other and if...