xls help a formula

**balalnasir** · 3rd March 2012, 06:59 PM

Dear farz karen k yen lgoon k jo name hein me ne in ko koi khat likhne hay aor wo taqseem 2 aadmiun ne karne hein. 1 ka name anwar hay 2 ka name aslam hay.me chahta hoon k Bahawalnagar k khat anwar taqseem kre aor Chishtian wale Aslam Taqseem kre.
ab apne record k lie chishtian k samne Aslam ka name aae aor bahawalnagar k same anwar ka name likha jae. yanii bar baar in k name na likhne paden sirf aek kulia ho jo apply kroo to jahan jah un k city hoon un k samne un ka name aa jae. advance shukria

**balalnasir** · 4th March 2012, 02:25 PM

kia yahan xls ka koi bhi mahir nahi hay.

**Anxious Soul** · 4th March 2012, 03:06 PM

Bhai ap ny worng section mai question kia hai is liye ap ko abhi tak koi answer nahi mila.. khuch bhi pochna ho to "Ask an Expert" waly section mai thread banaya karen..

Jahan tak mujhy ap ki baat ki samjh aye hai.. is ky liye ap simple filter ki command use kar sakty hain..

**syar** · 4th March 2012, 06:17 PM

Wese tu is k kai solution hain laikan aik asan hal ye ha k aap apna aik alag table bana lain. Jis m ap city ka age representative ka name lekh dain. aur phir aap ki jo cities hain wahan par formula laga dian.

See the attached sheet.