On 2005-04-27, Duke Carey wrote:
You can use this formula to find the row number of the last entry in column A

=MATCH(9.99999999999999E+307,A:A)

I don't understand how this works. I've looked at the MATCH function and
don't follow what's going on above.



Once you have the row number, you can pull any item from that row into your
second spreadsheet using the INDEX() function, i.e.,

=INDEX(Sheet1!A1:Z500,MATCH(9.99999999999999E+307 ,A:A),2)

I can see how the INDEX function works and (if the first function does
waht you say) how it would work but don't understand it because of my
confusion with the MATCH function.

Justin.

--
Justin C by the sea.