Get instant live expert help on how to name a range in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have excel 2016 for Mac, and there is no Names Manager. How can I change the range for a name from workbook, to an individual sheet?
Solved by K. E. in 28 mins
Looking for solution -
look at date tab - Look at name on summary tab column B - count how many New and Existing (column C- data tab) fall in specific date range Row 3 (summary tab) and count how many are within that 15% range per name in that given month
Solved by S. D. in 20 mins
assign the range name called database to the range A14:J178
Solved by V. B. in 16 mins
how do i look up a name in excel using the vlookup function, ie the display name is 123 and the underlying name is Product_123
Solved by O. J. in 17 mins
I Am using a Sumifs formula , so i have created for date range with 2,3 cell, but when i am adding new name the formula have to copy and special paste (value), now i want to auto update the cell value with formula cell refernce.
formula is =Sumifs('A'!B:B,'A'!A:A,">="&B3,'A'!A:A,"<="&C3)
SUMIFS(CELL NAME RANGE,CELL VALUE,CELL NAME RANGE DATE RANGE)
Solved by G. L. in 21 mins