How would you count positions or depth between identical numbers.

Using VBA how would count the sum position difference of rows for number 11?
regardless of the rows and columns, keeping within range
of A1 ... D50 In this case number 11 has 4 positions count.

First scenerio:

A B C D
1 11
2
3
4 11
5

A B C D
100 Count 4

With thanks

Hi smandula,

Have you try using "=COUNIF(A1:D5,"11")" on cell?

"smandula" wrote:

How would you count positions or depth between identical numbers.

Using VBA how would count the sum position difference of rows for number 11?
regardless of the rows and columns, keeping within range
of A1 ... D50 In this case number 11 has 4 positions count.

First scenerio:

A B C D
1 11
2
3
4 11
5

A B C D
100 Count 4

With thanks

Found solution using Match function

With thanks

"smandula" wrote in message
...
How would you count positions or depth between identical numbers.

Using VBA how would count the sum position difference of rows for number
11?
regardless of the rows and columns, keeping within range
of A1 ... D50 In this case number 11 has 4 positions count.

First scenerio:

A B C D
1 11
2
3
4 11
5

A B C D
100 Count 4

With thanks