Thank you! I am very much a novel in Excel, compared to you guys.
I am no longer at work and do not have the dataset with me atm (it's confidential), but I think your construct would work, XLent.
It is a very elaborate construct, that I would never have been able to do myself. Not really sure I actually understand what is going on in this construct, but it seems like it is working.
In the real dataset I have exactly 15 different diagnoses, so the Diag.Key is perfect.
However, in the real dataset I also have several hundred patients. So to use your construct on the dataset, I should expand the data areas covered in the key syntax, as well as in the "With" and "+# other" syntaxes? Perhaps if I remove column headers of the dataset I could just mark up the whole column? I.e. for the key syntax? Or perhaps marking the whole (infinite) column for calculation is a bad idea for the sake of my CPU memory?
Again, thank you. Your help is very much appreciated.
Bookmarks