Trying to email a spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to email a spreadsheet to someone but the formulas are not
working on the email version for one of the worksheets. It is not linked to
any file outside of the worksheet. Any assistance
 
This will get the last value entered in column A

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

This will get the ROW # of the last entry in Col A.

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

This will sum the last 60 entries in a column - assuming a header in row 1
and no blank cells

=SUM(OFFSET(A2,MAX(0,COUNTA(A2:A65536)-60),0,60,1))
 
Wrong thread - sorry!!


Duke Carey said:
This will get the last value entered in column A

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

This will get the ROW # of the last entry in Col A.

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

This will sum the last 60 entries in a column - assuming a header in row 1
and no blank cells

=SUM(OFFSET(A2,MAX(0,COUNTA(A2:A65536)-60),0,60,1))
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I invoice a cost to a custom built MS Access Accounting Database? 0
linking between spreadsheets 5
Scrabble Value calculation for Welsh words 0
Linking Drop Down List 3
How toEmail a spreadsheet and preserve the Data List format 2
#N/A In Cells 7
spreadsheet 1

Back
Top