oreo haven
Board Regular
- Joined
- May 15, 2008
- Messages
- 65
OK,
So I have a group of rows with identical information (Column A). Column E has different info (in a query I ran, every line of data was listed in a new format). I need to concatenate E, but only if the cells in A are identical. Here's the kicker, it is not always the same number of rows.
Is this possible with a simple formula? Does anyone have a Macro that would fix this?
Thanks
Jon<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]
So I have a group of rows with identical information (Column A). Column E has different info (in a query I ran, every line of data was listed in a new format). I need to concatenate E, but only if the cells in A are identical. Here's the kicker, it is not always the same number of rows.
Is this possible with a simple formula? Does anyone have a Macro that would fix this?
Thanks
Jon<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]