How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
Can anyone help with a formula please… I have rows of data and what I want to know are the rows that have a zero anywhere between numbers greater than 1…
So B1:H1 is a row of interest because zeros appear between numbers greater than 1… Where B2:H2 is not of interest because all the numbers greater than one are in one single block… My workbook is much bigger than this but I’ve just used this as an example…
Would be great if the formula could going in A1,A2,A3, please…
So B1:H1 is a row of interest because zeros appear between numbers greater than 1… Where B2:H2 is not of interest because all the numbers greater than one are in one single block… My workbook is much bigger than this but I’ve just used this as an example…
Would be great if the formula could going in A1,A2,A3, please…