Are you stuck on Excel or Google Sheets?

I am sorting an old spreadsheet with lots of expired contracts. Column X shows all the product serial numbers. Column A shows the contract expiration date relating to the serial number. The serial numbers are often duplicated where a customer has renewed their cover for the same product.over several years. I want to create a new column which sorts out those expired contracts between "Expired - Renewed" and "Expired - didn't Renew". Help! Please!

how do Iink a column from workbook 1 to workbook 2, but, the column I want to link from workbook 1 is in row 1 - 10 but in workbook two the column is linked but is staggered, i.e. row 1, 3, 5 then row 12, 14, 16, then row 23, 25, 27, then row 34

Sir I have 2 column A bank name B Revenue I want to get who bank name revenue in top and who in second

I need to create a formula where column D becomes the date in column C + 5 business days when I enter a date into column C

How can I reference a cell in 1 sheet to another sheet and then drag the vertical source horizontally without the Column changing

I have a list of names. They are all in 1 column. I would like to split up the first and last names into 2 columns without having to do each name individually.

Using the data in Column A I want to match the data in Column B showing me what data is missing or unmatched. How can I do this?

I'm trying to write a formula that would find the percentage of Invoices that have stayed in the same Row rank for 2 months. The sheet I'm working on is labeled Top X and the formula should be written starting in Q200. The Row rank is found in column J, the Account ID is column B, and the Date range is in C.

I have calculated percentages in a column but they are showing for example 1800% instead of 18%. How do I remove the 2 zeros at the end. I tried decreasing zeros and it will not take them away.

I was jut receiving help from a spreadsheet expert. He/She was able to create the right formula in cell F2, but now I'd like to figure out how to easily take that formula across column 2 without having to type in date and time criteria for each cell.