Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: workshop
  • Order by date
  1. workshop

    average with some empty cells

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

    if

    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
  3. workshop

    popup comment

    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
  4. workshop

    if function

    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
  5. workshop

    replace data

    Thank you skip
  6. workshop

    replace data

    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
  7. workshop

    colA colB colC 12 3 11

    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
  8. workshop

    colA colB colC 12 3 11

    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
  9. workshop

    macro

    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...
  10. workshop

    Result

    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 )
  11. workshop

    number

    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
  12. workshop

    drop down list

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

    Result

    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
  14. workshop

    Result

    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...
  15. workshop

    formula

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

    Result

    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 -...
  17. workshop

    colA colB colc

    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
  18. workshop

    colA colB colc

    in the first post
  19. workshop

    colA colB colc

    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
  20. workshop

    colA colB colc

    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...

Part and Inventory Search

Back
Top