concatenate if statement

Can I combine select text from independent responses in different excel cells, similar to how independent clauses are combined in English grammar using commas and conjunctions (Bob is bad. Billy is bad.-->Bob and Billy are bad.)? I have a spreadsheet with values populated by a survey asking...

I have a spreadsheet that lists gifts on a registry in one column. In another column, are potential names of the folks that bought the items. What i'd like to do is, use a lookup formula of some sort to find all the instances of a name (ex. "John Doe") and then combine all of the registry...

Hi guys, I've been a lurker on the forums for a while now and I've gotten some great advice on some of my questions! Thanks for all the help! :) I now have a complicated situtation that I haven't been able to find the answer to. Apologies in advance for the long post; I’m just trying to include...

Hi, i'm using excel 2008 for mac, so i can't run any VBA or macros, just formulas! can any one help me?? i have this cells listed below <!--StartFragment--> <colgroup><col width="65" span="5"> </colgroup><tbody> 1B 1C 1D 1E 1F DRAWING DRAWING...

Hello, I am new to this forum. In the past I have found extremely helpful information. I have a dilemma with a project that I can currently working on that I desperately need assistance on. Issue: I have data that has been broken up into multiple cells; sometimes into multiple consecutive...

Hi guys, can anyone tell me ow can I use an if statement together with concatenate? I have 2 columns A with products and B with key words, so for example I need to look in column A "Shampoo" (may be just in one cell or several) and then if "Shampoo" is found in several cells, I need to...

I need to combine different cells if they meet a criteria. I am basically putting up a list of medals and the whole football team gets a medal and it shows up in different lines, so what i want to do is show just one line with the event and all the athletes in one cell rather than different...

Good Afternoon Excel Guru's, I have moderate excel skills (more like pretty good at Google searching) and I am new to concatenate and I believe this is the best function to use. Monthly I will be pulling reports from a website and exporting to CSV from there it gets (VBA) imported to my...

Hi all, Should be a nice easy one for you experts, i'm trying to do more than 7 IF statements and I understand I need to use Concatenate to get this to work.. however its not working for some reason! Formula is as below =CONCATENATE(IF(A2="Compaq 2510p",(TODAY()-$K$2)/365.25,IF(A2="Compaq...