Search results

Nebu, Thank you for such a quick response. Now that the crisis is over, Does VLOOKUP have a limitation on how many rows it can view? Potentially this unit can have 118 patients. Should I modify the formula to accept 118 rows? Average census runs in the eighties, but I will not be the one...

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

Chihiro, I have made some progress. I managed to Create random values and ignore blank cells plus added code/function to cell J2 to stop volatility. The staff just has to change that zero to a one press F9 and then change back to zero and all data is static. I managed to insert a monthly...

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

SirJB7, Thank you. From my research, it was looking like I will have to take a crash course in VBA and learn how to insert code into an Excel module. This database is an ongoing live tracking tool of care. So yes as we add or remove patients we do insert rows and delete rows etc., and that...

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