Here are some problems that our users have asked and received explanations on
I am looking to export part of an excel spreadsheet: only those lines that have some text in Column N. How do I do that please?
Solved by B. Q. in 16 mins
I have 2 figures and I need to calculate what i need to get to a certain percentage
Solved by S. D. in 18 mins
I am trying to make two graphs for a paper using data I collected. I was thinking a scatter plot. The y-axis needs to be a range 1-5 and the x-axis needs to be a range of dates and there will be 3 different shapes for the 3 different sections of data.
Solved by K. H. in 25 mins
In sheet 1 there is a large database containing 2000 names with their TXPDate and MRN. In sheet 2, there is a list of names with empty spaces for MRN and TXPDate. I need to fill the empty spaces in sheet 2 with the data from Sheet 1 with the PTName as the common reference
Solved by C. U. in 14 mins
my whole spreadsheet is not adding up the numbers as if the formulas just quit working. Never experienced this
Solved by G. J. in 22 mins
hi! I had been keeping a workbook of a 7-day worth of activity tracking. I saved the document, my computer did not crash or even power off but the document is gone. earlier in the week, my computer did power off but it was able to restore the unsaved data to the latest version-- even this version is gone. What do I do?
Solved by M. W. in 24 mins
I've put a formula into a column of cells. It's a simple product formula, but everytime I put the value into the cell, it simply erases the formula, rather than let it do its magic. (It's the Automotive column, L)
Solved by B. W. in 22 mins
If the range of cells present in a text, I want the name that is present, for example I have a list of user names, if their name is present in the paragraph, I want that name to be extracted
Solved by C. D. in 14 mins
I MAKE FILE IN THAT I WANT SOME CHANGES I APLAY FORMULA FOR IF C=D I WANT SHORT @ IF C=E I WANT LONG @ THAT I GET BUT WHEN C=D=E I ALSO GET RESULT AS SHORT @ OR LONG @ BUT I WANT IF C=D=E AS RESULT I WANT BLANK IN N COLLOUM PLEASE HELP ME FOR EXAMPAL I MARKED YELLOW N6 AND N10 IN THAT I WANT BLANK
Solved by G. H. in 18 mins
I am trying to find the top 5 spenders in an excel table. What is the function for it?