Dear Experts,
Mujhay Excel ka formula chahiay....
Screen shoot deikh lein aap ko samajh aa jaey gi....
aap kay jawabaat ka muntazir....
Dear Experts,
Mujhay Excel ka formula chahiay....
Screen shoot deikh lein aap ko samajh aa jaey gi....
aap kay jawabaat ka muntazir....
Last edited by n2cute; 14th October 2009 at 02:55 PM. Reason: screenshoot was not attached befor.....
brother
just type in A! 1 and in A2 2
select both cell
u will find a small aik nukta sa in cells kay right bottom side par bas us ko mouse say wahan tak khainch do jahan tak darkar hai
Duaoon main yaad rakhna
baig
Thank you baig
yeh tareqa to mujhay bhi pata hai actually main kuch cells merge kiaye howay hain iss liay woh iss method say nahi hoota..
Kindly koi aour method bata dein
nice.........
[IMG]http://i919.***********.com/albums/ad33/arifraza/Denguevirus.jpg[/IMG]
app aaisa karo Excel file share karo
salam agar aap file ka screen shot de sakti he to ho sakta he aap ka masla hal ho jay
please reply me ASAP
thanks
dear experts
please help on urgent basis
salam::
merge cell main no k leye thoda sa time dain subha fiqure out kar ke bataon ga. Lekan claim# main main ne notice kia ha ka emp# aik he hai jis k leye aap series 1.1 to 1.1o generate karna chahte ho. is k leye solution hazar ha. dobara apni sample data ki file attached kardain tu meharbani hogi. kion ka mughe aap k masle par kam karne k leya kafi typing karne pare ha aur main ne apni file main kia ha jis ki wajha se cell no mukhtalif honge. aap khood adjust karlejeye ge.
Suppose your data start from c2. in b1 enter 0
In cell b2 type this formula and copy down as long required
=IF(C2=A1,LEFT(B1,FIND(".",B1&".",1)-1)&"."&MID(B1,FIND(".",B1,1)+1,255)+1,LEFT(B1,FIND (".",B1&".",1))+1&".1")
agar aap se figure out na ho tu please apni file attached kar dain main kar donga inshallah.
Apni duaon main yad rakhee.
regard
syar
App ke screen shot ke hisab se jahan tak main smjha hon k aap
ne cell merge kar ka 1 no jo dia he wahan par employee no same he.
2 no par employee no alag hai.
agar cell merge karne ki bajae aap ye formula lagain tu jahan bhe naya
empoyee no starthoga sirf us he ka samne count no aajaey ge for example.
123 1
123
123
345 2
345
678
678 3
If this approach acceptable then try this formula (work only when data enter c2)
=if(c2<>"",IF(COUNTIF($C$2:C2,C2)=1,MAX($A$1:A1)+1 ,""),"") also see attached file sheet2.
Lekan agar aap chahte ho ka same employee ka samne aik he no aae tu try this
(work only when data enter c2)
=IF(C2<>"",+COUNTIF($C$2:C2,C2),"")also see attached file sheet1.
123 1
123 1
123 1
345 2
345 2
678 3
678 3
Merge cell main bhee autonumber ho sakta hain leekan tricky hai. Is ki jagha
agar macro solution ho tukiya acceptable ha.
Regards
Dear mr. Syar,
can you please PM me your cell number.
Thanks
Pm is not allowed to me bcz my posts are on 50-60.If u pm your cell no then i will text mine. or you need some help locate my email in my profile and mail to me.
regards.
Bookmarks