CONCATENATE by criteria and range

H

Herbs

Wondering if there is a simple formula to concatenate row 1 values based on
the criteria of "df" for each date. This formula could be placed in another
column. Realize that eventually there will be upto 70 people and 365 Days.

A B C E
Bill Joe Frank
1-Jan-10 df df
2-Jan-10 df df df
3-Jan-10 df
4-Jan-10 df
5-Jan-10 df df
6-Jan-10 df

The desired outcome would be something like this:
1-Jan-10 Bill, Frank
2-Jan-10 Bill, Joe, Frank
3-Jan-10 Joe
4-Jan-10 Bill
5-Jan-10 Joe, Frank
6-Jan-10 Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs or a pivot 1
How can count the number of cells that fulfill certain criteria in other cells 2
Sort anomaly in Excel 2003 SP2 on Windows XP SP2 1
sum by criteria 3
Find the position of a date 6
Average Forumula 4
Projected Dates.... 0
Projected date in Excel 0

Top