Counting Positions

[smandula]

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

 

[Mel Arquiza]

Hi smandula,

Have you try using "=COUNIF(A15,"11")" on cell?

 

[smandula]

Found solution using Match function

With thanks