Ask a Computer Question, Get an Answer ASAP!
Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your issues.Can you send me a sample Excel file with few data on it to work on?
Thank you. Please give me a moment to check your file.
Here is your needed formula:
Please note that the ranges A2:A7 and B2:B7 are locked so that you can drag down the formula without changing the range.
See the attached file.
Yes it should. I made the first formulas for you. Please try the same approach on the other columns. I will try to do them for you. But it is good for you to try it yourself as well.
Here is the completed file. Please check the locks made in the first formula. It is working now.
You're welcome and thank you for using our service.