Ordered number on basis of Cell value

[sanjuss2]

Hi'
Please I want to generate sr. no. in column A on the basis of the cell value in J column
Thanks in advance
A B ............... I J
Sr. No. Branch Code Branch Code No of Records
1 11 11 7
2 11 13 5
3 11 28 4
4 11 14 6
5 11
6 11
7 11
1 11
2 13
3 13
4 13
5 13
1 28
2 28
3 28
4 28
1 14
2 14
3 14
4 14
5 14
6 14

[Glenn Kennedy]

Is this array formula what you had wanted?

=IFERROR(MATCH(0,--(COUNTIF($A$1:A1,ROW($1:$100))=$J$2:$J$100),0),"")



Array Formulae are a little different from ordinary formulae in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly brackets yourself - it won't work...

[sanjuss2]

Thanks for reply .... its really gr8

Don't call value in column B

but in sr. no. column i.e. column A, I want numbering i.e. 1,2,3,4,5,............ on the basis of the cell value in J column
Thanks in advance
A B ............... I J
Sr. No. Branch Code Branch Code No of Records
1 11 11 7
2 11 13 5
3 11 28 4
4 11 14 6
5 11
6 11
7 11
1 11
2 13
3 13
4 13
5 13
1 28
2 28
3 28
4 28
1 14
2 14
3 14
4 14
5 14
6 14

[Glenn Kennedy]

Sorry. Only half-awake, it seems. Try this:

[sanjuss2]

Hi
I am hereby attaching the file for your kind perusal
Thanks in advance

[sanjuss2]

Thanks it works perfect
..... Gr8

[Glenn Kennedy]

Glad to have helped!