excellent

Hello, I have the results of a survey in an Excel spreadsheet, like this: <tbody> <tbody> Question </tbody> <tbody> Grade </tbody> <tbody> StrVal </tbody> <tbody> Flowers and Decoration Team </tbody> <tbody> -1 </tbody> <tbody> N/A </tbody> <tbody>...

Hi, my job (joy of joys!:eeek:) is to collate the different reports that we get in from different departments around the organisation... and there is one really repetitive aspect of it that leaves my fingers (& head) numb from all of the copying and pasting. I'm hoping that somebody may be able...

Hi all, I want to do a pill / exercise schedule for my mom, with this type of date format: <tbody> Mar 3 / AM Mar 3 / PM Mar 4 / AM Mar 4 / PM Mar 5 / AM Mar 5 / PM Mar 6 / AM Mar 6 / PM </tbody> Is there any way to quickly automate this? Thank you excellent Excelese, Ed

i am using the below lookup formula but it the value less than 0 it give error =LOOKUP(F3,{0,80,90,110,150},{"Excellent","Good","Average","Below Average","Poor"}) <colgroup><col><col></colgroup><tbody> -1 #N/A 44 Excellent 88 Good 90 Average 110 Below Average 155 Poor </tbody>

I have trawled the net, and tried countless bits of VBA code, but nothing seems to do what I need. I have a column of dates from BL2 to BL10000 with date in all sorts of formats. I need them all to end up as the format 01.03.17. Any ideas would be very much appreciated.