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 want to replace entire column............................................
Solved by B. B. in 40 mins
Adding a column exactly like tab ZC-Zorba highlighted yellow with Twitch Irony 5322 to tabs . . . ZD-Zorba, ZE-Zorba, ZB-Zorba, Other-Zorba, ATP-Zorba, ZC-Fines, ZB-Fines, Other-Fines, ATP-Fines, ATP
Solved by F. F. in 52 mins
My columns A and B on sheet 2 of a document get derive their values from columns A and B on sheet 1. I currently have sheet 2 sorted by column A first, then B (alphabetical on both). However, whenever I sort sheet 1 to try to get it in the same order it screws up columns C-F on sheet 2. The rows do not stay together, and therefore my client information on sheet 2 is shifted up or down a few rows. How do I ensure that when the rows change order when sorting that each row moves as a unit, not just the first two columns moving and the rest being out of order?
Solved by Z. Y. in 27 mins
I need to extruct data from column B for a particular month stored in column C as a date in format of dd/mm/yyyy
Solved by E. H. in 20 mins
hi, I'd like to search Sheet 2 for a specific name in column x, then copy data in the corresponding row and have it appear in a specific cell in Sheet 1
Solved by V. J. in 32 mins
I have a spread sheet with list of employee id's in column B. I have a 2nd spread sheet that has list of last names in column A, first names in column B and employee id's in column C. I need something that will look at each employee id on the first sheet, match that id up with one on the second sheet and then find the correspnding last name on the same row and replace the employee id with the last name in column B of the first sheet.
Solved by F. A. in 17 mins
i need a formula that returns a group of different lists in one column with each list showing under each other in one column
Solved by K. F. in 60 mins
I have share prices of several companies in a column for 10 years. I need to calculate the difference in share price each year. Can you help me how can I put a formula that calculates difference at every 10th item?
Solved by E. Y. in 19 mins
I have created an action item task list. Column C has drop down lists which say complete, pending, and in progress with corresponding color coding. The column next to it is the due date and I would like to get that column to change color as you change the progress status on the left simultaneously.
Solved by E. Y. in 20 mins
How do I delete rows with no values in them, but column A has values, thank you
Solved by B. L. in 22 mins