Chris The Rock
Active Member
- Joined
- Feb 24, 2002
- Messages
- 287
Imagine A1:A6 have Dates, and B1:B6 have numbers.
I want to report the DATE (from A) that corresponds to the highest numbered row with a number in it from column B.
I want to do this with a formula, not with VBA. I can do it in VBA with no problem.
Anyone done anything like this?
_________________
"And I say, I'm dead, and I move."
This message was edited by Chris The Rock on 2002-08-28 14:45
I want to report the DATE (from A) that corresponds to the highest numbered row with a number in it from column B.
I want to do this with a formula, not with VBA. I can do it in VBA with no problem.
Anyone done anything like this?
_________________
"And I say, I'm dead, and I move."
This message was edited by Chris The Rock on 2002-08-28 14:45