I have following data which has the Product ID and their order dates in each column in descending order.

I am working with multiple data sets where a cell can have multiple values. I want to apply a conditional formatting on a cell with a formula to highlight the cell when it contains a keyword.

I’ve got an array on A1:An where n will change quite often. I’m trying to write a formmula that replaces the first and second element of the array for the values on cells F1 and F2, and also the nth and n-1th elements need to be replaced for the values in G1 and G2, keeping all the other elements without any changes.

Goal: Make life easier for Chemistry equations
Disclaimer: I do not use Excel often enough to use complex functions.

I have a table as below:

I have a alphabetized dataset of:

Hopefully I am overthinking this but I am trying to do the following –

I am trying to build a massive keyword database for Google Ads, using Excel to substitute one keyword for another, which has already saved countless hours.

I have the following issue, I try to make a formula to refer to an external excel file based on the date. When try format the date to ddmmyy and use it in this formula I get a #ref error.