| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding all cells that match a certain value
ok i have some data arranged as such, the first column is filled with
names and the column next to it is a remarks column, filled with say, numbers from 1-10. what i want is to have a third column, whereby let's say i choose the number 8, all the names with a number 8 next to them will appear in the third column. can anyone help? thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a match and pasting next to it | Excel Discussion (Misc queries) | |||
| Finding a Text match | Excel Discussion (Misc queries) | |||
| Finding Closest Match | Excel Worksheet Functions | |||
| Finding a match in several columns | Excel Worksheet Functions | |||
| Finding a match | Excel Discussion (Misc queries) | |||
Threaded Mode
