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.
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.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks