Shared Hub

Thursday 18 December 2014

How to Combine Data in 2 Table of different Worksheets?

How to Combine Data in 2 Table of different Worksheets?

Sample raw data in worksheet Sheet2:
Excel 2007

	A	B
1	Identity	Score
2	2	6
3	3	7
4	5	8
5	7	5
6	9	7
7	11	4
8	12	56
9	15	16
10	16	12
11	18	11
12	20	10
13	22	9
14	23	6
15	26	8
16	30	12
17	31	11
18	33	21
19	35	24
20	41	23
21	43	15
22	45	12
23

Sheet2

And, in worksheet Sheet1:
Excel 2007

	A	B	C
1	Identity	Name	Score
2	1	Mr. Name 1
3	2	Mr. Name 2	6
4	3	Mr. Name 3	7
5	4	Mr. Name 4
6	5	Mr. Name 5	8
7	6	Mr. Name 6
8	7	Mr. Name 7	5
9	8	Mr. Name 8
10	9	Mr. Name 9	7
11	10	Mr. Name 10
12	11	Mr. Name 11	4
13	12	Mr. Name 12	56
14	13	Mr. Name 13
15	14	Mr. Name 14
16	15	Mr. Name 15	16
17	16	Mr. Name 16	12
18	17	Mr. Name 17
19	18	Mr. Name 18	11
20	19	Mr. Name 19
21	20	Mr. Name 20	10

Sheet1

Worksheet Formulas

Cell	Formula
C2	=IF(ISERROR(VLOOKUP(A2,Sheet2!A:B,2,)),"",VLOOKUP(A2,Sheet2!A:B,2,))

Tuesday 13 May 2014

Arabic Song, I Love You Mama

Mediafire Download Link

Lyrics (English Translation)

The girl: I L O E V E Y O U M A M A, I love you Mama.
The mother: My lovely daughter
The girl: Me
The mother: Beautiful and delightful
The girl: Me
The mother: My lovely daughter
The girl: Me
The mother: Beautiful and delightful
The girl: Me
The mother: When I want her to go to bed, She holds my hands
The girl: Me
The mother: And ask for a gift.
The girl: Mama
The mother: Please baby go to sleep. May Allah guide you. Baby go to sleep now.
The girl: I don't wanna
The mother: Please baby go to sleep. May Allah guide you. Baby go to sleep now.
The girl: I don't wanna.
Come and sleep by my side, If you really want me to sleep.
The mother: I don't wanna
The girl: Come and sleep by my side, If you really want me to sleep.
I don't wanna, I don't wanna.
I'm not supposed to sleep. I'm so scared to sleep alone.
The mother: What are you scared of, baby?
The girl: I don't wanna I don't wanna.
I'm not supposed to sleep.
I'm so scared to sleep alone.

The girl: I love you Mama.
The mother: I love you too.

The mother: I embrace her with my soul.
The girl: Me
The mother: May Allah keep her for her mother.
The girl: Me
The mother: O world, she is so sweet like honey
No one else like her
The girl: Mama
The mother: I could just eat her up.
The girl: Mama
The mother: Please baby go to sleep. May Allah guide you. Baby go to sleep now.
The girl: I don't wanna
The mother: Please baby go to sleep. May Allah guide you. Baby go to sleep now.
The girl: I don't wanna.

The girl: No. I am going to sing you a song and I want you to listen
The mother: OK, go.
The girl: O v me Janao ya mal, say bravo!
The mother: Bravo!
The girl: Off, off, off, hurray.
I don't wanna, I don't wanna.
I'm not supposed to sleep. I'm so scared to sleep alone.
The mother: Let's sleep, baby

The girl: Mama
my dear, you can go to sleep in your own bed now.

Saturday 12 April 2014

File Shareing and Hosting Sites

File Shareing and Hosting Sites

1. uppit

i personally like this site very much, because user can download files after waiting of 5 seconds only. uppit supports 500mb max size of files.

2. sharebeast

one of leading website for sharing files with each other. you can embed and stream media files through sharebeast. it supports 200 mb max file size for free user. you can download files with unlimited speed. it also suppoprt remote url upload.

3. mediafire

mediafire is one of top 100 websites. it supports resuming of uploading and downloading of files. it’s free account starts from 10 gb of free space and you can get upto 50gb.

4. putlocker

