Daily numbers table

[Mike Sibley]

I really need help in figuring out how to get a schedule to work for my
business.

I want to be able to daily enter the most current gas prices in a table then
in another area (or sheet) do some calculations using the last entry in the
table (which would be the current prices).

I have spent HOURS over DAYS trying to figure out how to do this so it is
very simple and takes no manipulation. It is for my store manager and I
just want her to be able to open it, enter current numbers, print it, and
email to me.

If anyone would be willing, I would be more than happy to email privately
the schedule I have created thus far. Please email me directly at my email
address below.

T. Michael Sibley, CPA
Covington, LA
(e-mail address removed)

 

[Bob Greenblatt]

I really need help in figuring out how to get a schedule to work for my
business.

I want to be able to daily enter the most current gas prices in a table then
in another area (or sheet) do some calculations using the last entry in the
table (which would be the current prices).

I have spent HOURS over DAYS trying to figure out how to do this so it is
very simple and takes no manipulation. It is for my store manager and I
just want her to be able to open it, enter current numbers, print it, and
email to me.

If anyone would be willing, I would be more than happy to email privately
the schedule I have created thus far. Please email me directly at my email
address below.

T. Michael Sibley, CPA
Covington, LA
(e-mail address removed)

You can use a formula, or a defined name to get the last entry in a column.
Assuming the prices are in column A, beginning in A1, and there are no
blanks in the column, the formula =index($a:$a,counta($a:$a)) will return
the last entry.

 

[JE McGimpsey]

I really need help in figuring out how to get a schedule to work for my
business.

I want to be able to daily enter the most current gas prices in a table then
in another area (or sheet) do some calculations using the last entry in the
table (which would be the current prices).

I have spent HOURS over DAYS trying to figure out how to do this so it is
very simple and takes no manipulation. It is for my store manager and I
just want her to be able to open it, enter current numbers, print it, and
email to me.

If anyone would be willing, I would be more than happy to email privately
the schedule I have created thus far. Please email me directly at my email
address below.

One way, assuming the prices are entered in column A:

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

This works for numeric values, even if there are blanks or text in the
column.