Not sure i could use the above function here:
is there a way to set up a formula at the top of the spreadsheet so that a specific row with various data is repeated at the top of the spreadsheed based on the one cell in that row? For example, if i have a list of names (in column A) and corresponding data accross the spreadsheet, I'd want to recall a particular row based on ONE name. If offset function is right, can you show a simple example? thanks