Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif problem
hi, i have the following problem
worksheet 1: company number of industries 1000 ? 1010 ? 1020 ? worksheet 2: company industry 1000 2115 1000 2350 1000 2140 1010 3500 1010 3510 i would like to count per company the number of industry codes, differing at the first 2 digits. so for company "1000" count would be 2. (21.. and 23..), but for "1010" count would be only 1. a normal countif function appears inappropriate, i tried count(if(AND(company="1000";left(industry..;2)<le ft(industry..;2));industry...) but i excel stops once it has found the company in row 1. thanx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing csv files, problem with date formats | Excel Worksheet Functions | |||
CountIf & null values problem | Excel Worksheet Functions | |||
countif problem | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
problem with countif | Excel Worksheet Functions |