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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding an occurence
If you add headers, a Filter (menu Data | Filter) will do it. Choose
Advanced Filter if you want to put the results elsewhere. Hth, Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding an occurence
Sorry - forgot to mention - CANT be autofilter - as it needs to happen
automatically without user involvement. Regards D *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding an occurence
Try this.
Sub macro1() Sheets("Sheet1").Range("A13:B22").Clear iRow = 13 For Each c In Sheets("Sheet1").Range("B1:B10") If c = 1 Then Sheets("Sheet1").Range("A" & iRow) = c.Offset(0, -1) Sheets("Sheet1").Range("B" & iRow) = c iRow = iRow + 1 End If Next c End Sub Hth, Merjet |
Reply |
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 |