Forum

Hello Samantha, I am just glad I could be of help. Have a great evening now. /Anders

Hello Ryan, Just wondering if the tip in this VLOOKUP article can give you some way forward in creating such calculator. Br, Anders

Hello Samantha, It is not a difficult question, but how well things works depends on which version of Excel you are running. Best option would of c...

Hello Ali, I am sorry, I don't understand what you want to do. If you can provide a sample file that would be much better. Br, Anders

Hello Mitul, You're striving on, good to see. Let's see if I can answer your questions. Q1) Flash fill works fine, if it senses there is a patte...

Hello Vladimir, There are some tips for you at this site to check and see if it helps you. Good luck. Br, Anders

Hello Azri, Thank you for your feedback, always nice to know that a problem was solved. Yes, you can just add the extra sheets in the first sect...

Hello Azri, As per your setup I would use an array formula to sum the different criterias from the different sheets. In your Summary sheet, paste i...

Hi Gary, I have checked your file and the array formula you have in cell H5 works. In case you want to change and use COUNTIFS then you can use fol...

Hello Mitul, As I wrote in a previous reply, you need to check the table header names in the Pivot Table. Your formula is: =GETPIVOTDATA("Order ...

Hi Kenneth, It is always much easier to understand if there is a sample data showing the scenario. Can you upload such file? Br, Anders

Hello Gary, There must be something wrong in your data or more likely, your file. As I try to show with below picture, with the criterias you menti...

Hello Mitul, I hope you're good. The easiest way to compare two columns and highlight the cells where you have same data is to select the range ...

Hi Mitul, I am confused. What is your question? Br, Anders

Hello Mitul, To start with, this article describes why you get a #REF! error and how you can correct it. Secondly, this article describes the GE...