I want to search a column for the last cell that contains a number and put that value into another cell. This spreadsheet will get very lengthy and I would like to keep all pertinent information at the top in a frozen pane section so it is visible as soon as the file is opened. Is there a formula that will do this? I have tried myself, but have yet to come up with anything. Let me know if you have any ideas. If this has been discussed already, kindly point me in the right direction! Thanks a lot.
Sarah
