| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create the formula for that attached explanation
Hi Professionals,
I have 2 columns of raw data, column A (code), colum B (nest). Could you help me to write a formula that will count the quantity that meets both criterias which the code and nest stated? Code Nest Qty 9000 CBRNM1 ?? 9000 CBLNM1 ?? 3002 CBRNM1 ?? 3002 CBLNM1 ?? 3001 CBRNM1 ?? 3001 CBLNM1 ?? Raw datas :- Code Nest 9000 CBRNM1 9000 CBLNM1 9000 CBRNM1 9000 CBRNM1 9000 CBLNM2 9000 CBRNM2 9000 CBLNM1 9000 CBLNM1 9000 CBLNM1 3002 CBLNM1 3002 CBRNM1 3002 CBLNM1 3002 CBLNM1 3002 CBLNM1 3002 CBRNM1 3002 CBLNM1 3002 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBRNM1 3001 CBLNM1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula explanation | Excel Discussion (Misc queries) | |||
| Would like an explanation of a formula: | New Users to Excel | |||
| FORMULA EXPLANATION | New Users to Excel | |||
| Formula Explanation Please | Excel Discussion (Misc queries) | |||
| Formula Explanation | Excel Programming | |||
Threaded Mode
