Extract data from a sheet having names in urdu language.

Farooqui Noor

Board Regular
Joined
Dec 31, 2019
Messages
68
Office Version
  1. 2019
Platform
  1. Windows
1) I was prepared a family tree in urdu language.
2) All data are available in the form of table. and each table is connected with lines.
3) Formate of all tables are same but the family names are different.
4) In each table 7 to 9 coloumns are merged in each table for entering the name of family.
5) In each table 2 coloumns are merged for birth date. 2 for marriage date. 2 coloumn for death date etc. names are written in urdu language.
6) In each table a particular number ( from 01 to 500 ) is used to show and identify husband name and his wife name. it means same number is written in front of husband and his wife name. it is possible that husband and wife name both are present on same sheet or it may be on different sheets.
now
1) I want to count total names appeared on any one sheet and all other 7 sheets.
2) count total numbers as well as duplicate numbers (it may be on the same sheet or may be on different sheets).
3) Also i want to make a separate table on new sheet showing all names in ascending order by using formula with their number. for example 20 number is written infront of a husband in sheet No. 01 and same 20 number is written infront of his wife name which is on sheet No. 03. in this case i want to know the cell number and coloumn number of 20 number cell in sheet No.01 and the same data for sheet No. 03.
New Shijra Start 05-12-2022 (1).xlsx
FCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFUFVFWFXFYFZGAGBGCGDGEGFGGGHGIGJGKGLGMGNGOGPGQGRGSGTGUGVGWGXGYGZHAHBHC
1159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211
2
3شجرہ نسب سادات نمبر 02تراب علیوفاتکامنمبرنامنکاحپیدائش
4شمشاد علی ( زوجہ اولیاء بیگم بنت ۔۔۔۔)شرافت علی عرف چھوٹو میاں ( زوجہ ۔۔۔۔ چوپڑہ)
5دلدار علینظیر علی عرف بٹن علی ( زوجہ ۔۔۔۔۔ پیپل گاوں)
6نجابت علیامداد علی (زوجہ عوض بیگم بنت ناصر علی ابن جعفر علی)322رضا علی ( زوجہ ۔۔۔۔۔)
7298موتی بیگم زوجہ نیاز علی ابن حسین علی
8احمد علی299انور جہاں بیگم زوجہ امجد علی ابن شاہ جی میاں
9
10وفاتکامنمبرنامنکاحپیدائش
11296ولایت علی (زوجہ سکندر بیگم بنت سیدن علی ابن حسین علی ) (پہلے شوہر)
12وفاتکامنمبرنامنکاحپیدائش 297شہزادی بیگم زوجہ حیدر علی ابن ببر علی
13321دل جا بیگم زوجہ یوسف علی ابن امجد علیمحمودی بیگم زوجہ یعقوب علی ابن اکبر علی
14325سرور بیگم زوجہ کرم علی ابن امداد علی
15326نور جہاں بیگم زوجہ اسعد علی ابن امداد علیوفاتکامنمبرنامنکاحپیدائش
16امیر بیگم زوجہ ۔۔۔۔۔۔ اڑاود295مکرم علی ( زوجہ لال بیگم بنت حیدر علی ابن ببر علی )
17
18وفاتکامنمبرنامنکاحپیدائش وفاتکامنمبرنامنکاحپیدائش
19327اولیا بیگم زوجہ شجاعت علی ابن حسین علی مارول294بشارت علی ( زوجہ اول لطفن بیگم بنت نظیر علی عرف بٹن علی )
20323وزیر بیگم زوجہ ببر علی ابن صفدر علیبشارت علی ( زوجہ دوم طریقت بیگم بنت ۔۔۔۔۔ قاضی راویر )
21324امام علی (زوجہ بی بیگم بنت غلام رسول ابن ناصر علی)احمدی بیگم زوجہ ہدایت علی ابن بہادر علی
22325کرم علی ( زوجہ سرور بیگم بنت دلدار علی ابن احمد علی)مُنّا بی زوجہ ۔۔۔۔۔۔ برہانپور
23326اسعد علی ( زوجہ نور جہاں بیگم بنت دلدار علی ابن احمد علی)مقصود علی (مجرد فوت)
S2 M
image 1.PNG
image 1.PNG
image 2.PNG
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top