Hi guys,
I have a problem with a spreadsheet. I'm not new to excel as I have enough experience, but I think this problem is a little bit too big for me to solve. First let me introduce the problem, i have the following situation:
Column A | Column B
Henry First | 1212121
Derek | 3424243
Bas | 8969869
Henry Second | 7698698
Henry Third | 7877868
What I need is the following I want to return the value of column B for every row which contains "Henry" in column A, and these values have to be seperated with a comma.
So it needs to be a sort of VLookup.
It should return 1212121,7698698,7877868 in a cell when I look for Henry.
I'm not familiar with Visual Basic and macros, and I'm actually not using excel as I'm using open office calc.
I hope someone can help me.
Kind regards,
Joey
Bookmarks