I have developed a formula that searches inside an identified column letter (AB or F) for information. Sometimes my coworkers add or remove columns from the spreadsheet which causes the formula not to work.
If I know that the column i want to search every time is called "Day of the week". how do I change the column letter (AB) to find the column "Day of the week" and then search that column for the info.
The data has multiple entries in the cell (Monday, Tuesday, Wednesday) so to get a count by day i use the above formula. just trying to prepare for standardized header name (Day of the week) with a column that varies
Sheet1 and Sheet3 is the data and Sheet2 and Sheet4 is the formula. When a new column is added in Sheet3 it messes up the formula in Sheet4 because the column that was B is now C. I would like the formula to look for column month instead of B.