Pakistani Urdu Forum for Free IT Education, ITDunya.com  


Home UrduPad EMail FAQ ITD Mobile
Go Back   Pakistani Urdu Forum for Free IT Education, ITDunya.com > IT ki Dunya > Ask an Expert > Solved Problems (IT)
Forgot Password? Join Us!

Solved Problems (IT) All Solved Problems should move here.....

Excel Sheet Formula
Closed Thread
 
LinkBack Thread Tools Display Modes
  #1  
Old 25th May 2012, 08:47 PM
Member
 
Last Online: 17th January 2014 09:22 PM
Join Date: 13 Aug 2009
Location: Faisalabad
Gender: Female
Posts: 94
Started threads: 18 Started threads
Thanks: 3
Thanked 4 Times in 4 Posts
Thread Starter
Default Excel Sheet Formula



Mujhey Ye Pochhna Hai.
Ager Excel Ki 1 File Mein 2 Sheets Hoon.
Aur 1st Sheet mein Rozana Ke Kaam ki Sumary Hai.
Aur 2nd Sheet Mein Date wise Monthly Sumary Hai.

1st sheet ka DATA 2nd Sheet Mein Jis Date Ko Add
Kiya Jay 2nd Sheet Mein Bi Usi Date Ko Wohi DATA Aa Jay.
Aur Jis Tarha Date Change Ho.Usi Tarha 2nd Sheet Mein Bi Usi Date Pr
DATA Apne Aap Aa Jay..

Exampal
1 Sheet Mein Rozana DATA Add Kiya Jata Hai.
Aur 2nd Mein Porey Month Ki Date (1..30) Hai ...
1st Date Ko Data 1st Sheet Mein Add Kiya.
Wohi Data 2nd Sheet Mein 1st Date Pr Aa Jay.
Aur Jab Month Ki 2nd DAte Ho.2nd Date Ka Data Month
Ki 2nd Date Pr Aa Jay.
Sheets Sirf 2 Hi Hain.

Koi Aisa Farmula Bta Dain Jo Date Se Conected Ho..
Attached Files
File Type: xls Data.xls (17.5 KB, 262 views)
  #2  
Old 25th May 2012, 09:48 PM
*Noor-ul-Ain*'s Avatar
Advance Member
 
Last Online: 17th March 2013 01:55 PM
Join Date: 22 Apr 2012
Location: Pakistan
Age: 16
Gender: Female
Posts: 3,134
Started threads: 76 Started threads
Thanks: 102
Thanked 322 Times in 192 Posts
Default

آپ کی شیٹ پہ کام کر رہی ہوں
دعا کیجئے گا کہ کامیاب ہوں جاؤں
ویسے ایک بات سمجھ نہیں آئی کہ یا تو آپ کو ڈیلی کام کے لیے ہر ایک دن کی الگ شیٹ بنانی ہو گی
یا ایک ہی شیٹ کافی لمبی ہو جائے گی
  #3  
Old 25th May 2012, 10:08 PM
Advance Member
 
Last Online: 22nd November 2014 09:17 AM
Join Date: 31 Jul 2009
Location: Nowshera(KP)
Age: 37
Gender: Male
Posts: 799
Started threads: 9 Started threads
Thanks: 2
Thanked 330 Times in 285 Posts
Default

Quote:
Shireen Shari said: View Post


Mujhey Ye Pochhna Hai.
Ager Excel Ki 1 File Mein 2 Sheets Hoon.
Aur 1st Sheet mein Rozana Ke Kaam ki Sumary Hai.
Aur 2nd Sheet Mein Date wise Monthly Sumary Hai.

1st sheet ka DATA 2nd Sheet Mein Jis Date Ko Add
Kiya Jay 2nd Sheet Mein Bi Usi Date Ko Wohi DATA Aa Jay.
Aur Jis Tarha Date Change Ho.Usi Tarha 2nd Sheet Mein Bi Usi Date Pr
DATA Apne Aap Aa Jay..

Exampal
1 Sheet Mein Rozana DATA Add Kiya Jata Hai.
Aur 2nd Mein Porey Month Ki Date (1..30) Hai ...
1st Date Ko Data 1st Sheet Mein Add Kiya.
Wohi Data 2nd Sheet Mein 1st Date Pr Aa Jay.
Aur Jab Month Ki 2nd DAte Ho.2nd Date Ka Data Month
Ki 2nd Date Pr Aa Jay.
Sheets Sirf 2 Hi Hain.

Koi Aisa Farmula Bta Dain Jo Date Se Conected Ho..
salam::

