First and last entry

I

irresistible007

Hi every one :)

MY PROB #1

I am having a statement of transaction in a Chronological order let
says the Col A is for date, Col B is for description and so on....

I want a formula which could provide me the date of last transaction o
sheet and the date of first transaction on sheet...


MY PROB #2

I want a IF type formula... which should check the range of cells (fro
Bottom to Top) If the condition is met by a cell should display th
contents of that cell and if not should check for the next cell i
range... but the thing is that it should start checking from bottom..
 
S

ScottO

Your Prob #1:
First Trans Date =MIN(A:A)
Last Trans Date =MAX(A:A)

Your Prob #2:
I don't quite understand what you're trying to do, so it's still your
prob ;)

Rgds,
ScottO


"irresistible007"
message |
| Hi every one :)
|
| MY PROB #1:
|
| I am having a statement of transaction in a Chronological order
lets
| says the Col A is for date, Col B is for description and so on....
|
| I want a formula which could provide me the date of last
transaction on
| sheet and the date of first transaction on sheet...
|
|
| MY PROB #2:
|
| I want a IF type formula... which should check the range of cells
(from
| Bottom to Top) If the condition is met by a cell should display the
| contents of that cell and if not should check for the next cell in
| range... but the thing is that it should start checking from
bottom...
|
|
| --
| irresistible007
|
|
| -------------------------------------------------------------------
 
B

Bob Phillips

#1

=MAX(A1:A20)

and

=MIN(IF(A1:A20<>"",A1:A20))

which is an array formula so commit with Ctrl-Shift-Enter

#2

What condition?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"irresistible007" <[email protected]>
wrote in message
news:[email protected]...
 
Top