| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help for choosing from a set of values
I am looking for help for a formula that will look at a set of values in
three columns and return the value of the last cell with data. Example below. Hope this is not too vague. col1 col2 col3 Result 1 1 1 2 2 1 3 3 If col1=1, return 1 If col1=1 and col2=2, return 2 If col1=1, col2=0 and col3=3, return 3 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help for choosing from a set of values
If data in columns A, B, and C then
=if(isblank(c1)=false,c1,if(isblank(b1)=false,b1,a 1)) Mike Anas http://mikeanas.googlepages.com/ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help for choosing from a set of values
=MAX(INDEX((A1:C1<"")*COLUMN(A1:C1),0))
"ccclwilson" wrote: I am looking for help for a formula that will look at a set of values in three columns and return the value of the last cell with data. Example below. Hope this is not too vague. col1 col2 col3 Result 1 1 1 2 2 1 3 3 If col1=1, return 1 If col1=1 and col2=2, return 2 If col1=1, col2=0 and col3=3, return 3 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help for choosing from a set of values
To return the *last numeric* value from a range:
=IF(COUNT(A1:C1),LOOKUP(1E100,A1:C1),"") Copy down as needed. -- Biff Microsoft Excel MVP "ccclwilson" wrote in message ... I am looking for help for a formula that will look at a set of values in three columns and return the value of the last cell with data. Example below. Hope this is not too vague. col1 col2 col3 Result 1 1 1 2 2 1 3 3 If col1=1, return 1 If col1=1 and col2=2, return 2 If col1=1, col2=0 and col3=3, return 3 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help for choosing from a set of values
Wonderful, it works. Thanks.
"T. Valko" wrote: To return the *last numeric* value from a range: =IF(COUNT(A1:C1),LOOKUP(1E100,A1:C1),"") Copy down as needed. -- Biff Microsoft Excel MVP "ccclwilson" wrote in message ... I am looking for help for a formula that will look at a set of values in three columns and return the value of the last cell with data. Example below. Hope this is not too vague. col1 col2 col3 Result 1 1 1 2 2 1 3 3 If col1=1, return 1 If col1=1 and col2=2, return 2 If col1=1, col2=0 and col3=3, return 3 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help for choosing from a set of values
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "ccclwilson" wrote in message ... Wonderful, it works. Thanks. "T. Valko" wrote: To return the *last numeric* value from a range: =IF(COUNT(A1:C1),LOOKUP(1E100,A1:C1),"") Copy down as needed. -- Biff Microsoft Excel MVP "ccclwilson" wrote in message ... I am looking for help for a formula that will look at a set of values in three columns and return the value of the last cell with data. Example below. Hope this is not too vague. col1 col2 col3 Result 1 1 1 2 2 1 3 3 If col1=1, return 1 If col1=1 and col2=2, return 2 If col1=1, col2=0 and col3=3, return 3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| choosing off various lists | Excel Worksheet Functions | |||
| Excel formula(?) for choosing only 1 cell.. | Excel Discussion (Misc queries) | |||
| Choosing a formula to used based on a codition fulfilled | Excel Discussion (Misc queries) | |||
| Choosing a value from a row with more than one condition | Excel Discussion (Misc queries) | |||
| Choosing a date | Excel Worksheet Functions | |||
Linear Mode
