Recent content by 3G

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...