Recent content by mcalice

Wonderful! Thanks SirJB7, I think this is going to work perfectly!

Thanks oldchippy, I'll try your suggestion and see if I can use it as a manual workaround. If anyone has any suggestions for how to write a formula for this I'd still prefer that as it wouldn't require me to do anything "manually" except for export/import from my database. thanks! Alice

I am trying to separate names into two or more different columns but am running into a problem. My data is in Cell A1 and is formatted as Initials, a hyphen, then the first and last name. There is no space, only a comma, between the next name, so it looks like: JED - John Doe,JMD - Jane Doe...

Just wanted to report back that I found a solution that worked for what I needed! At least most of the way! ---- Anyway it should be possible to solve your problem using MATCH and INDEX. These two functions can be combined to produce a rather more versatile version of the function VLOOKUP...

Just wanted to report back that I found a solution that worked for what I needed! At least most of the way! ---- Anyway it should be possible to solve your problem using MATCH and INDEX. These two functions can be combined to produce a rather more versatile version of the function VLOOKUP...

Just wanted to report back that I found a solution that worked for what I needed! At least most of the way! Sometimes ---- Anyway it should be possible to solve your problem using MATCH and INDEX. These two functions can be combined to produce a rather more versatile version of the function...

and by the way, thank you for pointing out how to reduce the formula! That is very helpful, and as you mentioned, much easier to read!

This formula pulls in a client name, from column P if all of the "IF" statements are true. One of the IF statements refers to the Account Manager's name. Once this client name is pulled into the appropriate place on my dashboard, the following columns are completed using a VLookup. I'm...

The following formula works to pull the name I want from a large list of various client names. IF($AH3="0",IF($AH3>0,IF(O3>=$AJ$15,IF($AG3=0,INDEX($P4,MATCH($AJ$10,$T$3:$T$500,0)),""),""),""),"") My problem is that the list comes into my Dashboard on the same Row number as it is on...

Oh WOW! So I don't even have to use the actual word concatenate?! that's great, and it works perfectly! Thank you for your help Luke!

Here is my formula, and it works great except that the average number has too many decimals! I just want to round it up to the nearest whole number. I assume I should use ROUNDUP, but I'm not sure where to put it in the formula. CONCATENATE("Actual Hours 31% or more under Estimate...

See, I KNEW it would be simple! Thank you so much! I obviously have a problem with "over-thinking" these things! Funny how hard it is to grasp logic sometimes! thanks again, you're a life saver!

Is it possible to add another condition to this? I need to only count the number of items in column a whose date, in column E, is on or after a static date entered in cell AF3. I'm sure there is probably a very obvious solution, but my brain is completely muddled with the various searches...

ok, thanks! I'm using Excel for Mac 2011 and both work beautifully! thanks again to both of you for your quick responses!!

Wow, thank you both SO much - they both work GREAT! Is there any advantage to using COUNTIFS versus SUMPRODUCT or vice versa?