Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching & Extracting Data
Hi there, I'm wondering which would be the most eficient way to search for
and extract data from anywhere from 1000 to 2000 rows of data. Would the use of a worksheet function sufice or would VBA code be better? Here's the senerio: A B C D E F G ....... 1 101 204 $5.99 12 1 ? ? 2 104 201 $4.99 10 2 ? ? 3 101 204 $2.99 3 4 ? ? 4 105 202 $1.99 11 3 ? ? 5 102 200 $4.59 20 5 ? ? 6 102 200 $1.50 30 1 ? ? 7 101 208 $6.49 25 1 ? ? ETC... I need to extract information in many ways.... i will need to do about 50 separate and different searches and extracts from this data to a specific cell. So I'm thinking that the re-calculating of this workbook would be too demanding. Here are two examples of what I'm looking for... The first is searching through column A til the end (End is always unknown and changing) let's say we're searching for 101 in column A. It would find 3 results, in this case. I would then need the sum from columns(E*D*C) from rows 1,3,7. So cell AA100 would get this grand total of $270.01. The second method would be the same but would perform a second search in column B... so we might look for 101 in column A and 208 in column B then do the same mathematics. I hope I've explained this OK... I think I'm confused! Thanks Craig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching data | Excel Discussion (Misc queries) | |||
Searching for data | Excel Worksheet Functions | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
extracting data from a spreadsheet by searching on columns | New Users to Excel | |||
Searching Data | Excel Programming |