Hey guys!
I'm trying to add a column of text values together if a certain condition is true. For example, if Client = Red, than the Output Cell = Output 1; Output 2; Output 3; Output 4.
I tried using sumif and a combination of Vlookup, but can't get it to sum text. Any help would be greatly appreciated.
-Thank you!
I manually outputted a table "Results Example" to show what the final table should look like, with the Output cells as B18, B19, and B20.
Screen Shot 2016-05-10 at 6.40.54 PM.png
One approach
In D3 enter
=IF(A3<>A2,C3,D2&"; "&C3)
Copy this down and copy the last D cell in each client number and Paste Special Values.
You could use a helper column to identify the last row in each block, e.g. =IF(A3<>A4,"Last","") and filter this column so that you can copy all the last cells in each block in one go.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Another option could be to use this Function from post #7
HTH
Regards, Jeff
Thanks guys, this really helped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks