| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
tricky excel formula
I have the following columns of data:
Column A Column B Product Number of faults 1 5 5 1 6 2 5 3 What formula (or set of formulas) will be able to tell me the proportion of Product number 5's that have more than one fault? (Note - I want a formula that does not require an autofilter to be applied to my columns of data) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tricky Formula | Excel Worksheet Functions | |||
| Tricky Formula | Excel Discussion (Misc queries) | |||
| Help with a tricky formula...... | Excel Discussion (Misc queries) | |||
| Tricky formula | Excel Discussion (Misc queries) | |||
| Req, Tricky column formula | Excel Worksheet Functions | |||
Threaded Mode
