Posts

Showing posts from 2013

vlookup in excel 2007 with example in excel

Image
FORMULA :- VLOOKUP (Which Value You Want To Search , Where You Want Search value , Table Index Which Value You Want To Display , FALSE/TRUE) =VLOOKUP(D8,A2:B7,2,FALSE)

excel group by count distinct

Image
formula :- in C2   =IF(SUMPRODUCT(($A$1:$A3=A3)*($B$1:$B3=B3))>1,0,1) excel 2007 count unique values multiple criteria 

compare two columns in excel for differences 2007

compare two columns in excel for differences 2007 comparing two columns in excel  =IF(A1=B1,"MATCH","NOT MATCH")