| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
use match from the bottom to the top.
the match function gives the index from the top
is it possible to use match from the bottom to the top? ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)" |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
use match from the bottom to the top.
You can do =counta($A$8:$A$1) - MATCH(A1,$A$8:$A$1,0) or count() if you're
using numbers. "kang" wrote: the match function gives the index from the top is it possible to use match from the bottom to the top? ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)" |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
use match from the bottom to the top.
But what if some cells in the range are empty? Try
=ROWS($A$1:$A$8)-MATCH(A1,$A$8:$A$1,0)+1 "Sean Timmons" wrote: You can do =counta($A$8:$A$1) - MATCH(A1,$A$8:$A$1,0) or count() if you're using numbers. "kang" wrote: the match function gives the index from the top is it possible to use match from the bottom to the top? ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)" |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
use match from the bottom to the top.
thanks daddylonglegs. what if I want to get the last instance of the match cell? daddylonglegs wrote: But what if some cells in the range are empty? Try =ROWS($A$1:$A$8)-MATCH(A1,$A$8:$A$1,0)+1 "Sean Timmons" wrote: You can do =counta($A$8:$A$1) - MATCH(A1,$A$8:$A$1,0) or count() if you're using numbers. "kang" wrote: the match function gives the index from the top is it possible to use match from the bottom to the top? ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)" |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
use match from the bottom to the top.
I don't want the first instance of the matched cells be indexed from the
bottom, but, I want the last instance of the matched cells. daddylonglegs wrote: But what if some cells in the range are empty? Try =ROWS($A$1:$A$8)-MATCH(A1,$A$8:$A$1,0)+1 "Sean Timmons" wrote: You can do =counta($A$8:$A$1) - MATCH(A1,$A$8:$A$1,0) or count() if you're using numbers. "kang" wrote: the match function gives the index from the top is it possible to use match from the bottom to the top? ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use match from the bottom to the top. | New Users to Excel | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| Index Match Two columns Find Last Bottom | Excel Worksheet Functions | |||
| dislike jump bottom of column by double-clicking the bottom of cel | Excel Discussion (Misc queries) | |||
| how to paste data from top to bottom to bottom to top | Excel Discussion (Misc queries) | |||
Linear Mode
