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...
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...
Thanks JP for your interest.
Say I have 25 appointments a week that recur week in week out. Do I have to do each one individually as a recurring appointment or is it possible to do the whole week collectively?
Chris559
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.