| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2K and parsing data
Works like a champ!
"Big" thanx... "JE McGimpsey" wrote: One way: Select, say, Z1:Z6 and array enter (CTRL-SHIFT-ENTER or CMD-RETURN): =SMALL(A1:A20,{1;2;3;4;5;6}) In article , Ed wrote: I have a range of numbers (1-20) in multiple columns, but only 6 of them are used in a particular column. As an example col1 would have 1,2,5,8,9,15; col2 would have 6,7,8,10,15,20; etc. Since the numbers are entered in their corresponding cell location (ie 1=B1, 2=B2, 5=B5, etc.) there are empty cells between the numbers in the columns. Is there a function that will take the numbers from each column, and parse them to a range of six cells in another area of the spreadsheet? I'm looking to have excel copy the numbers that have been entered, to another range and not have blank cells between the numbers. Thanx in advance... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help me parsing Data and Organizing | Excel Worksheet Functions | |||
| parsing data into Excel | Excel Discussion (Misc queries) | |||
| Parsing Data with | Excel Discussion (Misc queries) | |||
| Help With Parsing Data | Excel Discussion (Misc queries) | |||
| Parsing Data | Excel Discussion (Misc queries) | |||
Threaded Mode
