Formula to return value based on two input column

[Dandapani S]

Hello!

I require a formula which provide a running number (to group) based on two column (document #, Material #). Please refer attached sheet which is self explanatory.

Thanks & regards
Dandapani.S

 

[Faseeh]

Pleaes put htis in F11 and drag down: =FLOOR((1+D11)/2,1)

.. assuming you group like this 1-2,3-4,5-6, so on

 

[Dandapani S]

Please notice my attachment file....I required output based on two columns. If material number repeats, the concern documents should be grouped by a unique number. Sorry if did not explained properly in my previous post.

 

[Faseeh]

Sorry i can't pick that up. Lets say A,B,B,C where B is repeated, and document no. is 1,1,2,2 how do we came to know that we should group them?

 

[prasaddn]

@op,
Pls provide additional examples are more clear requirements.

regards,
Prasad DN