Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

I have 2 sheets: Sheet A: I have Dates in 1 Column (A1:A10) Sheet B: Date will be show in B1: (query what is in A1 in Sheet A) I'm searching for a query formula to get always the last entry (A1:A10) Is there any possibility to show the last entry from Sheet A (A1:A10) which one has a Date in there?
Solved by O. Q. in 11 mins
I would need a formula what copies from my DataInput sheet into another one daily the first two column A and B.
Solved by K. S. in 33 mins
I have copied and pasted a list of 16 participants from an email invite into excel and i want to create a list of participants in each cell. they are separated by the ; and i would like also to put their email address in a corresponding column . can anyone point me in the right direction
Solved by S. Q. in 16 mins
I need a formula created that will create add totals from 2 dynamically created sheet in a third sheet. List of items in column A with remainders of columns created dynamically depending on what is entered in over sheets but will always be one of 82 variables
Solved by B. B. in 60 mins
For some reason all of the column identifiers (a,b,c,etc.) are green but only rows 1-12 are and when I go to organize the sheet the green rows are the only ones organized.... ( by way of filter header) I removed all formatting on the sheet but it didn't seem to make any difference. There is a thin green line between rows 12 and 13 that I cannot move or get rid of.
Solved by X. J. in 13 mins
i have 1 spread sheet that i take out with me on site and fill in as i do site survey i have a 2nd spreadsheet that i need to populate with the info from spreadsheet 1 but this is a large spreadsheet and has loads of formulas i have done the first column and then thought i could just drag the formula down but it doesn't work any suggestions please? probably didn't explain that very well
Solved by E. Q. in 39 mins
How do I change a column of (-) Negative values to Positive? (+) I have a list of business expenses on a spreadsheet.
Solved by X. W. in 30 mins
I want a formula to be able to record the current time when a cell was entered but I do not want it to change when another cell is entered. eg I want a column where i can eneter a number and an adjacent cell to record the time it was entered. Thanks
Solved by A. E. in 19 mins
I'm attempting to add a secondary axis for a clustered 3d column chart - I've seen online a suggestion of going to the design ribbon after selecting the chart and selecting add chart element - I don't see where the add chart element command is
Solved by F. Q. in 39 mins
Hello good afternoon, I have a problem with excel. I need a formula to compare data between 3 columns and give me the result in a fourth column
Solved by X. B. in 58 mins
1 2 32 33 34 35