Hi,

I’ve got a situation, which I thought would be pretty simple, but it
wasn’t.

Brief:
I do a report monthly, which defines how much files are pending.
Recently I’ve been asked to age the items. Normally that would be
easy, if I have a timestamp or date to work off. But there is no date.


So what I’ve done is inserted previous reports as different tabs into
one worksheet, going back to July 04. Then I’ve inserted a new tab,
which looks up July 05 in July 04 thought to June 05, it will bring
back the policy number or blank if the statement is false.

I’ve also got a col, which counts the row of all policy numbers – Which
gives you the age? Unfortunately that’s not the case. Cases appear in
July 04, Aug 04 and Sept 04 and then Oct 04, Nov 04, Dec 04, Jan 05,
Feb 05, Mar 05 and April 05 May is blank then the case may appear in
June 05, making this case 1 Month old.

Question:

Is there anyway to count from right to left and stopping when it blank?


+-------------------------------------------------------------------+
|Filename: ageprofile.PNG |
|Download: http://www.excelforum.com/attachment.php?postid=3676 |
+-------------------------------------------------------------------+

--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=393287