[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel advise.....



PureBytes Links

Trading Reference Links

When I need the last value in a column I create two cells at the top of the
column. The first one (say A1) has a formula "=COUNTA(A3:A1000)" to count
the number of cells in that column that have been filled in. The second cell
(A2) would find the last value in the column using the count from the first
cell by "=OFFSET(A3,A1-1,0)". These could be combined if you have no other
need for the count.

Tom Schaefges



----- Original Message -----
From: Adam Hefner <vonhef@xxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Monday, February 07, 2000 10:29 PM
Subject: Excel advise.....


Hi guys,
   This is my first spreadsheet, so I need some help.
Below is a picture of my program, I manually insert the highs,lows, and
close for days 1-4 (white cells). It then gives me calculations for day 5
(in gray cells).  I have figured out how to import my ASCII text file into
Excel but what do I need to do from there?

1.  Since I will update the data each day, and the first row is the oldest
date...
how do I program excel to use the LAST entry of each column?

2. Should I add another sheet for each ASCII text I import, or is there a
better/preferred method of managing the data?

Thanks in advance,

     Adam Hefner