Forum

Hi Rachel! I have an IF formula for you with nested SUMPRODUCT. My initial thought was a COUNTIFS, but that doesn't account for any OR. So long win...

Thank you Mynda! I was over thinking it! I guess that's what I get for multitasking. After reading your answer I went back and re-watched the video...

Load it into power query and unpivot some columns. In the worksheet I provided in my previous answer I provided the worksheet and put it into a tabula...

I'm not sure what your question is; however, if you are going to do tables and graphs you really want your data in a tabular format. You can load it i...

We need more information to help you. What problems are you having?

Short of hiding the function bar, it isn't possible. But once it's locked they can't make any changes to the function (unless they crack the security)...

I'm wondering if it's because the server is an older version?? IDK, hopefully you find a solution to your problem!

In trying to look at your test file I'm getting a message that the "requested topic does not exist". Can you try uploading your file again?

I got it, thank you so much! I had the data added to the data model, once I removed that it is working now. Because I was an American teenager in the ...

Yes I saw that, I made that change too. It's not refreshing unless I do a manual refresh of query on my original worksheet. I'm not sure if there's a ...

I made the changes you suggested - thank you so much! I was debating whether to hide the sheet in the end! Nifty trick! But my pivot table is still no...

Yes, protect your worksheet. In the Home Tab<Cells<Format<Format Cells<Protection there is a check box that is, by default checked, that s...