Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a column of numbers such as
A B C 1 002 015 102 2 034 002 008 3 015 048 120 4 076 005 008 5 002 048 076 What I would like to do is choose a number such as 002 and get a listing of all numbers that are in the same column.. So if I put 002. I would get a return of 015, 102, 034, 008, 048, 076. If I did 015 I would get a return of 002, 102, 048, 120. I do not care if it comes back with duplicate entries or sorted. Any assistance would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas for telephone numbers: finding duplicates, autoformat | Excel Worksheet Functions | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
finding numbers | New Users to Excel | |||
Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |