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 need help to fix a logic check formula to compare two values, but pull one as text *1 to take formatting into account.
I'm attempting '=IF(INDEX(TEXT(A16,"0"))*1)=(INDEX(C16)),"CORRECT","FAIL" but a VLOOKUP might work as effectively
Relates to a significant excel bug - see sheet
Solved by V. U. in 28 mins
I have a problem with rearranging data in a spreadshet to give a more useable spreadsheet. I have asked question from you already. You have given good answers but I have been asking the wrong questions! I attach a file (What I want 3) which explains my needs
Solved by M. D. in 27 mins
I need help creating a hyperlink to go to specific sheet...
Solved by M. J. in 13 mins
In excel how do I activate an object based on a value from a cell.
I'm wanting an arrow to appear based on a value in a cell that has been returned from the sum (formula) of a range of cells.
I'm trying to teach myself to code and I'm very much at the beginning stage
Solved by I. S. in 29 mins
Trying to amalgamate values by client in order to understand potential asset
Solved by I. U. in 24 mins
Hi, I need a formula which derives a list of items(in another sheet as a table) after meeting certain criteria. For example :
if X = 123 and Y= 425, then:
1. AABC
2. CCBC
3. AASD
4. EEER
Solved by E. U. in 30 mins
I have a Mac. I am trying to use ctrl+F function key. I never had a problem before. Now even the data is there which I need to find or replace. It always gives message that cant find data. Can you help me to fix this problem.
Solved by I. J. in 14 mins
Hello Friend,
Find duplicates and remove all of them from the array.
For example, I have following list
A
A
B
C
D
D
So I want result as follow
A
C
Solved by T. J. in 19 mins
Having a probme with my Indirect Function and it skipping certain numbers when it is pasted.
Solved by X. D. in 15 mins
I was working with someone before that I need to get back with. They were helping me with a spreadsheet on solar power.
Solved by G. F. in 29 mins