Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dallen43

    Outlook 2003 - How to use Rules to replace Out Of Office

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

    Calculating Days Across Fiscal Years

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

    Excel 2007 Find closest match in multiple records

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

    Excel Graphs

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

    Formula

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

    Excel - reference a cell with a tab name to be used in formula

    Thank you Gruuuu. Your explanation is great.
  7. dallen43

    Excel - reference a cell with a tab name to be used in formula

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

    Formula

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

    Excel - reference a cell with a tab name to be used in 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...
  10. dallen43

    Formula

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

    Formula

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

    Excel Formula Display in Cell

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

    Need formula for Random ##'s within range AND Relative to each other

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

    Save As after Mail Merge in 2007

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

    Useful transaction for MM

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

    Microsoft Access -- Updating a Field with &quot;Cumulative&quot; Data

    Maybe I'm missing something, but why can't you just use the formula in F2 and copied down the column? =IF($A2=$A1,$F1+$E2,$E2)
  17. dallen43

    Fehlende Berichte

    To find data in SAP isn't always easy. Do you know how to use the ABAP Dictionary? If not, you should take BC430. Using this you can search for different tables. If you can see the data in a field on the screen, (but not in a report) try putting your curson on the field, pressing F1 and then...
  18. dallen43

    Sliding Linear Scale

    The above formula "=Base + (Bonus * ((Clinic-Lower) / (Upper-Lower)))" works as long as the clinic percentage is between 20 and 50. You need to add "if" conditions to handle less than 20 and more than 50 conditions.
  19. dallen43

    Fehlende Berichte

    Your question is rather open ended, but here are some suggestions: 1. If you are a programmer, you should be able to write custom programs in ABAP to get exactly what you want. 2. Use SQ01 to create a SQL query report. This may be shared between users. 3. Use SQVI for a quick SQL query...
  20. dallen43

    Excel - Wrap Text

    Sometimes when I select "Wrap Text", it seems I need to go back into the cell (like you are editing) and press the Enter or Tab keys.

Part and Inventory Search

Back
Top