Here are some problems that our users have asked and received explanations on
I'm having trouble with Excel Online from Office 2016. For some reason, my fill handle is not working properly. It now only allows me to select a single cell, or a row OR a column but not both. For instance, I'm trying to select cells D4:F39. It will only allow me to select row D, or column 39--but not all of the cells like I need it to. I'm not sure what I did wrong. Excel was working fine when I first started. Please help!
Solved by T. F. in 19 mins
I would like to create a formula that will display a sales person's tier based on avg monthly sales.
Solved by S. L. in 20 mins
I want to add a conversion tool to my spreadsheet
Solved by O. H. in 21 mins
please do not try to solve this if you have no idea how VBA and functions work. I've now spent a lot of time with experts who have no clue how things work.
The problem is calculating distance between two cells while using a function. Can you help with vba else if?
Solved by F. D. in 21 mins
i need help with this excel sheet for a project.
Solved by I. U. in 24 mins
Hi - i am stuck on formula. It should be quite simple but I am relatively new to google sheets. i would like to bring in data from another sheet where a corresponding row has a particular value
Solved by B. H. in 24 mins
I need to remove the "-" and the 2 numbers after but nothing else.
example:
11-08 Audi S5 needs to end up 11 Audi S5
Solved by A. Q. in 26 mins
i'm trying to do the 3 odd & one even numbers in column a , as it was done in l column . and a frequency of all the numbers, i might enter in column a.
Solved by Z. Y. in 29 mins
I need to add a parameter to the following: =IF(U2=6,IF(AD2=1,150,IF(AD2=2,175,IF(AD2=3,200,""))),"")
If U2=7, 100
Solved by O. W. in 22 mins
Hi, I have some data and need to make a comparison chart between one Carrier and another.
So 2 carriers.
5 or so different 'Reason codes' from which we making the comparisons and for each reason code we're comparing the amount.