concatenate if

  1. P

    Concatenate with if conditions

    Hi everybody. I need some help in getting the code to do the follow: 1 CONDITION : if CODE A is repeated 2 CONDITION : if STATUS E is ok then : concatenate invoices & REF but : skipp all double REF. IF THE STRING IS SHOWN ON EACH LAST CODE ONLY...
  2. D

    Concatenate with more than one logical test and multiple results

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

    Concatenate Text with Date plus an IF field that will include date

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

    concatenate IF formula error

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

    Concatif Multiple Criteria

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

    Check incorrect fileds then CONCATENATE

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

    Concatenate column B for duplicate values in column A

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top