LinkBack URL
About LinkBacks
Would this help ?
(It is adapted from this site :http://www.cpearson.com/excel/lookups.htm#LeftLookup)
Would this help ?
(It is adapted from this site :http://www.cpearson.com/excel/lookups.htm#LeftLookup)
Last edited by arthurbr; 12-17-2007 at 07:49 AM.
That would be absolutely perfect! Thank you.Originally Posted by arthurbr
Glad to help
Ok... since I'm here anyway and the help is fantastic!
This is the same worksheet as before attached, but at an earlier stage. See the highlighted column for the problem... I need to ensure that all the cells in this column are in the same format as H1 - if you scroll down you will see that some are missing the 'SAT' prefix, some are missing the hyphen, etc. The format is SAT-(Year)(Week Number).
Is there any formula I could use in a helper column to rectify this, as I did it manually, but will have to do this every week!
Many Thanks
providing you always have at least a six digit number, I'd suggest a helper column with following formula :This will avoid checking if you have , or don't have "sat" or "-"HTML Code:
Last edited by arthurbr; 08-09-2007 at 05:49 AM.
Bloody fantastic!! If I could buy you a beer, I would...
Thx I'll take a note of that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks