AthmanArumugam
Member
Hi All,
I have a requirement where I need to compare the value in one cell [A1] with each and every cell in column B [B1,B2,B3...]. The number of rows in column B is ever changing.
If it is static , I can achieve it using the formula = if(or(A1=B1,A1=B2,A1=B3),"True","False").
How I can achieve a for loop [ to traverse all the cells in column B] without the use of macros and do it only using formulas.
I have a requirement where I need to compare the value in one cell [A1] with each and every cell in column B [B1,B2,B3...]. The number of rows in column B is ever changing.
If it is static , I can achieve it using the formula = if(or(A1=B1,A1=B2,A1=B3),"True","False").
How I can achieve a for loop [ to traverse all the cells in column B] without the use of macros and do it only using formulas.