Search results

Thanks Deb!

Hi there- I have a formula that works perfectly fine with normal ranges. I've decided to add dynamic ranges so I don't have to manually update them when I paste the new data into the worksheet. However, since converting them, my formula doesn't work. If I convert one of them to a normal range...

It's all good. Both suggestions that I got worked.

Hi Deb - It is similar, but a different solution (I put that in my first post of this thread). I didn't want to piggy back onto that post, as this is a different request. If mods prefer that I'd have added onto the previous post, then going forward I will do that. Thanks!

Shrivallabha If I wanted to add one more criteria to this would it look like this? =SUMPRODUCT((ISNUMBER(SEARCH(A23,Theme_All,1))*1)*(DDR="Care:R1")*1) Where DDR is another criteria, and 'Care:R1' is one of 5 values. Thanks!

**EDIT** This works great!!! Thanks folks.

Thanks folks! Faseeh - I tried something similar to that, but didn't have the "*". Is that a wild card? Good to know I was on the same track! Thanks!

Greetings- Similar question I asked here : http://chandoo.org/forums/topic/sumproduct-question-2 I've got a list of 7 items (A2:A8). On another sheet, I have cells that have multiple combinations of these 7 items. I basically need to count the number of occurences of each item. Data looks...

Luke you're the man...man. Nice job!

if you google Indirect, Contextures has an excellent tutorial on this exact topic. In fact, some of the examples even use your similar criteria. http://www.contextures.com/xlFunctions05.html#DataVal

SUMPRODUCT is a pretty awesome way to do this. There are a LOT of posts around this approach. Search in the google search under SUMPRODUCT. Chandoo even has some excellent blog posts and examples! I'm learning more and more SUMPRODUCT is my best friend a lot of times!

Nice. All of 'em. Thanks y'all!!!

Much appreciated guys. My data was as follows: A | B Status | Packages Approved | Firewall, Consulting Services Approved | Software, Firewall, Consulting Services Submitted | Software,Consulting Services Pending |...

HI there- I have the following formula: =SUMPRODUCT(([@Status]="Approved")*(([@[System Solution]]=FIND("Software",[@[System Solution]],1)))) It's working, as I'm getting "VALUE" for those that do not have the value "Software" in the System Solution column, and a "0" for the ones that do...

Hey Shrivallabha- This is a really cool solution! 3G

Not an Excel expert by any means myself (which is why I'm here too :-)), but, most of my comments are around the appearance. I'd suggest adding some titles to your charts & the dashboard itself (Student what?) so the viewer knows what they're looking at. Also, some borders around the entire...

If you search like bobhc said, there are plenty of examples of simple dashboards. The first result is every post Chandoo has done about dashboards. If you look through them you will find his simple dashboard approach, as well as detailed steps on how to create them. In fact, the google search...

Can another option be to add the classification column. Then, simply use the text filter on the column with those key words. finally add the classification in the column, and simply copy down on the filtered items. Just another way to possibly skin a cat.

This is really cool!

Combination of INDEX & MATCH as you reference in the OFFSET function would probably do this, or, you could just use INDEX if either column is unique

Yeah...assuming all conditions are the same.

Hi NARAYANK991 - How could you increase the number of characters on either side? Say the list was: Alpha 31: Beta 1944: Delta 323: I understand you need to update the array of "A" "B" "C" to now include "D", but, say the numbers are now more complex.

That, I cannot answer sorry.

Faseeh's post is a perfect Formula Forensics entry!

You could always embed the index formula into an "IF" statement..something like IF(NamedRange>1,INDEX('Specs'!$B$2:$CW$69,ROW($A1),MATCH(C$7,'Specs'!$B$2:$CW$2,0)),""), where NamedRange is $B$2:$CW$69.