List of comments

[seanrigby]

A1: John Doe, B1: Jane Doe C1: John Black D1: John Doe E1: John Doe
A2: hard worker B2: lazy C2: short D2: hyper E2: fast
A3: 23


If in A5 I'd put "John Doe", from A6 on down, I'd like to have the list populate every item listed which is associated with his name without any blank cells between them.

For example, A5: John Doe, A6 through A9 would be as follows:

A6: Hard Worker
A7: Hyper
A8: Fast
A9: 23

How?

[Palmetto]

See this recent post for the basic idea of using a look up to find and return associated values. The question in the post is different but the goal is the same.

copy info to form based on date

[seanrigby]

It's a little different than that, because it gives you one result. I need a formula that lists all the results based off of one particular value. Please see an example of what I mean.

[shg]

The easy way would be to transpose the data and use AutoFilter.