Re: [EquisMetaStock Group] Last value in coloumn

[jao yan <jaoyan100@xxxxxxxxx>]

thank you pete.

I might not made the request clear, assume

col A    C1=9        col B             E1= 10

1                            22

2                            21

3                            19

4

5

6

7

8

9

the result in cell c1 should read the last entered value

---

From: Pete Lieber <plieber@xxxxxxxxxxxxxx>
To: EquisMetastock <equismetastock@xxxxxxxxxxxxxxx>
Sent: Saturday, January 31, 2009 4:47:47 AM
Subject: RE: [EquisMetaStock Group] Last value in coloumn

In cell B1 put "=A1"
In cell B2 put "=if(A2>0,A2,B1)"
Copy cell B2 to the end

---

To: equismetastock@ yahoogroups. com
From: douglaskallevig@ juno.com
Date: Fri, 30 Jan 2009 16:09:41 -0600
Subject: Re: [EquisMetaStock Group] Last value in coloumn

hi, appreciate if some one can help

In excel sheet, how to fine the last vaue of col. A for excample

A       

1

2

3

4

0

0

0

the result should read 4

thanks

jao...

 

____________ _________ _________ _________ _________ _________ ___
Get your fix. Click here for reliable handyman services!

__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___