Re: $$Excel-Macros$$ Fwd: Lists Output request

2014-03-25 Thread priti verma
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,"

$$Excel-Macros$$ Fwd: Lists Output request

2014-03-25 Thread Ahmed Honest
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