Last seen: Mar 8, 2026
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...
Hello Steve, I think you will find an answer to your question in this article. The data in the MLB site seems to be structured the same way, so wha...
Hello, I am not sure I understand what you mean with having a searchable drop down list, normally that termonology means that you start write in th...
Hello, Can you describe more detailed what it is you want to achieve? As it is now I am not clear with what you want to do. Here is one techniqu...
Hello, If you check the file I uploaded you will see examples of three different methods. INDEX and MATCH, below formula is in Swedish. =INDEX(V...
Hej Mattias! The time values in table Vertical is formatted as text, while in table DateAndDay they were correctly as numbers. In attached copy of ...
Hello Mike, There are of course lots of books covering from beginner to expert levels, as I have not read any such books I don’t know how good or u...