function that returns a list to a single cell
Hello Everyone,
I'm looking for a function that will do the following: Look for a reference in a column, 2010 for instance, and whenever it finds a 2010 in column "a" it returns what is in the same row in column "b" into a single cell in a format like: a, b, d see the example below: 2010 a 2010 b 4030 c 2010 d |
How about a User Defined Function:
http://groups.google.co.uk/group/mic...28f1ba868980a8 or http://snipurl.com/i7q1 AdamMCW wrote: Hello Everyone, I'm looking for a function that will do the following: Look for a reference in a column, 2010 for instance, and whenever it finds a 2010 in column "a" it returns what is in the same row in column "b" into a single cell in a format like: a, b, d see the example below: 2010 a 2010 b 4030 c 2010 d -- Dave Peterson |
Thanks, it worked great.
"Dave Peterson" wrote: How about a User Defined Function: http://groups.google.co.uk/group/mic...28f1ba868980a8 or http://snipurl.com/i7q1 AdamMCW wrote: Hello Everyone, I'm looking for a function that will do the following: Look for a reference in a column, 2010 for instance, and whenever it finds a 2010 in column "a" it returns what is in the same row in column "b" into a single cell in a format like: a, b, d see the example below: 2010 a 2010 b 4030 c 2010 d -- Dave Peterson |
All times are GMT +1. The time now is 04:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com