Get instant live Excel expert help to learn how to find range in Excel

“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 need to change the the date range on the upper side of the sheet (Delivery timeline & resources)
Solved by C. B. in 21 mins
I need to change the date range in the chart underneath the section Delivery Timeline & Resources
Solved by S. W. in 26 mins
i have a chart of users to purchases. Im currently using =countif(range, criteria) but because theres 3000 users with 15000 purchases I need a formula that will give me the amount of purchases each user made with out adding them into one total rather than having to do it manually for 15000 rows.
Solved by M. F. in 25 mins
I have used the countonbgcolor script to count the background color as: function countOnBGColor(range, colorref) { var sheet = SpreadsheetApp.getActiveSheet(); var color = sheet.getRange(colorref) .getBackground(); var range = sheet.getRange(range); var rangeVal = range.getValues(); var count = 0; var allColors = range.getBackgrounds(); for (var i = 0; i < allColors.length; i++) { for (var j = 0; j < allColors[0].length; j++) { if (allColors[i][j] == color) count += 1; }; }; return count; } This works great but it does not update when the the sheet is updated. Is there a way to get the script to function automatically to update the value in change with the background color, even reloading the page doesn't update it. The only way I can get it to update is to change it then change it back. PFA Link.
Solved by K. L. in 29 mins
I have dates in cell range and words in another cell range. If the cell range with words contains certain words, I want that listed date place in a new cell range. A1 has 05/01/2017 A2 has 05/04/2017 A3 has 05/09/2017 A4 has 05/10/2107 B1 has Client Meeting B2 has Caregiver Meeting B3 has CFT Assessment B4 has Client Meeting F11 will have 05/01/2017, 05/10/2017 F12 will have 05/04/2017 F13 will have 05/09/2017 Hope that gives some understanding
Solved by Z. A. in 29 mins
Hi..I want to sum a range of data based on dates..
Solved by O. J. in 11 mins
Hello, I am trying to set a negative to positive range formula (i.e calculate between -5~5). If value in cell A2 is more than +5 result will be displayed as "not ok". If value in cell A2 is less than -5 result will also be displayed as "not ok"... If the value is between -5 to +5 it will show "ok". kindly help me for formula.
Solved by X. W. in 27 mins
I am trying to use excel to simulate the charging and discharging of a battery. As in once the battery reaches 1, the level of charge will decrease until it reaches 0 and then begin charging again back to 1. I have tried using multiple IFS functions that do not seem to be working as, for example:IFS(cell<=1, cell-10%, cell>0, cell+10%), the array will always continue to decrease or increase past 0 and 1 respectively and will never loop within the range. Hypothetically you can say that it increases 10% an hour from 0-1 and decreases 10% an hour from 1-0. Any help much appreciated thanks.
Solved by G. E. in 11 mins
My goal is to pull data from a specific row on one of 6 different worksheets by using drop downs. I have a drop down that indicates what "range" someone is in (these are the 6 different worksheets) and another drop down the (Current Grade) indicates where in that specific "range" worksheet to look for the data. I've dabbled with some of the formulas already, but am stuck on getting the data pulled in correctly / at all.
Solved by T. Q. in 22 mins
Function CheckColor2(range) If range.Interior.colorIndex = 2 Then CheckColor2 = 1 Else CheckColor2 = 0 End If End Function in Excel: =CheckColor2(B2) I m using above formula to check if column B row is colored or not. If column B row B2 is colored in red/green, it returns 0 to another column A in row A2. But when use this function, it return 1 to all the rows.
Solved by C. H. in 23 mins