Sequence numbering with 3 result combinations

hi all,

i hope you could help me about sequence numbering, for this below ;
start from col. a..

seq---------------title-----------
1.-----------------aaa----------
2.-----------------aaa-----------
- -----------------ddd-----------
1.-----------------rrrr-----------
2.-----------------rrrr-----------
blank--------------blank---------
- -----------------ttt------------

with 3 result of combination ;
number with mark "." e.g 1.,2.,3.,etc.......

any help, will be appreciated.......

john m
mark "-" if cell contains single
mark "" (blank) if cell blank empty...

Sir please upload excel sheet with data.

Regards,
Suhas

ok, here my workbook attached, please see it...

Put this in A2:

=IF(B2="","",IF(COUNTIF(B:B,B2)=1,"-",COUNTIF(B$2:B2,B2)))

then copy down. You will need to remove the work "blank" from those empty cells, or change the formula to this:

=IF(B2="blank","",IF(COUNTIF(B:B,B2)=1,"-",COUNTIF(B$2:B2,B2)))

Hope this helps.

Pete

Fotis,...very quickly answer....

thank you very much........

Pete, thank you but not fully complete, how do add mark "." (dot) after number

1. or 2.etc...

Pete, thank you but not fully complete, how do add mark "." (dot) after number

1. or 2.etc...

Like this:

=IF(B2="blank","blank",IF(COUNTIF(B:B,B2)=1,"-",COUNTIF(B$2:B2,B2)&"."))

Hope this helps.

Pete

or this...

Please Login or Register  to view this content.

many thanks, Pete...

with different situation ;
1) if the cell (col.B) contains only single data the number should be mark "-"
2) if the cell (col. B) contains several data the number should sequence like 1.,2.,3.,etc........

please, see my new workbook...

please, someone can help me.........

Your example file doesn't make much sense. Please include more data and an indication of what you really want the output to look like.

Pete

Pete, thanks...

in cell D10 as parameter drop down list, then on target start from cell A15 down (yellow area) as sequence number with D10 as selected cell..

here my sample...

Put this formula in A15:

=IF(C15="","",IF(COUNTIF(C$15:C$33,"?*")=1,"-",ROWS($1:1)&"."))

then copy down to A33.

Hope this helps.

Pete

Pete, excellent!!!!

thank you very much......

You're welcome, and thanks for marking the thread as Solved.

You might also like to thank those who have helped you, by clicking on the small "star" icon below any post you have found to be helpful (not just in this thread).

Pete