• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. gonsalvr

    VLOOKUP Malfunction

    I have now just come across a new issue in my Random Drug Testing spreadsheet. I have a VLOOKUP formula that keeps dropping off my last two values. If you count Column C it contains 112 names. When you compare that to the Column D it only lists 110 names. I have spent the last two days on the...
  2. gonsalvr

    Random Name Selection for Drug Testing

    Chandoo et al, I'm working on a project where I'm trying to build a random name selection tool for one of our medical units that requires drug testing. The randomness is in name selection only. Every name on the list must be tested every month. Since this is a rehabilitation unit, admissions...
  3. gonsalvr

    Create Guid's Using a Formula??

    I have a spreadsheet that identifies my patients for internal purposes using personal information, but if I do a request for an x-ray or MRI I can't use Private Health Information to track. I would like to create a Unique number, that does not recalculate everytime you click on another cell in...
Back
Top