I GOT RESULT 125 IN 'D1' CELL
LIKE ABOVE I WANT RESULT 'ABCDEF' IN 'D1' CELL WHICH EQUATION FOR IT?
Created UDF Function
Step 1: Press ALT + F11 and paste the below code and save as excel macro workbook.
Public Function concateif(a As Range, b As String, c As Range)
For Each cell In a
If cell = b Then
f = f & c.Cells(cell.Row)
concateif = f
In Cell D1, add the below formula
it will return the result as expected.
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.