tommy Posted June 28, 2013 Author Report Posted June 28, 2013 [quote name='BathiBottleBisket' timestamp='1372384928' post='1303898244'] email meedha sheet at [email protected] I will try and reply. [/quote] Pampincha bhayya ippude tinaniki poyanu....
150bryant Posted June 28, 2013 Report Posted June 28, 2013 [quote name='tommy' timestamp='1372390502' post='1303898478'] pampincha bhayya... [/quote] all evaru leru....ee email ki pampu.. [email protected]
tommy Posted June 28, 2013 Author Report Posted June 28, 2013 [quote name='BathiBottleBisket' timestamp='1372385667' post='1303898285'] 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. [/quote] Net lekunde bhayya
tommy Posted June 28, 2013 Author Report Posted June 28, 2013 [quote name='BathiBottleBisket' timestamp='1372390561' post='1303898487'] all evaru leru....ee email ki pampu.. [email protected] [/quote] Pampinchina bhyya ippude
150bryant Posted June 28, 2013 Report Posted June 28, 2013 [quote name='tommy' timestamp='1372390654' post='1303898498'] Pampinchina bhyya ippude [/quote] excel lo kastam kaani....i will do in ms access and send..in few mins.
tommy Posted June 28, 2013 Author Report Posted June 28, 2013 [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] first sheet lo oka row second sheet lo anni rows tho compare chesi data match ayina vatiki fifth column difference ivalii.Ila first sheet lo anni rows verify cheyali.Ila oka 10000 rows unayi
tommy Posted June 28, 2013 Author Report Posted June 28, 2013 [quote name='BathiBottleBisket' timestamp='1372391250' post='1303898529'] excel lo kastam kaani....i will do in ms access and send..in few mins. [/quote] Bhayya requirement ardam ayindhi kada...
150bryant Posted June 28, 2013 Report Posted June 28, 2013 [quote name='tommy' timestamp='1372391567' post='1303898542'] Bhayya requirement ardam ayindhi kada... [/quote] sent results chudu.. sheet 4 lo unaaye... match aina vaatiki maatramey difference theesanu..match kaani vatiki teeyaledhu. I did it in MS-access but sent u an excel file
150bryant Posted June 28, 2013 Report Posted June 28, 2013 Requirement: 2 sheets lo unaye.. each sheet has 5 columns. first 4 columns in each sheet combine chestey unq_id avthundi. 5th column is balance amt. so two sheets lo unq_id match aina vaatiki differences in balances kaavali.
tommy Posted June 28, 2013 Author Report Posted June 28, 2013 [quote name='BathiBottleBisket' timestamp='1372392313' post='1303898583'] Requirement: 2 sheets lo unaye.. each sheet has 5 columns. first 4 columns in each sheet combine chestey unq_id avthundi. 5th column is balance amt. so two sheets lo unq_id match aina vaatiki differences in balances kaavali. [/quote] Thanx bhayya....
k2s Posted June 28, 2013 Report Posted June 28, 2013 [quote name='BathiBottleBisket' timestamp='1372392313' post='1303898583'] Requirement: 2 sheets lo unaye.. each sheet has 5 columns. first 4 columns in each sheet combine chestey unq_id avthundi. 5th column is balance amt. so two sheets lo unq_id match aina vaatiki differences in balances kaavali. [/quote] use Pythagoras theorem & [color=#444444][font=arial, sans-serif][size=1]Zur Elektrodynamik bewegter Körper relativity [/size][/font][/color]man... thats it
150bryant Posted June 28, 2013 Report Posted June 28, 2013 [quote name='Scrooge' timestamp='1372392604' post='1303898603'] use Pythagoras theorem & [color=#444444][font=arial, sans-serif][size=1]Zur Elektrodynamik bewegter Körper relativity [/size][/font][/color]man... thats it [/quote]antha english raadu man ...naaku
Recommended Posts