Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding matching rows
I have a large set of data (6 sheets each 10000 rows each containing 10
sets of 9 columns filled with integers) . I want to compare the values of each set to a set of values and find out how many sets (and what sets) contain 1, or 2, or 3 etc numbers that are in the values to be compared. Can I do this with existing Excel functions (Lookup, pivottables, sumif etc??) or must I use VBA to do it? If anyone has an idea how to use the Excel functions for this pls give me a description HOW to do it I also don't know what VBA-functions exit that could help me (of course I know I can loop through all data and do everything myself, but I suppose some built in functions would do teh job easier and faster) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a Name on a list and returning all matching rows | Excel Worksheet Functions | |||
Finding matching cells | Excel Discussion (Misc queries) | |||
Finding matching numbers in different rows. | Excel Worksheet Functions | |||
Finding matching rows on two worksheets | Excel Programming | |||
Finding criteria and removing matching rows (Range issue?) | Excel Programming |