Forum

Hello, No file got uploaded. Br, Anders

Hello, Ok, I hope you get a solution that works. Br, Anders

Hello, It is quite possible I don’t understand what you are doing. Do you have a sample file? Br, Anders

Hello, Don’t delete ColA is a good start to retain the formatting made for that specific column. You will get the same result if you remove other f...

Hello Scott, The solution I give here is using another approach and I am using exact match, not just the first three characters as that can give mu...

Hello, From Excel 2013 and newer you have the ISFORMULA function, so you can check if the cell contains a formula or not. Example: =IF(ISFORMULA...

Hello Doug, I suppose the status is tied with the name, so the easy way to handle such scenario is to create a table/list containing names of those...

Hello, Many similar issues in this file, so I have only provided some example on how it can be solved, being Excel there are of course other method...

Hello George, You were almost there, you can use different functions to get the result, for example SUMIF. Example below. =SUMIF(Master_Cost_Tab...

Hello, Please upload a sample workbook, it will make it far easier for you to get help. Br, Anders

Hello Saliha, A modified formula with two criterias using the LOOKUP function. You can replace the 1E+100 with 3 if you want. To be put in cell K4....

Hello Saliha, The formula I gave is to be used in column N, the Closing Qty column. I suggest you delete the Opening Qty column. I am sorry if I wa...

Hello Saliha, In my view you make it more difficult than it needs to be by having this Opening Qty column, there is no need for it as you have the ...

Hello, I used the translation service Google translate. In the attached file In issue 1 I want to locate a drug name (column C) by 2 VLOOKAP: Th...

Hello, Using shared workbooks works even though it does limit what you do in the file. Here is a link to a Microsoft support page describing what y...