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!

Hi, How to make one column with long llist of names into three columns
Solved by A. B. in 32 mins
I need a formula that (1) finds a value in Column A, (2) copies all data in Column A between the cell found in (1) to a new value in Column A. (3) pastes what is copied to a designated range of cells (column) in Column B.
Solved by V. D. in 37 mins
I am creating a checkbook register, columnD is deposits, Column E is withdrawal, columnF is balance, how do i get a running total in the balance column
Solved by K. Q. in 16 mins
I have 2 excel files. I want to highlight the values in column A of Table 1 which appear in Column 1 of table 2. Thanks for your help
Solved by S. H. in 43 mins
hi I need an entire column of annual salaries to monly salaries on excel.
Solved by G. E. in 20 mins
I have a column of percentages (11 in a column). I want to have a percentage at the bottom of the column that tells me how many of the entries are = to 100%.
Solved by X. E. in 20 mins
I have a date column and would like to post consecutive Wednesdays by calendar date
Solved by B. U. in 20 mins
I recently had another got it pro agent make it so the format of the "due date" column changes color with the date. He didnt make it so it goes red when the date is PAST due, instead it will not format the cells. Please fix? Thanks.
Solved by O. Q. in 19 mins
Is there a way to compare all rows to each other? I have a large 3000 row spreadsheet, and on one column, I would like to compare row 1 vs 2, 1 vs 3, 1 vs 4, 1 vs 5, 1 vs 6.....2999 vs 3000. I know, that's 5 million combinations. I will be dividing the smaller number into the larger number, to get a percentage/correlation.
Solved by O. Q. in 32 mins
In my spread sheet I want to create a column where I can take a % off a number and all the numbers in a column will change by that %. I want to be able to change the % to see different results
Solved by V. U. in 36 mins
1 2 33 34 35