Get instant live expert help with Excel and Google Sheets

I have tones of data for a uni project, we have to put it into graphs for market analytics. We have no. of units, some of sales, account number, transaction date, product, time sequence, transaction id. We then have additional details of each brand, e.g. sugar level, and I can send you all these in text form. What we want back is a selection of graphs, made using the data, which segment the market in a variety of ways, is this something you could help with? We don't really know how to put the date into excel to make the graphs, and are unsure how to segment the market.

I have created a amortisation table and I need to info the total loan cost (all repayments) using excel tvm functions but not the SUM function

in cell Q3 nest the existing VLOOKUP function in an IFERROR function. If the VLOOPUP function returns an error result, the text "invalid staff ID" should be displayed by the formula. Existing function is =VLOOKUP(Q2,CBFStaff[[Staff ID]:[Name]],2,FALSE)

getting error stock symbol no longer existed on downloading the historical stock data from yahoo

Can you help me to create a formula that will lookup the shift sched & credited hours of each employee?

Need to get data from a table or pivot table(s) to a spreadsheet to obtain travel time and mileage from one location to another for the spreadsheet.

Hi, I'm trying to work out a formula for a spreadsheet. I am collecting school results and have created a spreadsheet that has the school subject at the top and student down the side. I need a formula that states if they have at least 5 grades from 3-9 Incl. Maths & English then it says "yes". Can you help?

I have a 9x9 matrix of cells (C2:K10). Some have numbers in the cells others do not and are empty. I want create a macro that will allow me to set the text format and size of text (or numbers) in those cells, and to pre-set the format of the empty cells to another style and size. I can then clearly identify where the original numbers were, and where the numbers that were subsequently added are placed. I have created to two text formats I want to use and have called them simply Large and Small in the Styles list. I have been trying to use macros to do this but have found that I need to create an “IF” function which I cannot do by recording key strokes. One needs to edit the macro code which is in VB and have not yet fathomed out how to use it. Please can you help

i want to send a number i select from range of numbers to the bottom and shift cells up

I am coping data from a "scanned sheet" to a "database sheet" to create a database. I copy the first record but I'm not sure how to add 2nd and third record. may need aloop Example: Private Sub CommandButton2_Click() 'Copy A Range of Data Worksheets("INPUT SCREEN").Range("D7").Copy Worksheets("COLLECTED DATA BASE").Range("B2").PasteSpecial Paste:=xlPasteValues Worksheets("INPUT SCREEN").Range("D8").Copy Worksheets("COLLECTED DATA BASE").Range("C2").PasteSpecial Paste:=xlPasteValues I need to have it find the next empty "record" Row on the "database sheet" and loop through to save it to the next row. and continue on and on.