| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find certain items in worksheet?
=PsychicFind(<database-range,<part-numbers-I-Use,3,1)
"sonyavdz" wrote: I have a worksheet with about 5000 part numbers and prices. I only use roughly 2000 of these part numbers. Is there an easy way to create a formula or search to pull out only the part numbers I use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find all items with the same value without using filters | Excel Worksheet Functions | |||
| How can I find multiple items on a sheet?? | Excel Discussion (Misc queries) | |||
| How can I find multiple items? | Excel Discussion (Misc queries) | |||
| Find Count of Items with certain criteria | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Linear Mode
