Madad from Mr. Syar

[sittarah]

Syar sahib main phir se files attatch kr rhi hon ply year columns ko base bna kr data duplicate aur uniqe alag alag kr dain dono files main se.
Agr question ki samajh na aye tou plz phir se pooch kr kr dain.

Thanks.

[syar]

kia aap sirf year/jhar k column ko base bana kar duplicate aur unique alag karna chahte hain ya kisi aur column ko bhe add karna ha.

regards

[sittarah]

Only Year Column

[syar]

But aap k year tu kai dafa repeat hue hain. is tarah tu aap ko wrong answer bhe mile ga.

[syar]

Ok.
Zamg ki file main aik column "A" insert karain aur ye formula a2 main lekhain aur neeche tak copy karain.

=ISNUMBER(MATCH(B2,Euro_Cat_events_Austria.xls!$B$ 2:$B$1053,0))


its not an elegant solution but try it and tell me. Jab tak main dosra hal soochta hon.
Year k elawa aapke files main konsa colmn dosre se mukhtalif ho ga. Aur apna excel k version bhee batain.

regards

[sittarah]

Meray paas 2003 excel version hai. Actually main year ko hi base bna kr hi karna chahti hon kiun jo data year se agay duplicate ho ga woh sara aik jaisa ho ga main nay check kiya hai.Actaully main PhD main probablilstic seismic hazard analysis main work kr rhi hon.And its so nice of you to send me all the formulas which save my much time to work on it manually.
Any ways I have another problen too I want vertical selection from notepad there is some keys i used in pakistan but forgot yet if you know then plz do write it too.

Thanks.

Allah Hafiz.

[syar]

Ok take a look cat file main unique aur duplicte

[syar]

zamg file main unique aur duplicate.

allah hafiz

[sittarah]

which technique you use to sort it out because i have lots of files to work on it

[sittarah]

aur vertical selection ki short key bhi agr pta ho tou bta dain main net se search kr rhi hon mil nhi rahi

[sittarah]

notepad file attatch kr rhi hon

[sittarah]

attatched