MS Excel ( Help Line )

Discussion in 'Microsoft Excel' started by madnankn, Oct 29, 2005.

  1. Mian_jani

    Mian_jani Member

    Apni Excel ki file attach kar k mujhay is email pe send karain.
    naseer138pk@hotmail.com main kosish karata hm open karnay ki.
     
  2. deziner

    deziner New Member

    Yaar Yahan Se BAQI Lesson Kahan Gaye Yeah 1st number kion nahi start hota...
     
  3. shafiq

    shafiq New Member

    Pehla Lesson Kahan Hai ????????? MS EXCEL kA? kAHAAN SE START kAROON?

    I think kafi arsay Baad Mein phir poch raha Hoon aik dfa Pehlay b pocha Tha Par koi jawab Masool Nahi Huwa?
    Mein MS Excel Basic se strat karna chahta Hoon par mujay is ka pehla lesson He nahi mila? 1,2,3,4,5,6,7,8,9,10 K Lessons Ki zaroorat Hai
     
  4. smarteyes

    smarteyes New Member

    help

    salam o allikum

    bhai main yeh poochna chahta hon ke sheet no1 main jo cell hai us ka total sheet number sheet no 3 main kaisay aa sakta hai?
     
  5. ib94a

    ib94a WDC Student

    sheet 3 k cell main equal sign = typ karain
    phir sheet 1 per jain jehan total hay or enter do ba dain
    aap total sheet 3 per ajai ga
    ise ko sheet link karna kehtay hain
    na samaj aya ho to do barah posh laina

    ib94a
     
  6. adnanswabi

    adnanswabi New Member

    Excel Formula condition


    Every one use count & countif formula, bt send me count or countif formula that solve my problem & find wthin range figure as shown below:

    1, 2, 2, 3, 4, 5, 5, 6, 4, 6, 7, 8, 7, 9, 9

    Between 2 & 8 how may figure comes. Answer is 9 bt prove this on excel formula.
    I only find one figure on count & countif formula.

    contact me on my cell #: +92 300 9088553

    Thanks & Regards,
    Adnan
     
  7. chand4u

    chand4u New Member

    Aslam O Alaikum sir,
    Umeed hai k app theek hoon gaye, Sir app ne Word or Excel pe bahoot acha kam kia hai,main ne app ki is site se bahoot khuch sekha hai, iss k liye main aap ka bahoot mashkoor hoon, Allah Tallah App ko iss ki Jazah de (Aamin).Sir meri Aik problem hai, app yaqinan door kar dein gaye, Sir Excel main agar Aik date main se dosari date ko minus karna ho(03-01-2008 - 04-04-2008 = ans ) ans bhi date ki shakal mein ana chahiye,Issi tarha time mein se time ko minus karna hoo or jawab time mein hi aye (08:05-16:05=08:00 ans)..Sir mujh umeed hai k app meri madad karein gaye,,

    App ka ye silsila bahoot acha hai, Allah Tallah app ko app k maqsad mein kayab karey or Allah app ko har Nemat se nawazey (Aamin)

    Main urdupages ki tamam team ko iss site ki kamyabi ki mubarak bad deta hoon.

    Allah Hafiz

    Asif Najmee
    chand4u@urdupages.com
    najmee4u@yahoo.com
     
  8. Adil_amer

    Adil_amer New Member

    salam
    mujhay 2,453/- say (Two thousand four hundred fifty three only) convert kernay ka tariqa batain
     
  9. Zia Iqbal

    Zia Iqbal New Member

    AOA,
    main chahta hon k agr main ksi cell main koi word repeat karon to us cell ka colour change ho jaey ta k muje maloom ho sake k main already yeah word likh chuka hon. kia aisa mumkin hai?
     
  10. hannan hacker

    hannan hacker New Member

    need Complete Excel learning

    asalam o alikum ..
    bhai ager kissi k pass complete excel notes ya koi documents mojod hain to plz link day do
    bohat maherbani ho gi...
     
  11. CalltoRahat

    CalltoRahat New Member

  12. schzad

    schzad New Member

    Nice work....Admin aur tamam team ko ka shukria keh unho ne es trah ka silsala start kia....!!!
     
  13. zafarkazmi

    zafarkazmi New Member

  14. umarsindhi

    umarsindhi WDC Student

    Classess links missing

    Salam Alim Kum
    Hello brother
    Excel main 32 k bad links ki adam dastyabi k bais mujhay chnd dushwarion ka samna hay umeed hay k ap madadgar sabit honga
    1-Numbers ko text main covert kernay ka formula
    as : 586 = Five hundred eighty six
    2- Is k ilawa main excel main database banana chahta hon aur lagay haton y bhi bata dain k
    3- dropdown list kis tara create ki jati hay aur kis tara function ker ti hay kion k mainay create to kerli lakin result desired nahi mila ,might there b some mistake frm my side
    Khuda hafiz
    Umar Siddiqui
    Umar_wajdan@yahoo.com
     
  15. naeemtai4u

    naeemtai4u Member

    meray khayal main ADOBE ACROBT READER main yeh copy kar ka english option rakh kar try karo shayad masla hal ho jaye yad rakhna adobe ka acrobt reader hi hona chahiyeh sirf adobe reader say kam nahi chalay ga..thanks
     
  16. fahym007

    fahym007 New Member

    SALAM GUYS.!

    MR. rajput123 BHAI AAP KI FILE CORRUPT HO CHUKI HA. AB APP KI JO INFORMATION HAI. NAHI AA SAKTI. NORMALLY YE US WAKT HOTA HAI JAB FILE HANG HOGAI HO YA PHIR LIGHT CHALI GAY HO. MERE SAATH YE PROBLEM KHUD MAIL MERGE MEIN AATI REHTI HAI. SO BHETER YEHI HOGA KE AAP DOBARA SE APNI INFORMATION BANA LEIN.

    SHUKRIYA
     
  17. madnankn

    madnankn New Member


    (for MS OFFICE 2003)

    Answer of Question 1:

    1. MS Excel Open Karen ALT + F11 Press Karen.
    2. INSERT Menu Sy MODULE Par Click Karn.
    3. Neechy Mojood Code Box Main Paste Karen:

    Option Explicit
    'Main Function
    Function SpellNumber(ByVal MyNumber)
    Dim Dollars, Cents, Temp
    Dim DecimalPlace, Count
    ReDim Place(9) As String
    Place(2) = " Thousand "
    Place(3) = " Million "
    Place(4) = " Billion "
    Place(5) = " Trillion "
    ' String representation of amount.
    MyNumber = Trim(Str(MyNumber))
    ' Position of decimal place 0 if none.
    DecimalPlace = InStr(MyNumber, ".")
    ' Convert cents and set MyNumber to dollar amount.
    If DecimalPlace > 0 Then
    Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _
    "00", 2))
    MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
    End If
    Count = 1
    Do While MyNumber <> ""
    Temp = GetHundreds(Right(MyNumber, 3))
    If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars
    If Len(MyNumber) > 3 Then
    MyNumber = Left(MyNumber, Len(MyNumber) - 3)
    Else
    MyNumber = ""
    End If
    Count = Count + 1
    Loop

    SpellNumber = Dollars & Cents
    End Function

    ' Converts a number from 100-999 into text
    Function GetHundreds(ByVal MyNumber)
    Dim Result As String
    If Val(MyNumber) = 0 Then Exit Function
    MyNumber = Right("000" & MyNumber, 3)
    ' Convert the hundreds place.
    If Mid(MyNumber, 1, 1) <> "0" Then
    Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
    End If
    ' Convert the tens and ones place.
    If Mid(MyNumber, 2, 1) <> "0" Then
    Result = Result & GetTens(Mid(MyNumber, 2))
    Else
    Result = Result & GetDigit(Mid(MyNumber, 3))
    End If
    GetHundreds = Result
    End Function

    ' Converts a number from 10 to 99 into text.
    Function GetTens(TensText)
    Dim Result As String
    Result = "" ' Null out the temporary function value.
    If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19...
    Select Case Val(TensText)
    Case 10: Result = "Ten"
    Case 11: Result = "Eleven"
    Case 12: Result = "Twelve"
    Case 13: Result = "Thirteen"
    Case 14: Result = "Fourteen"
    Case 15: Result = "Fifteen"
    Case 16: Result = "Sixteen"
    Case 17: Result = "Seventeen"
    Case 18: Result = "Eighteen"
    Case 19: Result = "Nineteen"
    Case Else
    End Select
    Else ' If value between 20-99...
    Select Case Val(Left(TensText, 1))
    Case 2: Result = "Twenty "
    Case 3: Result = "Thirty "
    Case 4: Result = "Forty "
    Case 5: Result = "Fifty "
    Case 6: Result = "Sixty "
    Case 7: Result = "Seventy "
    Case 8: Result = "Eighty "
    Case 9: Result = "Ninety "
    Case Else
    End Select
    Result = Result & GetDigit _
    (Right(TensText, 1)) ' Retrieve ones place.
    End If
    GetTens = Result
    End Function

    ' Converts a number from 1 to 9 into text.
    Function GetDigit(Digit)
    Select Case Val(Digit)
    Case 1: GetDigit = "One"
    Case 2: GetDigit = "Two"
    Case 3: GetDigit = "Three"
    Case 4: GetDigit = "Four"
    Case 5: GetDigit = "Five"
    Case 6: GetDigit = "Six"
    Case 7: GetDigit = "Seven"
    Case 8: GetDigit = "Eight"
    Case 9: GetDigit = "Nine"
    Case Else: GetDigit = ""
    End Select
    End Function

    4. INSERT Ky Menu Par Click Karen FUNCTION... Par Click Karen.
    5. Or select a category Main USER DEFINED Par Click Karen.
    6. Select a function Main SPELLNUMBER Ko Select Karen.
    7. OK Karen Aur Apna Matlooba Number Likhen.
     
  18. syar

    syar New Member

    I asssume that your data in Column A from A1 to A15 try this

    =SUMPRODUCT(--(A1:A15<8),--(A1:A15>2))

    if this is not you need then try to change operator accordingly.
     
  19. syar

    syar New Member



    Agar aap time ko minus karna chahte haintu ye cell formating se bhee ho sakta han. Leekan Asan hal Ye Ha K AAp

    Tool--->Option----->calculation k tab per jain aur
    "Use 1904/1900 date system " ko enable kar dain. Aap k masla hal ho jae ga.
     
  20. syar

    syar New Member

    I assume your data (37) in A1. In B1 try this

    =SUM((LEN(A1)-LEN(SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9},"")))*{1,2,3,4,5,6,7,8,9})
     

Share This Page