| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
returning one arguement from several columns
Heya,
I have three columns, there is one value in each of the rows (2 blank values). I am trying to find a function that returns the one value, so it would neet to search the three columns and return the one that has a value in it. Thanks very much, Reza |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
returning one arguement from several columns
Hi,
For numbers =MAX(A1:C1) or for text =LOOKUP(REPT("z",255),A1:C1) Mike "Reza" wrote: Heya, I have three columns, there is one value in each of the rows (2 blank values). I am trying to find a function that returns the one value, so it would neet to search the three columns and return the one that has a value in it. Thanks very much, Reza |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Greater than less than arguement returning value when text inputte | Excel Discussion (Misc queries) | |||
| Dynamic arguement? | Excel Worksheet Functions | |||
| Two VLookups in one arguement | Excel Worksheet Functions | |||
| RIGHT Arguement? | Excel Discussion (Misc queries) | |||
| More than 7 IF statements in one arguement | Excel Worksheet Functions | |||
Linear Mode
