Get instant live expert help on I need help with excel delete name range

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a formula "=COUNTIFS(D2:D1000,">=11/1/2018",D2:D1000,"<=11/30/2018")" I use this to count dates of interviews. One problem I'm having is that as I finish an interview I move the row to another excel page and delete it from the page it was on. As I delete rows the range of my formula gets smaller. After a month of adding and moving rows, the formula range decreases to around D2:D55. How can I make my formula stay D2:D1000 even when I delete rows within that range?
Solved by B. Y. in 14 mins
How do I add or delete people to an already created drop down name list?
Solved by F. B. in 13 mins
Im trying to delete cells with duplicate names, but with different dates associated with them. One column has the name and another the date. How can i delete all the duplicate name cells while sorting for the most recent date?
Solved by C. C. in 17 mins
assign the range name called database to the range A14:J178
Solved by V. B. in 16 mins
I want to delete certain rows in excel, the rows which I have to delete comprises of few values
Solved by A. J. in 25 mins