I have a formula I need written to solve the below problem. It needs to be a formula not a macro.
Please view attached images as a reference. I will attached a worksheet to work on.
I gave a hlook up formula in Column D. Its looking for a match in a specific cell of Column A. At times I want to delete rows in Column A, however I do not want to cell reference in the Hlook up formula to change.
I have $$ signs infront of all cell references, howeve the cells references in the formula still self adjust if I delete a row in column A.
Let me know if you can help!
60 freelances font une offre moyenne de 22 $ pour ce travail
Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Plus
Hi, I can hep you to rewrite a formula using Match function. You will get correct results if you want to remove rows in column A. Would be great to hear from you, Best regards, Duong
"Sir, I am Excel Advance Level Expert. This is a basic work for me. I can complete this project with in your desired time with added Quality. ""I have completed similar projects with five stars from client"". About Plus
Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010.I can handle your project in a very prudent manner. Give me more details Plus
Hi there, I can provide a formula that will get the EARLY, MID and LATE values from the data you paste in Column A. If you delete any of the cells in Column A or any rows, the formula will not be affected and you will Plus
Hi there, I am Nuwan. I can do your project with 100% accuracy. I have checked the project details and attached files; I can help you. I am really interested in your project. I am available to start working on it now. Plus
I'm Expert in Excel, the task you mentioned is basic for me and I can complete this quickly, short and simple proposal just like your task.