Hi Tim Give this a try. Sunny
Try this =INDEX(A1:G5,MATCH(K2,A1:A5,0)+1,MATCH(J2,A1:G1,0)+1) Sunny
Hi Craig Give this a try. In cell E3 of the Gas Safety Audits worksheet, array-enter (enter with CTRL+SHIFT+ENTER) the formula below =SUM(IF(...
Hi Frans I have no idea why yours didn't work I have created 15 buttons and did encounter any problem running the macros using the ALT keys. ...
Hi Frans As far as I am aware, Excel will allocate the ALT 1 to 9, ALT 01 to 09 and then 0A, 0B, 0C etc automatically to the shortcuts/macros you a...
Just to share a similar experience from a colleague of mine a couple of years back. She had no problem saving the file until she renamed it. She wa...
Here is my final try.
See if any of this helps. Filter1 is a close as I can get. Filter2 would be perfect, ONLY if there is one country-one region. Both require a ...
If you are using start date as the next day (same day/different month) you will need to be careful when the start day is 29, 30 or 31 as not all month...
From your original question you wanted weekly/forthnightly/monthly as the frequency and you also have a start date. Without using 7/14/31 how will you...
Have you tried using Advanced Filter?
Hi Hava/Frans I think what was required is not the result. When filtering Country, Hava wanted the Region filter to only show what is related t...
Maybe the scroll lock on your keyboard is ON. Try switching it OFF.
Hi Karen See attached. The "" (without any space between) is used to handle the blank dates. =COUNTIFS(Table1[School],$G16,Table1[StartDate],...
Hi mey I don't quite understand your question. Maybe you can attach some examples.