|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 19th, 2010, 07:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Posting the workbook
How can I post the workbook I am in so someone can help me with IF, INDEX and
MATCH combination formula? 
|
|
#2
March 19th, 2010, 08:06 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Posting the workbook
Hi
You upload your file to a site like this one http://wikisend.com/ or this one http://www.mediafire.com/ . They are free. then you post the URL here so people can download your file. HTH John "cadustin" wrote in message ... How can I post the workbook I am in so someone can help me with IF, INDEX and MATCH combination formula?
|
|
#3
March 19th, 2010, 08:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Posting the workbook
To find the last numerical value use:
=INDIRECT(ADDRESS(ROW(),MATCH(MAX($D7:$IV7),$D7:$I V7)+COLUMN())) To find the last value, number or text use: =INDEX(D7:IV7,COUNTA(D7:IV7)) If there are blanks in the row, the following returns the last column entry number or text HTH - click 'yes' if useful Peter =LOOKUP(2,1/(B6:IV6""),B6:IV6) "cadustin" wrote: How can I post the workbook I am in so someone can help me with IF, INDEX and MATCH combination formula?
|
|
#4
March 20th, 2010, 02:49 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Posting the workbook
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
