| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference Elements w/in an Array
I need to create a formula that will look in column A (let's say rows
1:10000) for all non-zero numbers (both negative and positive numbers). Several of the cells in column A could be zero or blank. After the formula is populated with the non-zero numbers, I need for the first number in the array formula to be placed in F1, the second number in the array formula to be placed in F2, the third number in the array formula to be placed in F3, etc. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| What is the maximum allowed number of data elements in a data array? | Excel Discussion (Misc queries) | |||
| How can I use a cell reference in Sumproduct array formula? | Excel Discussion (Misc queries) | |||
| Array formula reference (Corrected) | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
