Ok last question i promise. I have been using the formula you guys supplied me with and it works like a dream. In the last part of my spreadsheet I have to change the formula slightly.
I need to add 12 to a cell (CP5) but get the answer displayed as text again e.g. 1a, 1b etc. Any ideas, im sure its a simple fix??
How do i ammend the following??
=LOOKUP(CP5,{"1a","1b","1c","2a","2b","2c","3a","3b","3c","4a","4b","4c","5a","5b","5c","w"},{11,9,7,17,15,13,23,21,19,29,27,25,35,33,31,3})
Andy
well given the result of the last formula, this should convert it back to the original letters :-
=SUBSTITUTE(INT((C3-(MOD(C3,6)))/6)&CHAR(100-MOD(C3,6)/2),"0b","w")
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
andybocchi 
Register To Reply
Bookmarks