Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Im totaly new in excel so i really need some help. Dont even know what function i need to use. I have 8 columns. The first column is a counter The 7 others contains codes for faults on 7 different channels that get theres value from manual input. The codes has a value and from all this i get a graph. Count/points. Now i need to know when criterion is met and mark the count in the graph some way. Fault codes: A B1-B13 For example: Criterion 1 to be met: Fault B1 or fault A Criterion 2: One individual channel B1 or two channels with B1 or one channel with A Criterion 3: One individual channel B2 or four B1 The criterion is judged by row. So when it find a row that match one of these i need that count to be marked in the graph and then that criterion is set and not needed to be checked no more. Hope i make some sense. -- Moffe ------------------------------------------------------------------------ Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594 View this thread: http://www.excelforum.com/showthread...hreadid=502440 |