How can numbering alphabetically grop wise from master sheet?

Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Click on GO ADVANCED and use the paperclip icon to open the upload window.
http://www.excelforum.com/members/da...ch-a-file.html

So you want to first sort out by group number and then alphabetically in each group?

Try this
I have made a macro----
Just put in your data and press go
Works for first 30 rows ...change the array to suit your requirement or ask me to do the same....
Tell me if it works right….

Hope it helps

If you are satisfied then mark the thread as solved and you can just click on ADD REPUTATION below my post to say thanks...by doing this you add to my reputation…...

Regards
Sourabh Gupta

Originally Posted by oeldere

For excel 2007 and higher you can use the formula below.

d4= 1+countif($B$3:$B$100,B3,$C$3:$C$100,"<"&C3)

I think that should be countifs....

Originally Posted by sourabhg98

So you want to first sort out by group number and then alphabetically in each group?

Data not allowed to sort out by group, Formula can be conditional so that if group is 1 then data will count in alphabetly

Originally Posted by sourabhg98

So you want to first sort out by group number and then alphabetically in each group?

Data not allowed to sort out by group, Formula can be conditional so that if group is 1 then data will count in alphabetically

not working in 2003

Originally Posted by oeldere

Please Login or Register  to view this content.

This means you are NOT allowed to sort the data?

Yes sir, here data more 1000 rows and more then 50 groups (equal group number in different rows like group 1 is row 1, 10, 50, 105, 250, so on etc) and each group required sequence number in alphabetically.

Thank you

Ohk
So you just need those numbers
Check out this one.....
After entering your data press the go button....
Works for 1000 rows...

Note: Remember to enable the macros from the options bar that appears just after you open the workbook

Hope it helps

If you are satisfied then mark the thread as solved and you can just click on ADD REPUTATION below my post to say thanks...by doing this you add to my reputation…...

Regards
Sourabh Gupta

Originally Posted by sourabhg98

Ohk
So you just need those numbers
Check out this one.....
After entering your data press the go button....
Works for 1000 rows...

Note: Remember to enable the macros from the options bar that appears just after you open the workbook

Hope it helps

If you are satisfied then mark the thread as solved and you can just click on ADD REPUTATION below my post to say thanks...by doing this you add to my reputation…...

Regards
Sourabh Gupta

Thank you sir for your cordial trying but sorry to inform u that the sheet makes run time error, end and debug

Are you sure??... It is working perfectly here.....

Maybe there is a problem with the excel version...

Just try by putting this in the beginning {before "Range("A2:D1000")}
Application.DisplayAlerts=False
and this at the end {before "end sub"}
Application.DisplayAlerts=True

Originally Posted by oeldere

1) What you gonna do with your data, when you know the ranknumber?

2) There is always a set of 4 data, belonging to a set?

I have attached revised sheet, Pls see it again. Previous sheet name was duplicate but actual data is unique not same for each group.

Ohk use this one
D3 =IF(A3="","",1+SUMPRODUCT(($B$3:$B$10=B3)*($C$3:$C$10<C3)))
Copy downwards......

Hope it helps.....
If you are satisfied then mark the thread as solved and you can just click on ADD REPUTATION below my post to say thanks...by doing this you add to my reputation…...

Regards
Sourabh Gupta

Originally Posted by sourabhg98

Ohk use this one
D3 =IF(A3="","",1+SUMPRODUCT(($B$3:$B$10=B3)*($C$3:$C$10<C3)))
Copy downwards......

Hope it helps.....
If you are satisfied then mark the thread as solved and you can just click on ADD REPUTATION below my post to say thanks...by doing this you add to my reputation…...

Regards
Sourabh Gupta

Thank you very much Sourabh Gupta, Problem is solved as per your formula. Thank you again for your cordial cooperation.

Emran

Originally Posted by oeldere

@sourabhg98

Very good point using sumproduct (which is available in excel 2003).

I added your formula in a sheet and attached it.

@emran06

You did not answered the question what you gonna do with the result.

I will make item code in group wise from master sheet of all items.

Thanks