Get instant free expert help with Excel and Google Sheets

i need a chart to keep my invoices numbers, names amount date and description

I have a column of numbers that change or can be the same and i need to count how many times each number is in that column and then on a new spreadsheet write that number and how many times it appeared

i keep getting the #N/A for this vlookup =VLOOKUP(I3,A3:D6,4,FALSE) what's wrong with it?

really need help trying to pick data from 7-am-7am day to day. I am close but need additional help to finish it off...... thanks

Hello I am trying to use Auto sum . After I total up some cells, When I go to change one cell it does not total up automatically. I have to reuse auto sum every time I make a change. Do you know how I can fix that?

I need to use the SUMIF function dynamically in VBA. For the range, I have tried to build the range: "$C$2:$C$" & lastRow, but it does not work. I then created the variable: MyRange = $C$2:$C$ & lastRow and then I place MyRange in the SUMIF formula. Nothing works! An example of code: lRow = Cells(Rows.Count, 3).End(xlUp).Row myAddress = "$C$2:$C$" & lRow MsgBox TypeName(myAddress) Range("I:I").ClearContents Range("I1").Value = Month(dtDate1) Range("I2").Select ActiveCell.Formula = "=sumif(myaddress,h2,$e$2)"

I am trying to do two drop down boxes with one dependent on the first. I am using =Index(Options, Match(C5, Drugs, 0)). I am using this in Libre and it works fine but in Excel it gives me a #REF error every time.

I need to know if a formula can be written to pull information from one excel into another based off multiple criteris. vlookup index match might work, I cannot get it to work and can upload the files

Trying to create a button that is on a sheet in a workbook that updates the value in my personal workbook that is always open.I need to do this on 10 different workbooks. so I kinda need an explanation. I also don't have an example.but I'm making a mini database that updates with a button on multiple workbooks.

Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6. Good B7 = .0325 B8 = 5 E6 = 275000 Most Likely B7 = .057 B8 = 5 E6 = 312227.32 Bad B7 = .0700 B8 = 3 E6 = 350000 Create a Scenario Summary Report based on the value in cell B6. Format the new report appropriately.