Wednesday, October 30, 2013

vlookup in excel 2007 with example in excel



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



formula :-

in C2

 =IF(SUMPRODUCT(($A$1:$A3=A3)*($B$1:$B3=B3))>1,0,1)


excel 2007 count unique values multiple criteria 


Saturday, October 26, 2013

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")