Get instant chat help with Excel and Google Sheets
“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 a Budget of $1000 I and I have 4 different expenses of 100, I would like to see the $1000 to be reduce every time I am entering the expenses so at the end of the month I can see how much money I have.
Solved by C. C. in 29 mins
Based on the list of values reported on table A and using only excel formulas, return on table B the letters associate to the numbers
Solved by X. W. in 18 mins
I want to know what the value in b3 is when i3 = no
Solved by G. W. in 22 mins
hello, On the Pivot chart Y Axis the Text Label is repeating twice. How to eliminate this issue.The text label should only show once
Solved by G. H. in 22 mins
Need a formula in cell AB374 to sum AA374:AA738 but stop counting after 48 points are entered from the AA column. In summary, the total points are calculated until the points reach 48 for the year 2018 and after 48 points are reached this column will return a blank cell. Note that the template shows 2017 and 2018, the only concern for this formula is 2018.
Solved by S. Q. in 18 mins
Looking to get every D to add 1 and every H to add 0.5.
=SUMPRODUCT(COUNTIF(INDIRECT("'"&Data!$C$2:$C$13&"'!B4:AG4"),{"D","H"},{1;0.5}))
Solved by I. F. in 27 mins
Match user search to ID from Sheet 2 to Sheet 1
Solved by X. W. in 28 mins
hi i need help , when i work on excel sheet is big so some time i got formula error or its suddenly close and never open if i trying to open they gave recover msg but may be some data lost , why i am getting this msg
Solved by G. W. in 21 mins
How do i perform a t-paired test of 2 samples that are not the same size
Solved by S. H. in 22 mins
I need a formula that that extracts the data from all rows from a given column of a data table (Excel 2016)
Solved by A. J. in 17 mins