Recent content by TechSlinger

Hello I am using Crystal 11. I have a database of diagnoses in "long format". Diagnoses have "types" i.e. most responsible, post admit, pre admit etc. The data I'm trying to get at is where a list of codes that are certain types cannot also be other types. So if code I63.0 is a type M it...

Okay thanks....anyone else have a suggestion.

Thanks for the input but with 200+ worksheets and 30 cells per worksheet I would much rather come up with data validation rule....plus I do not know how to write a user defined function and I already have a huge amount of code in the on change event.

Hello I am using Excel 2010 and I'm trying to find a way to limit entries via data validation function. The code in the cells are between 7 and 10 characters with the format of NAANNAA for the first 7 characters and the last 3 could be numbers or letters. The validation for this is cells N78...

No problem, Skip, thanks for letting me know. And Happy Retirement!!

Yo Skip, are you able to help? I'd really appreciate any assistance you can provide. Thanks.

Hi Skip or anyone else Anyone able to assist me with this? Thanks.

Hi Skip I responded to the post as you requested but haven't heard back. Are you still able to assist? Thanks.

Hi So is anyone able to help with this query? Thanks very much.

Hi I am using SAS 9.3. I have a dataset that is made up of many data elements of a patient visit - one line of data is one abstract. There is the original dataset from the submission and then many correction files. All files have all the same data elements so even if the field isn't being...

Hi Skip Thanks for responding. No I haven't created anything yet, was first asking about approach to then know how to proceed. My thought about table structure is that I would have one column per requirement of the Action Plan, with most being text/memo fields. This is to house the data but...

Hello I have a dashboard created in Excel 2010 (file extension is xlsm). It has the 12 months of the year for 10 different metrics. Conditional formatting compares the monthly results to the target cell and shows red or green depending on the results. I now want to incorporate performance...

Thanks for the tip, Skip. The file extension is xlsm and I will note that in the other post.

Hello I have a dashboard created in Excel 2010. It has the 12 months of the year for 10 different metrics. Conditional formatting compares the monthly results to the target cell and shows red or green depending on the results. I now want to incorporate performance measurement tracking but not...

Hi Charliy Not sure what you're asking but I have 3 groups: 1. ServiceGroupName - i.e. medical, surgical etc. This is the group (in the footer) where I want to be able to create this text note about the findings. 2. Day of Week - 2 possible results of either weekday or weekend 3. Type - 2...