Search:

Type: Posts; User: musical1; Keyword(s):

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    9
    Views
    1,429

    RG - That was amazing! I love macros, but I'm...

    RG - That was amazing! I love macros, but I'm very weak in that area of EXCEL.
    That was so fun that I was opening my old data sheets and converting them!
  2. Replies
    9
    Views
    1,429

    Beautiful! While I find Zeddy's formula easier...

    Beautiful! While I find Zeddy's formula easier to addapt, I SO appreciate the date format approach... gives me future ideas.
  3. Replies
    9
    Views
    1,429

    Wow, that was short and sweet! Thank you!

    Wow, that was short and sweet!

    Thank you!
  4. Replies
    9
    Views
    1,429

    Custom formatting assistance

    My spreadsheet contains data that was extracted from BOXI.
    The dates are currently in the following character format: 20110805
    Those numbers represent August 5, 2011.

    My goal is to perform...
  5. Replies
    4
    Views
    2,075

    Thank you! I had danced around so many similar...

    Thank you! I had danced around so many similar attempts, but I was trying to make it more difficult than it was.

    Merci,
    Jody
  6. Replies
    4
    Views
    2,075

    Sum for multiple Conditions; EXCEL 2003

    Attached is my spreadsheet.

    Solution to be on Metrics tab, cel L4
    Solution should be: 119 (The sum of 33 cells)
    Criteria = (DateReceived>=$A4)*(DateReceived<=$B4 )*(Validationor="April...
  7. Replies
    4
    Views
    2,075

    Sum for multiple Conditions; EXCEL 2003

    I used this formula to return the number of times that "Monika" appeared for a given date range.

    =SUMPRODUCT((DateReceived>=$A4)*(DateReceived<=$B4)*(Validationor="Monika"))
    A4 contains my...
  8. Replies
    6
    Views
    2,836

    Steve, this is the approach I was working on when...

    Steve, this is the approach I was working on when your post came though... though I was considerably slower at the coding.

    tfspry, this nailed the true essence of what I was wanting to achieve!...
  9. Replies
    6
    Views
    2,836

    Pivot/Chart: sorting data

    I have a bunch of data that I have collected for a MS office upgrade and I'm trying to sort the data.

    I feel as though I'm missing something simple, but I'm just not seeing it.

    Attached...
  10. Replies
    2
    Views
    419

    Barron, That is sweet! Perfect, TY

    Barron, That is sweet!

    Perfect, TY
  11. Replies
    2
    Views
    419

    Goal: Create a list of contracts and due dates...

    Goal:
    Create a list of contracts and due dates for annual maintenance fees.

    Determine when a contract is coming due in the next 45 days.
    Create a message that warns when the payment is coming...
  12. Replies
    6
    Views
    1,035

    Re: Find/Replace Shading? (2003)

    Hans, that was awesome! I blinked and 22 pages were converted!


    THANK YOU!
  13. Replies
    6
    Views
    1,035

    Re: Find/Replace Shading? (2003)

    Here's a sample of what I am working with.
  14. Replies
    6
    Views
    1,035

    Re: Find/Replace Shading? (2003)

    Reading through the code, it makes sense to me, but it doesn't seem to work.
    My cursor does go to the beginning of the document, but then it just sits there.
    I tried stepping through the code, but...
  15. Replies
    6
    Views
    1,035

    Find/Replace Shading? (2003)

    I have some documents that have 25% gray shading. When we scan the document, it is coming out too dark, SO... I need to replace all 25%Gray with 12.5% Gray.
    I can't seem to create a macro that...
  16. Replies
    3
    Views
    612

    Re: Simplified Formula (EXCEL 2003)

    Thank You!
  17. Replies
    3
    Views
    612

    Simplified Formula (EXCEL 2003)

    For the attached spreadsheet, is there a way to simplify the formula in C2:C5?
    i.e. remove the ISNUMBER function.
  18. Thread: Lookup (2003)

    by musical1
    Replies
    2
    Views
    444

    Re: Lookup (2003)

    THANK YOU! I tried for 2 hours (obviously unsuccessfully).
    It was PERFECT!
  19. Thread: Lookup (2003)

    by musical1
    Replies
    2
    Views
    444

    Lookup (2003)

    I want to take a value ('TC Scenario'!A5), go to another data sheet ('Dose chart'!) and find that value between cells B8:E8.

    Once I have located the associated column, I want to scan down the...
  20. Replies
    5
    Views
    622

    Re: Nested IF/AND with lots of ORs (2003)

    When I first saw your post, I thought to myself... "beginner"... stick to the basics and what you almost know.

    Then, wouldn't you know, I maxed out the space avaliable in the cell (formula too...
  21. Replies
    6
    Views
    465

    Re: Nested IF, AND, OR (2003)

    VERY Helpful!!! Thank You!
    UPDATE: The above tutorial is _wonderful_. Based on your methodology, I was able to create a formula with almost twice the criteria.

    I left out a couple of the...
  22. Replies
    6
    Views
    465

    Re: Nested IF, AND, OR (2003)

    Thank you _again_ Hans!

    I seem to get really twisted up when figuring out where the ANDs/ORs go.
  23. Replies
    5
    Views
    622

    Re: Nested IF/AND with lots of ORs (2003)

    Wow, that had my head spinning!

    Perfect.

    Now to disect/analyse so that I can apply it to others...

    <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>
  24. Replies
    5
    Views
    622

    Nested IF/AND with lots of ORs (2003)

    I'm trying to create a formula for the following:

    IF K15 = "Spontaneous" and 'New Case'!K5="SP" OR "L" OR "HA" OR "SR" OR "SH","OK","Error"
    OR
    IF K15 = "Literature (Spon)" and 'New...
  25. Replies
    6
    Views
    465

    Nested IF, AND, OR (2003)

    What I would like to do:

    Read the value in Cell K19.

    IF that value (in K19) = "Death or Life Threatening"
    AND Cell 'New Case'!K52 OR 'New Case'!K53 = Yes, the true statement should be...
Results 1 to 25 of 213
Page 1 of 9 1 2 3 4