I use this formula in condition formatting to change the row color red based on matching value between 2 sheets in the same workbook =SUMPRODUCT((‘Stop Work’!$D$8:$D$500=$C10)*(‘Stop Work’!$K$8:$K$500=”Open”))

I use this formula in condition formatting to change the row color red based on matching value between 2 sheets in the same workbook =SUMPRODUCT((‘Stop Work’!$D$8:$D$500=$C10)*(‘Stop Work’!$K$8:$K$500=”Open”))

I’m creating a fitness tracker with daily inputs & a weekly summary on a dashboard. My daily input data looks like this:

I am trying to solve an issue in excel in which I have a column of data that contains a mix of both letters and numbers. In a new column I would like to extract if and only if the data column contains a cell that has a 10 digit number that starts with a 9 and if not returns blank.

I am trying to solve an issue in excel in which I have a column of data that contains a mix of both letters and numbers. In a new column I would like to extract if and only if the data column contains a cell that has a 10 digit number that starts with a 9 and if not returns blank.

I am trying to solve an issue in excel in which I have a column of data that contains a mix of both letters and numbers. In a new column I would like to extract if and only if the data column contains a cell that has a 10 digit number that starts with a 9 and if not returns blank.

So I have a cell that contains three lists with line breaks separating them:

So I have a cell that contains three lists with line breaks separating them:

So I have a cell that contains three lists with line breaks separating them:

So I have a cell that contains three lists with line breaks separating them: