| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for criteria and count
Good day, i am not a programmer but a dabbler and need some code to do
the following: In sheet2 i have a list codes with thier discription e.g. VA71, VA72 UB73 etc.... On sheet1 i have a list of codes only in column A What i need to do is, loop down the list in sheet2 and with each code, find how many times this code appears in sheet1. Once i have the quantity i must past it to sheet2 Any help is appreciated. Les Stout *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
| Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Threaded Mode
