help with formula - basic total, but including a date function

C

carol

Hi,

I have a worksheet with information on money held by 20 different people. In
each sheet (1 per client), I have inputed valuations for each month.

In sheet 1, I want to see at a glace the latest valuation per client, but
this needs to be linked to the date, so that it generates the valuation
corresponding to the latest date.

Any ideas?

Thanks in advance.
 
G

Gary''s Student

For each person, put the latest data at the top of each person's worksheet,
not the bottom. Many beginners enter periodic data simply by adding a new
row at the bottom of the worksheet. If you insert new data at the top, you
will always know where the most recent data is.
 

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

Help with formula 2
=IF function with current date 3
help with a formula 2
Calculating total amount in a Pivot Table 1
summing total sales formula 1
Array formula - nee help 0
Date formula where month and day remain the same, but year will va 10
use month in cell date to sum all relevant cells 2

Top