Get instant online expert 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 huge data by date & almost data is zero. how to i get only figure data by date
Solved by A. H. in 11 mins
IF i consider A,B, C as my excel column, i am trying to find the cumulative sum in my C column (for example A1+B1 = C1 in first row and then in second row i need A1+A2+B2 =C2) simillarly A1+A2+A3+B3 =C3. how can i do that using excel formula?
Solved by E. Q. in 25 mins
I need to pull multiple cells of information into a single row, multi column spreadsheet. I basically need to pull all of the URLs that are associated with a single number into multiple columns in the same row.
For example, I have item 123. For that Item, on another spreadsheet, I have 10 different URLS associated with that item - URL1_123, URL2_123. etc, The URLs all contain the number of the item. But since there are multiple URLs, I am not sure how to pull all of them, I can only get one URL to pull in.
Solved by I. J. in 28 mins
9. Apply a custom format to cell J3 to display the text Initial Investment. Be sure that no negative sign appears before the custom format.
Solved by Z. J. in 27 mins
I need to learn text to column option in excel
Solved by E. Y. in 13 mins
Is it possible to reference a cell row in a formula. Example: in a particular cell a life expectancy is entered as a number. Say that number is 20. Then in a formula I want to enter the resulting value that appears in a column of numbers, say that column is F. So if we enter life expectancy of 20, then the formula would be equivalent to F20. If we enter 21 for life expectancy then if would be F21. etc
Solved by Z. L. in 11 mins
How do I get independent Column A and column B's that a macros code will run functions e.g., Hide Blank Rows or 0 value cells that wont affect the rows in the B column
Solved by B. H. in 11 mins
I need a formula to add all the data and combine for the day
Solved by B. B. in 28 mins
i am working in a large file and i want to extract data out of cells which are not in same format nor in same order i know mid right left etc and tried many combinations its not working need some help as data is not formatted i even cant do search dont know what to do
Solved by A. F. in 29 mins
formula help.
calculate - the amount of product divided by how many we do per her
Solved by B. W. in 27 mins