1. agar aap date wise alag alag sheets banate hain tu phir tu asan ha aap sirf sumif/sumproduct/ ya even vlookup bhe baz cases m use kar sakte hain.lekan agar aap ya chahte hain k aap har dafa aik he sheet m entry karain jese k ap ki sheet 1 ha tu mere khyal m namumkin tu nahee lekan bohat mushkil hoga. jis par ak member already kam kar rahe hain.
2. aap merge cell use kar rahe hain in ko khatam karain warna aap k leye masla ho ga.
3. aap apna data entry ka layout final kar k share kare k date wise alag sheet ho gi k aik he sheet m entry karin gi. ya aik sheet m aap mazeed sample data enter karian k samajhne m asani ho.

regards,
  #4  
Old 25th May 2012, 10:31 PM
Member
 
Last Online: 17th January 2014 09:22 PM
Join Date: 13 Aug 2009
Location: Faisalabad
Gender: Female
Posts: 94
Started threads: 18 Started threads
Thanks: 3
Thanked 4 Times in 4 Posts
Thread Starter
Default

Mein Ne Kochh Data Sheet Mein Example Ke Liye Bi Add Kiya Hai..
Shaid Aap Ko Dakh Kr Samjhne Mein Aasani Ho Gi.
Yani 1st Sheet Ki Date Change ho Tu Uss Date Ke Hisab Se Data Bi
Usi Date Pr 2nd Sheet Mein Aa Jay.
  #5  
Old 25th May 2012, 10:46 PM
Advance Member
 
Last Online: 22nd November 2014 09:17 AM
Join Date: 31 Jul 2009
Location: Nowshera(KP)
Age: 37
Gender: Male
Posts: 799
Started threads: 9 Started threads
Thanks: 2
Thanked 330 Times in 285 Posts
Default

Quote:
Shireen Shari said: View Post
Mein Ne Kochh Data Sheet Mein Example Ke Liye Bi Add Kiya Hai..
Shaid Aap Ko Dakh Kr Samjhne Mein Aasani Ho Gi.
Yani 1st Sheet Ki Date Change ho Tu Uss Date Ke Hisab Se Data Bi
Usi Date Pr 2nd Sheet Mein Aa Jay.
agar m jahan tak aap ki bat samjha hon.

sheet1 m aap ki date b2 m ha aur data row 4 m ha.
agar aap sheet1 m date change karian yani b2 m change karain tu row 4 ka data 2nd sheet m new date k samne add ho jae?

am i right
  #6  
Old 25th May 2012, 10:52 PM
*Noor-ul-Ain*'s Avatar
Advance Member
 
Last Online: 17th March 2013 01:55 PM
Join Date: 22 Apr 2012
Location: Pakistan
Age: 16
Gender: Female
Posts: 3,134
Started threads: 76 Started threads
Thanks: 102
Thanked 322 Times in 192 Posts
Default

Check This
Attached Files
File Type: xls Data.xls (37.5 KB, 158 views)
  #7  
Old 25th May 2012, 11:00 PM
Advance Member
 
Last Online: 22nd November 2014 09:17 AM
Join Date: 31 Jul 2009
Location: Nowshera(KP)
Age: 37
Gender: Male
Posts: 799
Started threads: 9 Started threads
Thanks: 2
Thanked 330 Times in 285 Posts
Default

salam Aini::


Good effort, Nice
i have question if u don't mind. ham log aik dosre he sa sekhte hain. m bhe aap sa kuch sekhon ga aur kuch aap mujh sa.

File ki sheet 1 m aap na sare entries manual ki hain,
Sheet 2 m sare entries manual hain. koi bhe formula date ko chek nahee kar raha. agar m koi bhe date sheet2 m change karon tu baqi data wese he rahe ga koi farq nahee pare ga.
jo aap ki sheet m kame ha is par thoda mazeed kam karne k zaroorat ha. hope aap bura nahee mane ge. try to use formulas instead linking cells with "="
  #8  
Old 25th May 2012, 11:03 PM
Member
 
Last Online: 17th January 2014 09:22 PM
Join Date: 13 Aug 2009
Location: Faisalabad
Gender: Female
Posts: 94
Started threads: 18 Started threads
Thanks: 3
Thanked 4 Times in 4 Posts
Thread Starter
Default

Yes Bhai U are right..
  #9  
Old 25th May 2012, 11:16 PM
Advance Member
 
