+ Reply to Thread
Results 1 to 5 of 5

Excel Shifu.. need your favor

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    Malaysia
    MS-Off Ver
    2007
    Posts
    0

    Excel Shifu.. need your favor

    I currently stuck to create a template form for my clinic reception..
    need Excel shifu for me to use proper formula..

    There are plenty of Medical test type but need to use excel to specify which test for which patient.
    for Eg:

    Shell OME (Contractor)
    1)Physical Examination
    2)Blood Test/LAB
    Complete Blood Count
    Blood Group (Rhesus)
    Fasting Blood Sugar
    Urea
    Creatinine
    Sodium
    Potassium
    Chloride
    Fasting Serum Lipid
    Urine Feme
    3) Urine Test
    a)Amphetamine
    b)Cannabis
    c)MDMA
    d)Morphine
    e)Benzo
    4)Chest X-Ray
    5)Audiometry

    Petronas Contractor
    1)Physical Examination
    2)Blood Test/LAB
    Complete Blood Count
    Blood Group (Rhesus)
    Fasting Blood Sugar
    Urea
    Creatinine
    Sodium
    Potassium
    Chloride
    Fasting Serum Lipid
    Uric Acid
    Liver Function Test
    Hepatitis B Screening
    Urine Feme
    3) Urine Test
    a)Amphetamine
    b)Cannabis
    c)MDMA
    d)Morphine
    e)Benzo
    4)Chest X-Ray
    5)Audiometry

    Lets say i select Shell OME Contractor from the drop down list..
    I need the excel to display type of test need to be done

    i tried this
    =IF(ROWS(C$11:C11)>=COUNTA(INDIRECT(C$10)),INDIRECT(C$10),"")

    What i get is #REF!


    Tq Guys

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello hishamows89,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    07-03-2014
    Location
    Malaysia
    MS-Off Ver
    2007
    Posts
    0

    Re: Excel Shifu.. need your favor

    Hye Arlu1201..
    Tqvm.. appreciate that..
    Any comment on my post up there..

  4. #4
    Registered User
    Join Date
    07-03-2014
    Location
    Malaysia
    MS-Off Ver
    2007
    Posts
    0

    Re: Excel Shifu.. need your favor

    Finally.. i manage to solve this..

    Thanks to this helpful video
    http://www.youtube.com/watch?v=uu1YbyZhjSI

    Anyway.. Thanks

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Excel Shifu.. need your favor

    This is the intro forum, hence you shouldnt post questions here.

    Glad you solved it though.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. do me favor...
    By raveepoojari in forum Excel General
    Replies: 1
    Last Post: 12-03-2009, 01:55 PM
  2. I need a HUGE favor from anyone. Please
    By dmh in forum Excel General
    Replies: 3
    Last Post: 12-05-2008, 07:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1