• MVP Logo
  • Recent Forum Posts


    Help With SumIfs

    Your formula in column O3 was very close. The problem was that your named ranges were different lengths. WeekNo went from A2:A69 while Worker and TimeTaken...

    hbgurley Today, 08:53 PM Go to last post
    Ken Puls

    Acess data in shared onedrive file

    Hi Sam,

    When you open the file, what gets returned if you go to File -> Info -> Copy Path?

    Paste that in a cell. I can't...

    Ken Puls Today, 07:29 PM Go to last post
    Ken Puls

    Power Query returning Excel functions

    Hi jmlee,

    It's entirely possible to create formulas in Power Query, but you have to learn the M syntax, which is quite different than Excel's...

    Ken Puls Today, 07:14 PM Go to last post

    Conditional Formatting based on a criteria

    I have a row of values and a Standard Deviation calculation at the end of each row. I have a cell on the same sheet with an SD number in.


    sjo007 Today, 03:56 PM Go to last post

    Help With SumIfs

    Hi I wonder if anyone can help as Iím not an excel expert and am stuck.
    Iíve entered some dummy data into my workbook to test it but canít figure...

    Currymonster30 Today, 03:31 PM Go to last post