Search results

Yeah...I deleted my post because I realized what you did :-). Cool! Thanks

What happens if (like in your example) BOTH are in the cell?

Hi Coal Try this on for size. I just used the entire COlumn A for the categories. You can add some data validation to allow multiple drill downs (i.e. Goods>Durable Goods>Autos>etc). However, based on your text above, this is somewhere to start. You can nix the data labels, and mess with the...

Hi there- Can you please be a little more explicit with what you're trying to accomplish? What are you trying to compare?

So simple, yet so great SirJB7!

OOO! I like that Shrivallabha!! Thanks!

Hi Narayan- I tried that, but it was still evaluating the IFERROR portion because W10 was not finding a match in the INDEX/MATCH. However, you did give me an idea for the following...

Hi there- I have a user access form with some data validation that I'd like to have "blank" until a user selects some of the drop downs. However, my current formula is returning the result of the IFERROR condition as nothing has been selected. What I'd like to have happen is if F10 is blank, I...

Yeah...if you just want basic numbers, you can use the Match function on it's own to get the "value". Since they'll be unique you can base your IDs off of that. Be aware though that you also need to create the A2&B2&C2 combo on the 2nd sheet to do the "match". If you post a sample, I can try to...

One approach might be to get a clean list of non-dupes (hence my original approach), number those 1-whatever, then, on your master sheet with the dupes, do a Match or INDEX/MATCH to get the simliar numbers there. Perhaps a sample upload might help? I guess I'm unclear as to what the end result...

Assuming first name is in column A, Surname in column B, Birthdate in column C: Place the following in D2 and copy down =A2&B2&C2COUNTIF($C$2:$C2,C2).

Thanks Bobhc! Also some great links. Much appreciated. I assume you are a Newcastle fan?

There is SirJB7. And yes, that did in fact answer my question. As always, your help is appreciated. I'll send over some Carlsberg....

I've seen most websites suggest the INDIRECT() method when it comes to using dependant validation filters. However, can someone explain why the Offset approach doesn't work for the second drop down to create a dynamic range? Do Volatile functions not play well in this format? Or, does it work...

Here's what Sajan is talking about (I believe). I've created the named ranges as well (Team, Actual, Achieved, Total). You can simply do a lookup into these columns based on the ranges. One thing I've learned is that data layout is tantamount to getting the right results, and being able to...

Xiq- That's the first time I've seen the =MAX($A$1:$A1)+1 used to start numbering a list. I really like that! Thanks for sharing!!

Hi there- I have some data validation columns (3 total) set up, with the third column dependant on the first two. However, that third column is a dynamic list as a result of the first two selections. The dynamic list is populated by the following formula...

Hi there- Would something like this work? =IFERROR(INDEX(Sheet2!$A$6:$A$27,SMALL(IF(Sheet2!$C$6:$C$27=Sheet1!$A$11,ROW(Sheet2!$C$6:$C$27)-ROW($C$6)+1),ROWS(Sheet2!$C$6:$C6))),""). This should be entered as an array formula Ctrl+Shift+ Ent), and dragged down as far as necessary. Adjust the...

Wonderful work Sajan. Really neat formula.

What about checking the box "values in reverse order" as an option in Format Axis? Is that what you're looking for?

Ok. I see what you're saying. I can just keep it the way it is, as after looking at it a few times, it's fine as-is. Other changes I can make manually if necessary. Again, much appreciated!

(sorry, for some reason, I cannot edit my previous post, so this is a new line) or if they WERE, say, 100% & 100%?

SirJB7- Is there a way to add another icon/argument when the two "overlap" (not necessarily equal, but, in the same range...26% & 37%)? Say, a green circle in a black square?

WOW. JUST, WOW. Thank you very very much! I sincerely appreciate it!!! I will mess around with it, and post back if there are any issues.

Hi SirJB7 - do you need anything else from me, my good man?