Recent content by dallen43

You could at least filter out replying to other OOO replys.

To get the number of days if the patient hasn't been discharged (as in the last example), you would need the formula as follows: =IF(OR(and(DisDate<StartOfFinYr,DisDate<>""),AdmitDate>=StartOfNextFinYr),"",MIN(DisDate,StartOfNextFinYr-1)-MAX(StartOfFinYr,AdmitDate)) Thanks, Deb

Assuming the model is in row 1 and Individual 1 is in row 4, you can sum the absolute differences in cell E4 with the following formula. =SUM(ABS($B4-$B$1),ABS($C4-$C$1),ABS($D4-$D$1)) Then copy the formula down column E and sort on column E. The result would be: Individual 1 Individual 3...

Dan, I'm not sure if you have already figured it out or not. But following is the way I found to do it. It is rather manual. I created data as follows: A B C 1 Benefit Awareness Importance 2 Health 95 99 3 Dental 74 87 4 Vision...

jalenben1, In your condition, what times indicate met or missed? In your data, is there just times? Or is there additional criteria? Can you please explain what you are trying to accomplish? Thanks, Deb

Thank you Gruuuu. Your explanation is great.

Skip, I don't think I deserved to be slapped like that. I thought I was perfectly clear. I set up the worksheets with the data as indicated in the original post. I copied the formula as written by Glenn and got the error I listed above. I'm not the person who originally posted and didn't even...

jalenben1, Sorry if I wasn't clear. In a workbook, set up two worksheets: sheet1: contains the criteria in cells A1 through B3. sheet2: contains the data. Row 1 contains the headers. Cells A2 through B9 contain the priority and Response Times. Then in cell C2, place the following formula...

Okay, I didn't create the original post, but when I see an interesting solution I try it out so I can learn something. When I tried it, I received the error message "The formula you typed contains an error". I'm using Excel 2003 SP3. I'm sure there is a comma or quote wrong but I can't figure...

jalenben1 On a separate worksheet, I entered the 3 conditions "Critical", "Major" and "Minor" in cells A1, A2 and A3. Then entered the times 0:15, 0:15 and 0:15 in cell B1, B2 and B3. I then selected all 6 cells (A1:B3) and did a Insert->Name->Define and called it "Cond_tbl". In the...

I created a named range "cond_tbl" with the following information: Critical 0:15 Major 0:15 Minor 0:35 Then I used the following formula: =IF(B2<=VLOOKUP(A2,Cond_tbl,2,FALSE),"Met","Missed") It seemed to work for me.

Isn't this just a cell formatting issue? Such as.. Format, Cells, Custom and enter "$#,##0.00 ;$#,##0.00-;" or whatever format is desired. Having the second ; after the negative format causes zero to be blank. Sorry if I didn't understand the question.

The methods discussed above are interesting, but how does this in any way relate to lottery numbers? The randum number generator in Excel may or may not be as randum as lottery balls. Sorry, just a thought.

I have a publisher template that I merge with data and graphics. The merge works okay and the merged document displays. When I go to save as, the merged information goes away (you can see this) and only the template is saved. This worked properly in 2003. Is there any way around this...

In retail, we have WMF1,2,3 t-codes that will do retail price changes. I think there is also VKP5,6,7 that will do price changes.