Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding an occurence
Hi There,
Two columns of Data A1 to A10 text (say dog, cat, mouse etc) B1 to B10 - either a 1 or a 0 - 1 is a problem, 0 is okay. (these change based on other criteria) I would like to list beneath the data all instances of problems (ie for all cases where column B has a zero, list the value in column A). Not sure if combination of Match or Index would do it, but Im struggling! Any ideas most welcome.... Regards D *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding last occurence of Interior.ColorIndex 36 | New Users to Excel | |||
Finding first occurence of a number | Excel Worksheet Functions | |||
Still stuck on finding the last occurence...thanks... | Excel Programming | |||
Finding how many events since last occurence in a database list | Excel Worksheet Functions | |||
Finding most common occurence of values in cells containing letters and numbers | Excel Worksheet Functions |