Page 1 of 2 12 LastLast
Results 1 to 12 of 13

Thread: Excel Alphabet list help plz

  1. #1
    My Heaven's Avatar
    My Heaven is offline Advance Member
    Last Online
    22nd July 2021 @ 12:31 PM
    Join Date
    26 Nov 2010
    Location
    Kashmore
    Gender
    Male
    Posts
    2,805
    Threads
    306
    Credits
    7,621
    Thanked
    137

    Default Excel Alphabet list help plz

    Salam sab dosto ko
    Friends mjhe Alphabets list banani hai for example
    AAAAAAAA
    AAAAAAAB
    AAAAAAAC
    AAAAAAAD
    AAAAAAAE
    AAAAAAAF
    AAAAAAAG
    AAAAAABA
    AAAAAABB
    AAAAAABC
    AAAAAABD

    End me ZZZZZZZZ ana chahye
    is trha MS EXCEL me kaise bane gi. sirf Numbers is trha banty hai but Alphabets nahi ban rahy. plz help

  2. #2
    My Heaven's Avatar
    My Heaven is offline Advance Member
    Last Online
    22nd July 2021 @ 12:31 PM
    Join Date
    26 Nov 2010
    Location
    Kashmore
    Gender
    Male
    Posts
    2,805
    Threads
    306
    Credits
    7,621
    Thanked
    137

    Default

    plz koi janta hai to bata de

  3. #3
    DesertRose84 is offline Member
    Last Online
    8th March 2017 @ 11:44 AM
    Join Date
    21 Jan 2016
    Gender
    Male
    Posts
    790
    Threads
    45
    Thanked
    29

    Default

    I think not possible...

  4. #4
    My Heaven's Avatar
    My Heaven is offline Advance Member
    Last Online
    22nd July 2021 @ 12:31 PM
    Join Date
    26 Nov 2010
    Location
    Kashmore
    Gender
    Male
    Posts
    2,805
    Threads
    306
    Credits
    7,621
    Thanked
    137

    Default

    Quote DesertRose84 said: View Post
    I think not possible...
    koi to tareeka hoga. any others?

  5. #5
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    10,901
    Thanked
    1925

  6. #6
    My Heaven's Avatar
    My Heaven is offline Advance Member
    Last Online
    22nd July 2021 @ 12:31 PM
    Join Date
    26 Nov 2010
    Location
    Kashmore
    Gender
    Male
    Posts
    2,805
    Threads
    306
    Credits
    7,621
    Thanked
    137

    Default

    Quote Sahil_Jaan said: View Post
    BRO THANKX FOR HELP . YE KAAM KA NAHI. KOI AUR METHOD?

  7. #7
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote EmranHashmi said: View Post
    Salam sab dosto ko
    Friends mjhe Alphabets list banani hai for example
    AAAAAAAA
    AAAAAAAB
    AAAAAAAC
    AAAAAAAD
    AAAAAAAE
    AAAAAAAF
    AAAAAAAG
    AAAAAABA
    AAAAAABB
    AAAAAABC
    AAAAAABD

    End me ZZZZZZZZ ana chahye
    is trha MS EXCEL me kaise bane gi. sirf Numbers is trha banty hai but Alphabets nahi ban rahy. plz help
    Direct tu aisa naee ho sakta lekan totke k through ho sake ha aur mjy mallom bhe naee ha. totkause krna ho tu aap ya fomrula use karian.
    Code:
    "AAAAAAA"&LEFT(ADDRESS(1,ROW(A1),4,TRUE),(ROW(A1)>26)+1)
    jab aap ka matloba result hasil ho jai tu complete range ko copy karain aur paste special k through ise values m add kr lain.

    regards

  8. #8
    My Heaven's Avatar
    My Heaven is offline Advance Member
    Last Online
    22nd July 2021 @ 12:31 PM
    Join Date
    26 Nov 2010
    Location
    Kashmore
    Gender
    Male
    Posts
    2,805
    Threads
    306
    Credits
    7,621
    Thanked
    137

    Default

    Quote syar said: View Post
    Direct tu aisa naee ho sakta lekan totke k through ho sake ha aur mjy mallom bhe naee ha. totkause krna ho tu aap ya fomrula use karian.
    Code:
    "AAAAAAA"&LEFT(ADDRESS(1,ROW(A1),4,TRUE),(ROW(A1)>26)+1)
    jab aap ka matloba result hasil ho jai tu complete range ko copy karain aur paste special k through ise values m add kr lain.

    regards
    SIR plz screenshot se bta den. meine try kya but smj nahi arahi

  9. #9
    DesertRose84 is offline Member
    Last Online
    8th March 2017 @ 11:44 AM
    Join Date
    21 Jan 2016
    Gender
    Male
    Posts
    790
    Threads
    45
    Credits
    1,777
    Thanked
    29

    Default

    Quote EmranHashmi said: View Post


    SIR plz screenshot se bta den. meine try kya but smj nahi arahi
    Brother aap ye formula copy karai ="A"&LEFT(ADDRESS(1,ROW(A1),4,TRUE),(ROW(A1)>26)+1 )

    but mera nahi khyal jo aap chahte ho wo apko hasil ho

  10. #10
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Just oper deya hoa formula cell A1 m copy karain aur drag krte jain. Har 26th cell k bad aap ko pahla letter delete krna ho ga. agar aap sirf "A" sa start krte hain tu srf fomula use karian.

    regards,

  11. #11
    My Heaven's Avatar
    My Heaven is offline Advance Member
    Last Online
    22nd July 2021 @ 12:31 PM
    Join Date
    26 Nov 2010
    Location
    Kashmore
    Gender
    Male
    Posts
    2,805
    Threads
    306
    Credits
    7,621
    Thanked
    137

    Default

    Quote syar said: View Post
    Just oper deya hoa formula cell A1 m copy karain aur drag krte jain. Har 26th cell k bad aap ko pahla letter delete krna ho ga. agar aap sirf "A" sa start krte hain tu srf fomula use karian.

    regards,
    bhai yaqeen karen ap ne 20% masla hal kardia. but ye end me AZZ tak hi ata hai phir formula ="B"&LEFT(ADDRESS(1,ROW(A1),4,TRUE),(ROW(A1)>26 )+1 ) karta hun to BZZ phir ="C"&LEFT(ADDRESS(1,ROW(A1),4,TRUE),(ROW(A1)>26 )+1 ) to CZZ. ab kya kya jae???

  12. #12
    jk khan is offline Senior Member+
    Last Online
    2nd March 2024 @ 08:11 PM
    Join Date
    11 Nov 2015
    Age
    31
    Gender
    Male
    Posts
    108
    Threads
    7
    Credits
    924
    Thanked
    0

    Default

    IS FORMULA KO COPY KR LO PHR CHANGING KRTY JAO JESY OPER SY KI HY A,B,C,D BS PHR HO JAY GA NA
    ZZZ

Page 1 of 2 12 LastLast

Similar Threads

  1. PSD Ribbon Alphabet
    By baliforu in forum Design Stuff
    Replies: 18
    Last Post: 1st February 2016, 12:19 AM
  2. Solved World Excel Keys List
    By Sn1p3r in forum Solved Problems (IT)
    Replies: 9
    Last Post: 26th May 2012, 04:47 PM
  3. start and end with same alphabet
    By sallu2077 in forum Baat cheet
    Replies: 492
    Last Post: 9th June 2011, 07:54 PM
  4. Solved Excel Expert pls help (invitation list)
    By fade in forum Solved Problems (IT)
    Replies: 4
    Last Post: 28th March 2011, 04:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •