| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index function
Can you use the match function to return the last match instead of the first?
I know the match type 0 returns the first exact match. I tried using the match type number that was the same as the quantity of entries to return the last exact match, but I get an error. Does match type only accept -1, 0, and 1?? -- Shirley |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX function need to have col reference to be formula | Excel Worksheet Functions | |||
| Excel 2003 index function does not calculate | Excel Worksheet Functions | |||
| Index function works in A2, but not in A10, Why is that? Cant figure it out. | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Threaded Mode
