willhelm654
New Member
- Joined
- Jan 11, 2020
- Messages
- 7
- Office Version
- 2013
- Platform
- Windows
Hi All,
I have a table that I woul dlike to use to forcast jobs by date and I want to combine all the text from cells in column A when the dates in Column B are the same into Column C. See table below.
I have tried playing around with =IF($B8=$B9,CONCATENATE(Table1[@Description], $A9),"") but it only combines two cells and I cant think of a way to make it do all.
Thanks for your help,
I have a table that I woul dlike to use to forcast jobs by date and I want to combine all the text from cells in column A when the dates in Column B are the same into Column C. See table below.
I have tried playing around with =IF($B8=$B9,CONCATENATE(Table1[@Description], $A9),"") but it only combines two cells and I cant think of a way to make it do all.
Thanks for your help,