sounds like you need a vba program.
copy your file to a new spreadsheet. copy the code below. open your new spreadsheet.
press alt f11 then paste the code. close window.
put your lowest # in row 2 col G your highest in row 2 col H.
press alt f8 run macro "check".
if you like the results you can repeat the steps above in your original spreadsheet. if not delete the new spreadsheet
p8
Sub check()
Dim m(160, 8)' slightly larger than your data file
Row = 2
Cells(1, 7) = "First": Cells(1, 8) = "Last" ' headings
Cells(1, 10) = "Test Num"
Cells(1, 11) = "col": Cells(1, 12) = "row"
Cells(1, 13) = "col": Cells(1, 14) = "row"
Cells(1, 15) = "etc"
first = Cells(2, 7): last = Cells(2, 8)
For x = first To last ' first to last number to test
GoSub clear
For Z = 1 To 150 ' column to test
For y = 1 To 5 ' col a thru e
a = Cells(Z, y) ' number to be tested
If a = x Then m(Z, y) = n: n = n + 1 ' if it matches store count in this matrix position
Next y
Next Z
If n > 2 Then GoSub display
Next x
Exit Sub
clear: ' clear results last number under test
For j = 1 To 150
For k = 1 To 5
m(j, k) = 0
Next k
Next j
n = 1
Return
display:
nx = 10 ' col i as start display point
Cells(Row, nx) = x: nx = nx + 1 ' number under test
For Z = 1 To 150
For y = 1 To 5
If m(Z, y) > 0 Then Cells(Row, nx) = y: nx = nx + 1: Cells(Row, nx) = Z: nx = nx + 1
Next y
Next Z
Row = Row + 1
Return
End Sub