Is it names only which you need in the column or is there information from
the other columns which also need to be transferred?

"Graycoast" wrote:

BJ,

It is a schedule where I need to extract the time starts and print them by
time start, i.e. all 10am starts would print in 1 column and all 12pm starts
would print in another column.

I tried autofilter, but didn't like the results.

Is there perhaps an "array" function I could use? I've looked and couldn't
find one.

Thanks for the help,
graycoast

"bj" wrote:

depending on what you are trying to do, which unfortuanately I couldn't tell
from your write up, check out advanced filter in help to see if it will do
what you want.

"Graycoast" wrote:

I have a small spread sheet where I have names in column A and various values
in columns B thru H. I need to select a value from column B, have excel
extract the data and copy and sort the names to a new column or worksheet.
I've tried Vlookup and lookup but can't get them to work right.

Is this something I'm going to have to learn VBA to do?

Thanks in advance,
Graycoast