Whats the use of Match with Match Type=1

[jp16]

Hi, can anyone give me example under what situation should we use =match(A1,C:C,1)?
I have never see people using match type =1 and i have no idea the how Excel get the Result.
Can anyone give me example whats the use of Match Type =1 in Match ? And how does Excel get the result?

[samba_ravi]

Match Type 1
MATCH finds the largest value that is less than or equal to lookup_value. The values in the lookup_array argument
for that lookup_array must be arranged in ascending order

Match Type 0

MATCH finds the first value that is exactly equal to lookup_value. The values in the lookup_array argument can be in any order.

Match Type -1

MATCH finds the smallest value that is greater than or equal tol ookup_value. The values in the lookup_array argument must be placed in descending order

[jp16]

So does it mean that match type=0 is for Number and Text while match type = 1 is for Number only?

[samba_ravi]

No, you can use 0,1,-1 for both numbers and text
for text also you can use ascending and descending order
like A,B,C, ----,
Z,X,O,M,-----

[XLent]

Use of 1 invokes the Binary Search -- this can be incredibly useful in processing large data sets {where they are sorted appropriately}, and can be used to "cheat" when looking for things, e.g.

Find row of last text string in a column {regardless of it's value}

=MATCH(REPT("Z",255),$A:$A,1)

Find row of last number in a column {regardless of it's value}

=MATCH(9.99E+307,$A:$A,1)

above used frequently when determining dynamic named ranges etc...

note: the ,1 can be omitted as a) optional parameter and b) 1/TRUE is default.