+ Reply to Thread
Results 1 to 8 of 8

Formula requiring three actions

Hybrid View

  1. #1
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,445

    Re: Formula requiring three actions

    Hi,

    Find the attached where your data is easily displayed using a Pivot Table. I think you should study Pivots a while and see if they can't do what you are wanting and with much more ease.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  2. #2
    Registered User
    Join Date
    05-27-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula requiring three actions

    Marvin, thanks for the help. What I sent was just a detail from a 5-page report, so a pivot table won't work in this case unfortunately. What I can't understand in the file you sent was why the formula generating the "43" works for Northeast, but when I key in Northwest, I get a FALSE. It seems to be taking the first instance of two variables but not matching all three. Do you see what I mean?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1