for first query try thi with CSE
=SMALL(IFERROR(IFERROR(SMALL(IF($C$5:$C$14<>$B$5:$B$14,$C$5:$C$14,""),ROW(INDIRECT("1:"&$C$5:$C$14))),IF($B$5:$B$11<>$C$5:$C$14,$B$5:$B$11,"")),""),ROW(INDIRECT("1:"&COUNTA($C$5:$C$14
and for second try this wit CSE
=SMALL(IF($C$5:$C$14<>$B$5:$B$14,$C$5:$C$14,"
Dear All:
Please see attach excel file and if you can help me with a formula to
generate OUTPUT in 2 different ways from List 1 and List 2.
*Thanks in advance!*
--
*Ahmed Bawazir*
*احمد باوزير*
--
*Ahmed Bawazir*
*احمد باوزير*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you