put locker is very popular file sharing site. you can upload files of up to 1GB. and there is no limit of uploading and downloading of files. it supports sharing of video files and embeding.

5. epicshare

supports uploading of up to 1024mb of file. you can also upload files through remote url and torrent leech.

6. hugefiles

yuo can upload files up to 3000 mb and 50 files at a time. also supports file uploading files through ftp and remote url upload.

7. arabloads

upload up to 1000mb of file and 5 files at a time with arabloads. arabloads also supports remote url upload and torrent leech.

8. 180upload

you can upload up to 2048mb of file and 10 files at a time. also supports uploading of files through remore url.

9. megafiles

upload upto 2048mb of file and 12 files at a time. it supports file uploading through remote url upload and torrent leech.

FILE SHARING SITES THAT SUPPORT FREE TORRENT LEECHING

EPICSHARE.NET

QUEENSHARE.COM

MEGAFILES.SE

XL.GS

CRAMIT.IN

MIGHTYUPLOAD.COM

Monday 24 March 2014

Formula Left and Right

Formula Left and Right

	A	B	C
2	Ameen Akbar	Ameen	Akbar

Spreadsheet Formulas

Cell	Formula
B2	=LEFT(A2,FIND(" ",A2)-1)
C2	=RIGHT(A2,LEN(A2)-FIND(" ",A2))

another formula
B2: =LEFT(A2,FIND(" ",A2,1)-1) and this one in C2: =RIGHT(A2,LEN(A2)-FIND(" ",A2,1)).

Saturday 22 March 2014

Mitti Da Bawa

بول مٹی دیا باویا

او بول مٹی دیا ، او بول مٹی دیا باویا ،

تیرے دکھاں نے مار مکا لیا ، میرا سوہنا ماہی

او مٹی دا میں باوا بنایا ، اُتے چا دتی اے کھیسی

وطناں والے مان کرن ، کی میں مان کراں میں پردیسی

میرا سوہنا ماہی ، آ جا ہو ہوووووووو ۔۔۔۔ اوئے

ہو بوہے اگے لاواں بیریاں ، گلاں گھر گھر ہوون تیریاں تے میریاں

مینوں شکل دکھا جا ، آ جا ہو ووووو ۔۔۔۔ اوئے

ہو گل وچ میرے ڈھولنا ، سانوں معاف کریں مندا بولنا

مینوں شکل وکھا جا ، آجا ہو وووو۔۔۔۔۔ اوئے

او بول مٹی دیا ۔۔۔۔۔

او بول مٹی دیا ، باویا او کیوں نئیں بولدا ؟ برا کیوں نئیں بولدا ؟

ہائے دلاں دی گھنڈی نوں ، ویریا نئیں کھولدا ؟

او بول مٹی دیا ۔۔

جد میت نظریں آوندی ، چھیتی کرن اُپا ، پانی صابن پیل کے ، انہوں دتے خوب نہوا ،

اودے قد وچ الفی ڈال دے ، کلمہ طیب لکھا ، او گھروں پریرے ، قبروں ریرے تن سو سٹھ جواب

تے کیوں نئیں بولدا ، برا کیوں نئیں بولدا ، دلاں دی گھنڈی نوں ، ویریا نئیں کھولدا

او بول مٹی دیا ۔۔۔

او ماں دھی نوں متاں دیندی ، توں مایا وچ موئی نی

تینو لج کسے دی ناہیں ، توں کی لیں گی لوئی نی

صاحب دا دروازہ نیواں ، توں پگڑی اوچیائی نی

شام سویرے غافل کڑیے ، سُتیاں رین وہائی نی

کی ہویا ؟ کی ہویا تینوں؟ ، چرخے تند نئیں پائی نی

بن بیٹھی پنج پھولاں رانی ، گھر وچ حکم چلایا نی ،

نو دروازے محل تیرے دے ، اُچا بہت بنایا نی

کس کولوں تو کوٹھا لیتا ؟، کاغذ نئیں کروایا نی ،

خبر نئیں اوتھے دھکا ملنا ، لخیا نئیں کرایا نئیں ، ندی کنارے ڈھا ہمیشہ کندھ ریت دی پئی نی

شام سویرے غافل کڑیے ، سُتیاں رین وہائی نی

