alphabetize - automatically
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? |
alphabetize - automatically (using array function)
"mandyjo830" wrote:
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? 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)+1ROWS(BlanksRange)-COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL( (IF(BlanksRange<"",ROW(BlanksRange),ROW()+ROWS(Bl anksRange))),ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4))) |
alphabetize - automatically
See if this helps:
http://tinyurl.com/y9sv3x Biff "mandyjo830" <u29094@uwe wrote in message news:6948fb3a04734@uwe... 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? |
All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com