Excel formulas

88. Find First non Numeric Value in a Range =IFERROR(INDEX(A1:A100,MATCH(1,INDEX(--ISTEXT(A1:A100),,),0)),””) 89. Find Last non ...

=AGGREGATE(15,6,1/(($A$2:$A$10="West")*($B$2:$B$10<>0))*($B$2:$B$10),1) 93. Generate a Unique List out of Duplicate Entrie ...