Get instant live Excel expert help with Text Functions
“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
Hi, Hopefully someone will be able to help me. I'm wanting to calculate the average sum contained within a range of cells discarding blanks. The problem that I'm encountering is that there is an additional feature where I only want to take into consideration columns that contain specific text.
=SUMIF(G79:HG79,"Sep-18",(G6:HG6/COUNTA(G6:HG6)))
G79:HG79 will contain the specific text with G:HG containing the digits.
Cheers all in advance
Solved by M. J. in 29 mins
Hello - I'm trying to delete some text that exists in a number of cells
Solved by V. H. in 15 mins
I have a conditional format that is color filled for favorable 10>8, unfavorable 5<9, and no change for 6=6, I would like to add text to the rules in the cell.
Solved by V. Q. in 20 mins
I am looking for a formula that combines several pieces of data. Here's what I mean:
ONE RED
TWO BLUE
THREE ORANGE
FOUR YELLOW
FIVE GREEN
If a single cell contains the text "ONE" and "THREE", can I get the output of another single cell to contain "RED" and "ORANGE"?
Solved by T. S. in 16 mins
Need help on SUMIFS function.
Criteria is working when it is on numbers and date but not working on text value criteria where I give >= and <= criteria values
Solved by X. E. in 22 mins
Refer to sheet "CLINICAL ACC"and C:C, I entered a formula in C2 for the entire column however all of my data is not populating. I am not sure if it is because of an issue with the formula or a formatting error. I should have a total of summary of 65 and only 5 are appearing. I do not have access to google docs so if you can just explain it in the text box I would appreciate it.
Solved by X. W. in 15 mins
Suppose I have multiple text in excel like,
ram
shyam
site
geeta
Now i want to use the formula which can help me to find
if ram=RAM or shyam=Shyam if not both then display geeta.
How can I do like that in excel.
Solved by K. D. in 15 mins
Hello, I need help formating rows so it automatically adjusts its cell size according to text
Solved by X. B. in 20 mins
I need to define a formula in spreadsheet wherein it fetch cell values from a separate sheet and shows me if the cell is populated or not, but I don't want to define range instead want to go with text. Is it possible?
Solved by I. Q. in 18 mins
I need to combined cells from different sheets to show the same text and colour. is that possible?
Solved by T. S. in 16 mins