| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching/Counting an array
I have a really large array of data. It's in the area of 500 rows by 500
columns, with up to 30 sheets. It's formats is 1 Model Scheme Sheet TR401 TR402 TR403 TR404 TR405 2 34901 001 001 701 701 702 701 702 3 34902 001 001 701 701 701 701 702 4 34902 001 002 701 701 701 701 702 Etc. Etc. Etc. Is there a formula or group of formulas that will let me count who many times a number or numbers appears in a given row, since the rows can have different numbers or the same depending on the model, scheme & sheet. Ultimately I want to be able to loop and check every row until I run out of data and open a new worksheet and list the results. Hope someone out there can help me. Am I going about this the right way? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching for text & counting how many times it appears | Excel Worksheet Functions | |||
| Searching for a value in an Array | Excel Worksheet Functions | |||
| Searching a limited amount of rows in a vertical array | Excel Discussion (Misc queries) | |||
| searching in an array | Excel Discussion (Misc queries) | |||
| Searching for a criteria in array of cells within an IF statement | Excel Worksheet Functions | |||
Hybrid Mode
