Forum

Hello, Just sharing my view, I would stick with the source data format and use a Pivot Table to arrange the data as required. Br, Anders

Hello, Well, the error message says it all, the user(-s) getting this error lacks permission to access the folder and/or files in the shared folder...

Anders Sehlstedt said Hello, You use the NA() function to get the #N/A error. You can read more information from Microsoft Office support about t...

Hello, You use the NA() function to get the #N/A error. You can read more information from Microsoft Office support about the NA function here. ...

Hello, Yes, if you do not want to have the zeros in the trendline then you have to replace those with #N/A instead. /Anders

Hello Mitul, As Philip writes, I do think you would benefit greatly of taking an Excel course because you will get good explanations of how the fun...

Hello Mitul, Glad to help out, but this is more looking like a private class rather than just giving some help or advice on how to go on with a prob...

Hello Mitul, How are you? Sorry for a late response, I had some difficulties to get home from work today. Questions regarding Document Copy-of-m...

Hello Mitul, I suggest you check the spelling in cell E5. You have typed in ”Excel” Pamphlets but in your data range you don’t have that text, you ...

Hi Lea, As you probably noticed, I was not sure how you wanted to count based on CheckOut date, so I gave two different options. Just glad I could ...

Hello Mitul, The formula should read =SUMPRODUCT(C6:C36*(B6:B36=E4)+C6:C36*(B6:B36=E5)) And you need to check the data entered, below picture...

Hello Lea, You need to use array formulas to sum / count the number of guests and rooms. See attached file for reference. To be able to use same...

Yep, I can only agree. The articles in this blog was what caught my attention first, I have learned a lot from them. Then I took some courses and they...

Hello Ryan, Yes, when you get a matrix like the example you share, then you are better off using INDEX and MATCH. Based on your file, the formul...

Hello Mitul, It depends on how you type it in. If you for example type the dates as Jan. -15, Feb. -15, Mar. -15 etc, then no, Excel will not de...