alphabetize - automatically

M

mandyjo830

I have a column (A) on a worksheet (2) that is linked to another spreadsheet
(1) for all the available name spots. So, this column (A) won't necessarily
have every cell filled in. I want to alphabetize this list and omit the
blank cells. I also want that put into 2 columns (B & C) instead of 1. The
ending columns (B & C) will grow and shrink according to how many people are
in the original list. Also, I want to omit the duplicates. The worksheet (1)
that these names are on is the data entry sheet for who is doing what for a
seminar. So, a person could be in two different areas on the sheet (1) and
thus, end up twice on the column (A) on the worksheet (2). Any ideas?
 
M

Mandy J.S.

mandyjo830 said:
I have a column (A) on a worksheet (2) that is linked to another spreadsheet
(1) for all the available name spots. So, this column (A) won't necessarily
have every cell filled in. I want to alphabetize this list and omit the
blank cells. I also want that put into 2 columns (B & C) instead of 1. The
ending columns (B & C) will grow and shrink according to how many people are
in the original list. Also, I want to omit the duplicates. The worksheet (1)
that these names are on is the data entry sheet for who is doing what for a
seminar. So, a person could be in two different areas on the sheet (1) and
thus, end up twice on the column (A) on the worksheet (2). Any ideas?
Click to expand...

That was my original question. I have searched the net and have found this
formula to eliminate the blanks, but it isn't eliminating the blanks. I
think the problem is that the range contains formulas. So, how do I get it
to eliminate the blank results and then alphabetize them?

Here's my current formula:
=IF(ROW()-ROW(NoBlanksRange)+1>ROWS(BlanksRange)-COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL((IF(BlanksRange<>"",ROW(BlanksRange),ROW()+ROWS(BlanksRange))),ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4)))
 
Top