Last Online: 22nd November 2014 09:17 AM
Join Date: 31 Jul 2009
Location: Nowshera(KP)
Age: 37
Gender: Male
Posts: 799
Started threads: 9 Started threads
Thanks: 2
Thanked 330 Times in 285 Posts
Default

Quote:
Shireen Shari said: View Post
Yes Bhai U are right..
agar mere bat drust ha tu phir ap jesa chahte hain k sheet1 m entry karte rahin aur data sheet2 m change hota rahe tu asa mumkin nahee. Aap ko phir MACRO use karne pade gi Jis ka m aap ko mashwara nahee donga. Q k aap abhe excel seekh rahe hain tu aap k leye MACRO handle karna masla ho ga. Aur na he aap seekh sakain g.

Aap khod soche jab aap sheet1 k b2 m date enter karain g tu sheet2 m date ko he base bana kar changes hon gi. lekan jab aap B2 ki date change kar dain gi tu sheet2 m bhe new date k age entry ho gi aur purani date ka data lost ho jae ga.

Aap har date k leye ak alag sheet bana lain jesa Aini na kaha ha aap ko. Ya aap apna data layout change karian.
The Following User Says Thank You to syar For This Useful Post:
sayhellotoit (26th May 2012)
  #10  
Old 25th May 2012, 11:21 PM
Advance Member
 
Last Online: 22nd November 2014 09:17 AM
Join Date: 31 Jul 2009
Location: Nowshera(KP)
Age: 37
Gender: Male
Posts: 799
Started threads: 9 Started threads
Thanks: 2
Thanked 330 Times in 285 Posts
Default

may be check this thread. its will help u
Need Count formula help in Excel (advance thanks)
  #11  
Old 25th May 2012, 11:24 PM
*Noor-ul-Ain*'s Avatar
Advance Member
 
Last Online: 17th March 2013 01:55 PM
Join Date: 22 Apr 2012
Location: Pakistan
Age: 16
Gender: Female
Posts: 3,134
Started threads: 76 Started threads
Thanks: 102
Thanked 322 Times in 192 Posts
Default

Quote:
syar said: View Post
salam Aini::


Good effort, Nice
i have question if u don't mind. ham log aik dosre he sa sekhte hain. m bhe aap sa kuch sekhon ga aur kuch aap mujh sa.

File ki sheet 1 m aap na sare entries manual ki hain,
Sheet 2 m sare entries manual hain. koi bhe formula date ko chek nahee kar raha. agar m koi bhe date sheet2 m change karon tu baqi data wese he rahe ga koi farq nahee pare ga.
jo aap ki sheet m kame ha is par thoda mazeed kam karne k zaroorat ha. hope aap bura nahee mane ge. try to use formulas instead linking cells with "="
I am agree. Ap formula kon sa laga skty hein es condition mein?? I think linking he option hy. Han hum sheet 2 mein sheet ko lock kar dein tu kaisa idea hy???
  #12  
Old 25th May 2012, 11:29 PM
Advance Member
 
Last Online: 22nd November 2014 09:17 AM
Join Date: 31 Jul 2009
Location: Nowshera(KP)
Age: 37
Gender: Male
Posts: 799
Started threads: 9 Started threads
Thanks: 2
Thanked 330 Times in 285 Posts
Default

Quote:
IamAini said: View Post


I am agree. Ap formula kon sa laga skty hein es condition mein?? I think linking he option hy. Han hum sheet 2 mein sheet ko lock kar dein tu kaisa idea hy???
asal m mujhy layout ka pata nahee k ya kis tarah entry karain gi. aur m index/match, ya sumproduct, sumif use karta.
Closed Thread

Bookmarks

(View-All Members who have read this thread in the last 15 days : 0
There are no names to display.
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want excel formula for this .... problem Nadeem Ahmed Kh Ask an Expert 5 23rd July 2012 03:25 PM
sheet 1 ka dusri sheet py formula farooq_18 Ask an Expert 12 11th June 2011 02:13 PM
How can find where is the excel sheet is link with error sheet(there source is lost)? bigbose Ask an Expert 1 27th January 2010 10:03 PM
Bank Balance Sheet (Excel Prob) Adeawan Ask an Expert 13 16th March 2009 12:49 PM
excel formula ?? adnanbahrian Ask an Expert 5 22nd February 2009 11:06 AM


All times are GMT +5. The time now is 06:19 PM.


Powered by vBulletin® Version 3.8.7
Copyright 2005 - 2014, ITDunya All rights reserved, No Portion May be Reproduced Without Written Permission from ITD Management.

Search Engine Optimization by vBSEO ©2011, Crawlability, Inc.