Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To find data
I need someone to help me. I don't know whether it would be easier to put
data from one sheet into another first and then find matches with this list in the data of another. I need to searcxh for items anhd then copy all the data that is adjacent to the matched numbers to create a list for someone else to work with. Can anyone tell me how to go about this. I think I should have started earlier on learning spreadsheets! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To find data
If you already have a list of known items you want to find, use this with a
VLOOKUP to match to the corresponding value in your master table. You can also use an IF statement to mark everything that matches with a convenient marker and then sort by this to collapse the matched data to pass on -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "rocketron" wrote: I need someone to help me. I don't know whether it would be easier to put data from one sheet into another first and then find matches with this list in the data of another. I need to searcxh for items anhd then copy all the data that is adjacent to the matched numbers to create a list for someone else to work with. Can anyone tell me how to go about this. I think I should have started earlier on learning spreadsheets! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find formatting doesn't work: "Excel cannot find data" | Excel Discussion (Misc queries) | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?) | Excel Worksheet Functions | |||
find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) |