Recent content by Yousuf Shovon

Hello Nikhil Patki, Thanks for sharing your experience with us. I understand you are unable to load data in Excel from PDF about my bank statement. Well, first we need to see if the problem is limited to your first copy of the PDF. To do so: Scan your document into a new PDF file using Acrobat...

Hello EMOHAMMED, Welcome to ExcelDemy forum! Thanks for sharing your experience with us. Regarding your problem, there is no functionality issue with your formula. However, you are using an incorrect time format with 10:00AM (no space). As you can see, Excel does not recognize this as a time...

Hello JDB751012, Welcome to ExcelDemy forum! Thanks for sharing your experience with us. Here are some formulas you can use to read dataset for subsequent year salary increases for multiple employees: INDEX-MATCH function: Use this formula in E2: =INDEX('Future Payscale'!$A$1:$F$34...

Hello Rafael, Welcome to ExcelDemy forum. Thanks for sharing your experience with us. I understand you want to run the given VBA code with the most recent issues but are facing issues. As suggested, conditional formatting cannot directly solve the issue of identifying new entries in your Excel...

Hello Hamza, Welcome to our ExcelDemy forum! Thank you for sharing your experience with us. It is my understanding that you want to test a VBA file on an Android PDA Scanner. The reason behind it is not working is because Excel macros will not run on mobile operating systems. VBA runs only in...

Hello Chili, Thank you for sharing your post with us. I understand you want to get a proper and user-friendly format for arranging a monthly details report. A well-written report should be easy to understand and brief, with a summary of the month's activities and key findings. To get assistance...

Hello Taherelchoufi, Welcome to our ExcelDemy forum! Thanks for sharing your experience with us! I understand you want to extract a value from a sheet based on the sheet name and index number. You can use the INDIRECT function or the combination of INDEX and MATCH with the INDIRECT function to...

Hello Patlee, Welcome to ExcelDemy Forum! Thanks for sharing your experience. I understand you want to return all the given forms in a specific month. If your Due Dates are truly entered as valid dates as given in the below image, you should be able to apply a simple filter, i.e. Date on or...

Hello BigMe, Thanks for sharing your experience. You want to find multiple values in all cells in a sheet and later copy the entire row to other sheets. The conditions in the Excel file are: 1. "What if I need to find multiple values, for example, to find apple and grape (later maybe I need to...

Hello Chili, Thanks for sharing your experience! I understand you are facing some issues with connecting Pivot table to your data in another tab. You can overlook these factors before we can reach a point of solution. 1. I have found a couple of spacing & typing mistakes in the given formula...

Hello BMORES, Thank you for sharing your experience with us! I understand you want to reveal the correspondng Risk Level for a specific combination of choices. However, you forgot to mention that not every level of combinations is covered, for instance, 3 choices don't match a row in Sheet 2...

Hello Fay, Thanks for sharing your experience with us. I understand you want to find the objectives, and equation of the constraints to minimize cost using Solver in Excel. Please, read our article Excel Solver to Minimize Cost with Examples to gain a general idea of how Solver works. Here, we...

Hello Wanderson, Thank you for sharing the experience with us! I understand you want to figure out the optimal ticket pricing to maximize revenue using the Solver tool. Fortunately, we came up with a way to do that. Here is the idea: In the Input sheet, populate the headers with the correct...

Hello John, The code returns an error because of these lines: LRow = Application.Max(ws3.Cells.Find("*", , xlFormulas, , 1, 2).Row, 3) ws3.Range("A3:Z" & LRow).ClearContents The code thinks you have existing data in the Expected Result sheet. So, it erases them first and then...

I apologize I am not following you. The code provides the duplicate items with the row number, date, and quantity for both sheets. Here is an image of the duplicate items of Sheet1. If you have additional requirements, please share a demo file with your expected results in it. Thank you for...