| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to pull a single cell from a column into another cell
I
have a column of information that is being pulled from an adjacent column where only 1 cell will have anything in it but 0. I need to pull whatever cell in the columns information to a single cell somewhere else. Suppose B is the column with only 1 cell will have anything in it but 0. Suppose A is the column to pull information from. If the non-zero cell in column B is always a positive number, then try: =INDEX(A:A,MATCH(MAX(B:B),B:B,0)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function needed to pull in cell values | Excel Programming | |||
| single-cell multiple entry with pull-down list? | Excel Discussion (Misc queries) | |||
| From single cell variables to a single column serie | New Users to Excel | |||
| I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
| pull value from last cell in a column | Excel Programming | |||
Threaded Mode
