concatenate if

I'm looking for a way to compare a text string or cell address to a column of possible matches. Then I want to concatenate notes from every row that has a match, but only if a logical test is true. A UDF would be perfect. I've seen one from Rick Rothstein mentioned a couple times now, but I...

Hi, I have a start date and an end date. Sometimes the end date is blank. I want the end date to read Pres if there is no date. =""&TEXT(E2,"yyyy")&" - "&IF(F2="","Pres",F2) F2 is the end date - so it part way works: 2005 - Pres if F2 is blank. But if it isn't blank how can I get it to...

I am trying to use a concatenate if text is present but the text to display if value is false is not appearing correctly. Can someone tell me how to correct my formula? F8 has multiple data about how peaches feels (ie happys, sad, mad etc). If this is not blank then I would like to have G8...

Hello, I have the following VBA code set up to work the same as a sumif, but I need to be able to utilize the concatif formula under multiple criteria, i.e. Sumifs. Can this be expanded as such? Function ConcatIf(ByVal compareRange As Range, ByVal xCriteria As Variant, Optional ByVal...

<tbody> A B C D E F 1 John James 2 2A MIPA 8XXY =IF(B1,C1,D1 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A1,B1,C1,D1]) 2 John James 2 2A MIPA 8AMN =IF(B2,C2,D2 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A2,B2,C2,D2]) 3 John James 2 2A MIPA 8NOP =IF(B3,C3,D3 NOT EQUAL TO...

I swear I have done this before, but I can't remember what I did. I'm sure I would have done it with a formula or ASAP Utilities and not a macro. Maybe someone can jog my memory! I have the following type of data in columns A & B: <TBODY> 10017</SPAN> 86703</SPAN> 10017</SPAN>...