Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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))) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically generating a number range | Excel Worksheet Functions | |||
Automatically multiply be a number. | Excel Worksheet Functions | |||
Copy Rows to another Sheet Automatically | Excel Worksheet Functions | |||
Automatically update cells | Excel Discussion (Misc queries) | |||
Excel file automatically opens - More Info | Excel Discussion (Misc queries) |