Simham Posted June 12, 2009 Share Posted June 12, 2009 hi mams.. i need some help on xcel there r 2 colums in xcel sheet..i want to compare both colums..and i want to display unmatched column B data with A.. for ex.. cloumn A column B A X B C C A so i want sort out frm those ..result supposed to be "X"..is there any option like this :-/ CAN ANYONE HELP ABT THIS..THANKS IN ADVANCE :-/ Link to comment Share on other sites More sharing options...
God Of Masses Posted June 12, 2009 Share Posted June 12, 2009 unix loo join/expand command vadu mama.........inka excel eendhi Link to comment Share on other sites More sharing options...
ntr_paritala Posted June 12, 2009 Share Posted June 12, 2009 Use =VLOOKUP(B1,A1:A16,1,FALSE) Link to comment Share on other sites More sharing options...
vjynani Posted June 13, 2009 Share Posted June 13, 2009 IT WILL WORK MAMA,TRY THIS =IF(FIRSTCOLUMN,SECONDCOLUM,TRUE) Link to comment Share on other sites More sharing options...
natasimham10 Posted June 13, 2009 Share Posted June 13, 2009 :-/ Link to comment Share on other sites More sharing options...
YUVAKISHORAM Posted June 13, 2009 Share Posted June 13, 2009 8) 8) Link to comment Share on other sites More sharing options...
Simham Posted June 13, 2009 Author Share Posted June 13, 2009 @ntr_paritala , vijayini mama both r not wroking . :-/ help me out mama Link to comment Share on other sites More sharing options...
Simham Posted June 13, 2009 Author Share Posted June 13, 2009 unix loo join/expand command vadu mama.........inka excel eendhi requirement ye EXCEL mama....unix vade antha pedda application kadhu..database emi vundadhu :-/ Link to comment Share on other sites More sharing options...
subash.c Posted June 13, 2009 Share Posted June 13, 2009 :( Link to comment Share on other sites More sharing options...
ntr_paritala Posted June 13, 2009 Share Posted June 13, 2009 @ntr_paritala , vijayini mama both r not wroking . :-/ help me out mama nenu test chesa..it worked.. copy the formula in first cell in 3 rd column...and drag down to copy the formula for rest of the cells in the 3rd column Link to comment Share on other sites More sharing options...
NatuGadu Posted June 13, 2009 Share Posted June 13, 2009 Link to comment Share on other sites More sharing options...
Simham Posted June 13, 2009 Author Share Posted June 13, 2009 thanx to paritala mama for his help to sortout this prb(yourock)((thanks) Link to comment Share on other sites More sharing options...
natasimham10 Posted June 13, 2009 Share Posted June 13, 2009 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.