tommy Posted June 28, 2013 Report Posted June 28, 2013 Bhayya 2 sheets lo different cells match chesi common vaati difference kanukovali.....evairaina formula chepandi
pinky123 Posted June 28, 2013 Report Posted June 28, 2013 2 sheets lo which ranges lo data undi? which columns ni compare cheyyali? common vaati difference ante ardham avvaledu? koncham elaborate chesi cheptava?
tommy Posted June 28, 2013 Author Report Posted June 28, 2013 example Sheet 1 A B C D amt..(5 cells) Sheet 2 A B C D amt..( cells) so ippudu both sheets lo aa four cells lo unna data match avali. oka vela ithey dani amount diff entha ..diniki formula..chala data undhi
Swami Posted June 28, 2013 Report Posted June 28, 2013 common ga vunna vati diffrence enti brah! ask your question clearly.. will try to answer
150bryant Posted June 28, 2013 Report Posted June 28, 2013 3rd sheet open chesi... oka cell lo = kotti then select A1 in sheet1 then = kotti A1 in sheet2... enter nokku.. it its equal...u will get TRUE..if not equal it will get FALSE.
150bryant Posted June 28, 2013 Report Posted June 28, 2013 [quote name='tommy' timestamp='1372384669' post='1303898234'] example Sheet 1 A B C D amt..(5 cells) Sheet 2 A B C D amt..( cells) so ippudu both sheets lo aa four cells lo unna data match avali. oka vela ithey dani amount diff entha ..diniki formula..chala data undhi [/quote] email meedha sheet at [email protected] I will try and reply.
pinky123 Posted June 28, 2013 Report Posted June 28, 2013 okka vela two sheets lo aa four cells lo data match avuthe aa match ayina each row amounts difference should be published in a third sheet?
150bryant Posted June 28, 2013 Report Posted June 28, 2013 [quote name='tyke' timestamp='1372384950' post='1303898245'] okka vela two sheets lo aa four cells lo data match avuthe aa match ayina each row amounts difference should be published in a third sheet? [/quote] he needs equal aitey equal.. if not equal giv difference..
Swami Posted June 28, 2013 Report Posted June 28, 2013 dude ni sheets lo oka two row teesukoni example ga ivvu ikada clear ledu question
Swami Posted June 28, 2013 Report Posted June 28, 2013 [quote name='BathiBottleBisket' timestamp='1372385097' post='1303898251'] he needs equal aitey equal.. if not equal giv difference.. [/quote] if they are equal then difference will be zero kada?
pinky123 Posted June 28, 2013 Report Posted June 28, 2013 assuming that you want the values in sheet 3.. and assuming that you sheet names are Sheet1 and Sheet2, you can try using the formula below and copy it to the rows where you want the data to be: =IF(AND(Sheet1!A2=Sheet2!A2,Sheet1!B2=Sheet2!B2,Sheet1!C2=Sheet2!C2,Sheet1!D2=Sheet2!D2),(Sheet1!E2-Sheet2!E2),"Not Matching")
150bryant Posted June 28, 2013 Report Posted June 28, 2013 [quote name='Swami' timestamp='1372385256' post='1303898260'] if they are equal then difference will be zero kada? [/quote] [quote name='tyke' timestamp='1372385268' post='1303898262'] assuming that you want the values in sheet 3.. and assuming that you sheet names are Sheet1 and Sheet2, you can try using the formula below and copy it to the rows where you want the data to be: =IF(AND(Sheet1!A2=Sheet2!A2,Sheet1!B2=Sheet2!B2,Sheet1!C2=Sheet2!C2,Sheet1!D2=Sheet2!D2),(Sheet1!E2-Sheet2!E2),"Not Matching") [/quote]aadu sheet isthey kadha saami edokati cheyochu... help chestha annakaani....toomuch....ignorance.. email ichi ..pampu anna kaani...patinchkotledhu... looks like may be he is not in dire need.
150bryant Posted June 28, 2013 Report Posted June 28, 2013 [img]http://www.andhrafriends.com/ads/april2013/iQlik.gif[/img][img]http://www.andhrafriends.com/ads/june2013/Tvisha.gif[/img]
tommy Posted June 28, 2013 Author Report Posted June 28, 2013 [quote name='Swami' timestamp='1372385084' post='1303898250'] send it to [email protected] i will do it [/quote] pampincha bhayya...
Recommended Posts