EmranHashmi said:
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
Bookmarks