I have a row of data where i need to find a piece of information relating to two other bits of info.
I.E. i need to find the number which follows the following sequence:
01/04/2009 PENS - where the space is another cell
The problem is that in the row there could be:
01/04/2009 BASI
or:
08/09/2010 PENS
So i do i find the number which follows: 01/04/2009 PENS
Bookmarks