Thread: I want a cell to show total from other cell when that cell changes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default I want a cell to show total from other cell when that cell changes
Hi,

I'm not sure I understand but this will return the last numeric value in
column B of sheet 1.

=INDEX(Sheet1!B:B,MATCH(6.022*10^23,Sheet1!B:B))



"carinco" wrote:

I have a simple spreadsheet that shows a balance in one column. However after
each input the balance total moves down to the next row. I want to see the
balance total in another worksheet. How can I acheive this when the total
keeps moving down a row?
Reply With QuoteReply With Quote