Search results for query: *

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...

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...

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

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...

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...

If I have a cell that has a SUM formula, can I also use ROUNDDOWN as well?

Is it possible to populate a number of recurring appointments rather than one at a time? As a teacher I use Outlook for my timetable and want to copy by the week if possible.

We have grades of A*, A, B, C etc, plus slash grades of A/B, B/C etc. My problem is that Countif doesn't recognise A* although it does recognise A*/A. Any suggestions?

I want countif to search and identify between a range of numbers. eg =COUNTIF(A4:A49,">=70") will return the number to times it finds a numberical value 70 or over. but how do I get it to find the number of times it finds a value between 50 and 59.9?

I want an audio track, inserted as a wav file, to play continuously through the Powerpoint slide show - only the sound cuts out as the first slide changes to the second. Any suggestions?

Using Excel 2000 I have recorded a macro to display a chart using data from the spreadsheet. No problem - all works OK. However I want to have another macro to remove the chart. I have tried using &quot;Delete&quot; and also &quot;Clear&quot; and then &quot;All&quot;. Both come up with...