N
Nikhil
Hi.
I have a column that contain numbers (either + or -). I want to find the
last cell that contains a -ve value and return the corresponding date from
the adjoining column
e.g
Col A Col B
1-Apr-2010 -1000
2-Apr-2010 -1000
3-Apr-2010 +500
4-Apr-2010 -1000
5-Apr-2010 +700
In this illustration, i did like to have the value 4-Apr-2010 returned
Can anyone please help
Regards
Nikhil
I have a column that contain numbers (either + or -). I want to find the
last cell that contains a -ve value and return the corresponding date from
the adjoining column
e.g
Col A Col B
1-Apr-2010 -1000
2-Apr-2010 -1000
3-Apr-2010 +500
4-Apr-2010 -1000
5-Apr-2010 +700
In this illustration, i did like to have the value 4-Apr-2010 returned
Can anyone please help
Regards
Nikhil