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!
Bu iş için 60 freelancer ortalamada $22 teklif veriyor
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 Daha Fazla
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 Daha Fazla
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. Daha Fazla
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.