Recent content by Chris559

I have already tried all of that - the lines just ping back and wont expand to a new position.

Thanks Skip, but it is the columnar breaks that are giving me a problem.

I have set the page breaks in a spreadsheet and for some reason I cannot now drag and move them. I have tried resetting which does not solve the problem, but when I tried to remove the breaks that does not work either. I can extend the thick blue lines on the edges but not the internal blue...

I am a teacher with a two week timetable with Week A being very different to Week B. I can enter my timetable over the two weeks, but then have a problem with half term holidays, Christmas, Easter etc. Does anyone know of a way to populate the whole year rather than having to do it all over...

thanks skip - works a treat thanks to xlhelp, but yours returns Flower shop which is the lowest not the highest (A&B)

I want the VLOOKUP to return the name in Column A of the highest value in column B. I thought that my lookup at the bottom would work - but doesn't. Any suggestions? A&B £450.00 Tesco £322.00 Scouts £160.00 Teashop £25.00 Take Away £60.00 Flower shop £75.00...

Many thanks mintjulep - works a treat!

Thanks. Do you know how to do it? I am struggling!

Is it possible to put a sparkline above the chart showing a percentage rise/fall?

Thanks - Have now got it to work. I had the ~* round the wrong way!

Being a teacher I often use the mark A*, but trying to count this value in Excel is not easy. The asterisk is giving me a problem. I have used ~ before, but cant get this to work either. Any suggestions?

I have created a drop down list in Excel for an invioce type document. At the top of the list I have used the word "Blank" to return the invoice for a new entry. It works manually when I choose "Blank" from the list but not when I record the same actions and give it a shortcut. In the same...

I have created a drop down list in Excel for an invioce type document. At the top of the list I have used the word "Blank" to return the invoice for a new entry. It works manually when I choose "Blank" from the list but not when I record the same actions and give it a shortcut. Any...

Many thanks - will teach me to be more observant!

I want to give a 5% discount to orders (values) over £50. I have put in the following formula: =IF(G48<50,G48/100*95,G48/100*100) which doesn't work. It returns whatever the value is in G48 no matter if it is greater than 50 or not. I also tried =IF(G48<50,G48/100*95,G48) to no avail...