تے کیوں نئیں بولدا برا کیوں نئیں بولدا ، ہائے دلاں دی گھنڈی نوں ویریا نئیں کھولدا

او بول مٹی دیا ۔۔۔۔

Songs By:

Karmaasa

Lyrics

Bol mitti deya baweya
Oh tere dukhan ne maar mukka leya
Oh mera sohna maahi
Aa jayin oh… x2

Mitti da main bawa banaya
Utte chaa ditti aa khesi
Watna wale maan karan
Kih main maan karan pardesi
Aa jayin oh…

O Bol mitti deya baweya
O tere dukhan ne maar mukka leya
O mera sohna maahi
Aa jayin oh…

Buhe agge lavan berian
Gallan ghar ghar hown terian merian
Menu shakal vikha jaa
Aa jayin oh…

O Bol mitti deya baweya
O tere dukhan ne maar mukka leya
O mera sohna maahi
Aa jayin oh…

Gall vich mere dholna
Sanu maaf kareen manda bolna
Menu shakal vikha jaa
Aa jayin oh…

O Bol mitti deya baweya
O tere dukhan ne maar mukka leya
O mera sohna maahi
Aa jayin oh…

Oye bol mitti deya baweya
Kyon nahi bolda, haara, kyon nai bolda
Dilan di kundi nu veriya nahi kholda
Oye bol mitti deya, bol mitti deya, bol mitti deya

Jad payi ae badli aaundi
Tarr chheti kar lo bhaa
Pani saban beth ke ohnu dende khoob naha
Kalma lain parha
Muh hanere tin-say-sath jawab
Kyon nai bolda, haara ve kyon nai bolda
Dilan di kundi nu veriya kyon nahi kholda

Maan dhee nu mattan dendi
Tu maya vich moyi nee
Tenu lajj kise di naahi
Sirr toh leh gayi loyi nee
Share bata daryala neevan
Tu kamli othe aayi nee
Sham savere ghafal kudiye
Sutteyan rehn gawani nee
Kih hota kih hoya tenu
Charkhe tand na paayi nee
Ban bethi ban-phullan rani
Ghar vich hukam chalaya nee
Noh daware mehal tere de
Ucha bohat banaya nee
Jis kolon toh kotha litta
Kagaj nahi banwaya nee
Nadi kinare ja hamesha
Tand rait de paayi nee
Shaam savere gafal kudiye
Sutteyan rehn gawayi

Kyon nahi bolda, haara kyon nahi bolda
Dilan di kundi nu veriya nahi kholda
Bol mitti deya, bol mitti deya, bol mitti deya.

Alam Lohar

Lyrics

Ho Bol mitti diaa baaviaah , Tere dukhaan ne maar muka liaa
Mera sohna maahi , Aaaja ho

Ho mitti di main baava banayia, Utte taan ditti aa khesi
Vatana vaale maan karan, Ki main maan karaan pardesi
Mera sohna maahi ,Aaaja ho

Ho boohe agge laanva berriaan,
Gallan ghar ghar hovan teriaan te meriaan
Mainu shakal dikhaaja ,Aaja ho

Ho gam vich tere Dholana, Sanu maaf karin manda bolana
Mainu shakal dikhaaja ,Aaja ho

Ho Bol Mitti diaa baavia, Ho Bol Mitti diaa baavia
Kion ni bolda, Poora Kion ni bolda,
Dillan dee ghundi nu, vairiaa nahin kholda

Jadh maaeeat nazrin aanvdi,
Cheti karan upaa
Paani sambhan baith ke,
Toon ditte khoob lava..
………
Maan Dhee Nu Mattan dendi
Toon maaya vich mohi nee
Tainu lajj kise di naahin,
Moonh di laigee loee ni..

Sahib da darvaza neenvaan
Toon pagri uthiaaee ni
Shaam savere raafal kuriye
Sutiaan rehan viiahe nee

Kee hoya,kee Hoya Tainu
Charkhe tand naa paee ni
Ban baithe panj foolaan rani
Ghar vich hukam chalaya ni
9 darvaje mehel tere te
Ucha bahut banaaya nee
Jis kolo toon kotha leeta
Kaaraj na larvaiya nee
Nadhi kinaare dhaab ret dee
Kandh ret dee paaee ne.
Shaam savere raafal kuriye
Sutiaan rehan biiahee nee

Alam Lohar

(2nd Version Slow Track)