Dear Exceler,
I have a problem that appreciate if anyone can help?
I have tried doing a function to extract unique list and remove duplicates. It results in #N/A.
=INDEX(tt,MATCH(0,COUNTIF(tt,"<"&tt)-SUM(COUNTIF(tt,C$1:C1)),0)) where tt is:
=$A$4:INDEX($A$2:$A$20,MATCH($A$1,$B$2:$B$20)) -->
I check the error in excel for the first formula and tried pressing F9 for each of the function and they all work.
For the first formula, when I only leave the COUNTIF and SUM function in the cell, it showed value.
When I leave the whole MATCH function, it leaves a #N/A. However, when I checked in the edit formula bar by pressing F9, it result in the value as expected.
I dont understand why it would results in #N/A in excel but F9 showed it has no problem.
Anyone can help? Thanks.
Regards,
ezfan
I have a problem that appreciate if anyone can help?
I have tried doing a function to extract unique list and remove duplicates. It results in #N/A.
=INDEX(tt,MATCH(0,COUNTIF(tt,"<"&tt)-SUM(COUNTIF(tt,C$1:C1)),0)) where tt is:
=$A$4:INDEX($A$2:$A$20,MATCH($A$1,$B$2:$B$20)) -->
I check the error in excel for the first formula and tried pressing F9 for each of the function and they all work.
For the first formula, when I only leave the COUNTIF and SUM function in the cell, it showed value.
When I leave the whole MATCH function, it leaves a #N/A. However, when I checked in the edit formula bar by pressing F9, it result in the value as expected.
I dont understand why it would results in #N/A in excel but F9 showed it has no problem.
Anyone can help? Thanks.
Regards,
ezfan