Get instant chat 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
how to change first name and last name to last name, first name in a cell
Solved by S. E. in 24 mins
Use the VBA Editor to create a new module.
Function Depreciation (Value, Rate)
Depreciation = Value * Rate
End Function
Solved by G. S. in 30 mins
hi,
I am stuck in a problem since one week and need help!!!
I am running a SQL query in Excel 2010 VBA. The query runs fine but when I use GROUP BY, I get Automation Error.
Everything works if I remove Group By but I need to group data.
My query looks like:
Dim objRs As New ADODB.Recordset
Dim output As String
Dim trows As Integer
Dim ThisTab As Excel.Worksheet
Dim tcols As Integer
Dim i As Integer
Dim sSQL As String
' sSQL = "SELECT * from [Data] where [Rem Scen 2] > 0 and (Now() - [Eval Date]) <=60"
sSQL = "SELECT [Emp ID], [Deptt], [Job Types], [Join Date],[Pay 1]+[Pay 2] as [Compensate] from [Data] Group By {Emp ID]
With objConn
.Provider = "Microsoft.ACE.OLEDB.12.0"
.ConnectionString = "Data Source=" & ThisWorkbook.Path & "\" & ThisWorkbook.Name & ";" & _
"Extended Properties=""Excel 12.0 Macro;HDR=YES"";"
.Open
End With
' Execute once and display...
objRs.Open sSQL, objConn
Solved by F. E. in 30 mins
I have to format he cells that contain dates as the following if forecasted date is over due turn red, if date due is in 5 days it turns yellow and if the date is complete it should turn green. I have mulitple columns and each one of them have different dates. How do I acheive this?
Solved by A. C. in 14 mins
need to add more values and make sheet working which is not right now
Solved by M. H. in 29 mins
how to break external links to another worksheet but retain the formulae in this worksheet
Solved by K. B. in 12 mins
Hello! How do I Complete the one-variable data table in the range E2:H22 using cell B4 as the column input cell?
Solved by Z. J. in 14 mins
This problem was resolved in a previous session... but only in GoogleSheets. It did not work in Excel, because it exceeded the maximum number of nested formulas. I think my solution of simply needing a symbol to represent "ANY LETTER" is the best path, but I don't know how to represent this in a formula. Maybe I could assign a symbol the value of "Any letter"?? or does such a symbol already exist?? Please advise.
Solved by A. C. in 13 mins
I need help with excel pivot table. Hope i can get the help i needed on this homework
Solved by Z. Y. in 17 mins
Was trying to use VLook Forumula
But Value Missing from VLook formula and dispalying as #N/A
Solved by C. C. in 19 mins