MS Excel expert plz help

[Sajid286]

Mere piyare ITD Freinds
Assalam o Allaikum

Mujhe aik masla kuch dino se darpesh hai jis ki main aap ko detail bataye deta hon
Mere paas excel ki 2 alag alag files hain.
File 1 main 1800 Nos aur agle 20 colums main unn ki detail hai
File 2 main sirf 1440 Nos hain jo file 1 main be shamil hain aur wahan per unn ki detail be mujood hai.
Ab mujhe karna ye hai k in 1440 Nos ki same detail file 2 main b add karni hai jo file 1 main hai. shayad inn main se kuch Nos file 1 main na be hon. Lekin bohat kam.
Format 2no ka same hai
Find k method se main 4 gante main sirf 200 Nos check kar paya ho.
Agar koi Asaan aur quick method hai to please share karen.
Aur haan. Nos ki tarteeb be aik jesi nahi hai.

Bohat Shukriya.

[IT.BOY]

وعلیکم السلام
آپ آفس کا کون سا ورژن یوز کر رہے ہیں۔۔۔؟
اگر
2007
یوز کر رہے ہیں تو یہ لنک چیک کریں۔۔۔
How to Highlight or Remove Duplicates in Excel 2007?

[Sajid286]

BHAI DONO FILES MAIN NO UNIQUE HAIN. LEKIN PEHLI FILE AB EXPIRE HO CHUKI HAI AUR USS MAIN SE 1440 Nos KA DATA COPY KARNA HAI AUR NAI FILE MAIN KUCH NEW Nos B HAIN.

[syar]

kya ap apne file share kar sakte hain?

[syar]

or visit these links

http://www.itdunya.com/t139775/
http://www.itdunya.com/t139352/

may this will help u

[M. Adnan Mirza]

Dost sub se pehlay to un dono files ki copy tayar kre, phir 1 file ka tmama data copy kr k dusri file k data bad paste kr dain. or phir insert menu se function command use krain function me text formulas se "repeat" wala formula kisi 1 column pe lagayen . formula apply krne se jo entry double hon gi un k samnay TRUE likha a jaye ga or jo single hon gi un k samnay FALSE a jaye ga ab ap TRUE wali ik aik entry delete kr dain.

Smjhaya ki koshish to ki ha. hope that k aap ko smajh i ho gi. Thanks.

[Sajid286]

Dost sub se pehlay to un dono files ki copy tayar kre, phir 1 file ka tmama data copy kr k dusri file k data bad paste kr dain. or phir insert menu se function command use krain function me text formulas se "repeat" wala formula kisi 1 column pe lagayen . formula apply krne se jo entry double hon gi un k samnay TRUE likha a jaye ga or jo single hon gi un k samnay FALSE a jaye ga ab ap TRUE wali ik aik entry delete kr dain.

Smjhaya ki koshish to ki ha. hope that k aap ko smajh i ho gi. Thanks.

Bhai plz agar ho sake to snap shot se wazahat kar den. main ne kafi koshish ki hai but nahi hua. Sorry bhai file ki information important hai public share nahi kar sakta. aap ko format samjha deta hon.
Franchise ID:Franchise ID:Feeding RSO MSISDN:System Retailer Profile: Name of outlet:Retailer City:Address Of Outlet:Name of the retailer: Other Contact No:Category Of Outlet: CNIC Format 3310012345671 (Optional):ELOAD:SIM:M-W:M-B:SC:VAS:
in sab columns main data hai. 2no files ka format same hai.

[irshadtab]

This is very easy
Open Both files. Copy the data from one table and paste below where u need.
then go to menu DATA and click on Remove Duplicate it will remove duplicated entries.
Note: remove duplicate entries by No. which is unique (Check that and uncheck other fields)

[Sajid286]

OK problem solved. thanx

[*Xpert~Baba*]

OK problem solved. thanx