## find out in which row an element is equal to a specific number

### Locks (view profile)

on 1 May 2013
Latest activity Answered by Jarrod Halpin

on 14 May 2016

### James Tursa (view profile)

hi,

I have the following problem:

I have a matrix with 20 columns and over 200'000 rows. somewhere in this matrix there seems to be some strange datas which I would like to delete. If I am looking for the rownumbers where the value is higher than a specific value, lets say I am looking for all the values in the first row that are larger than 1500

If I do this:

data18(:,1)>1500

I get a logical array, but what I am looking for is the exact row number, what do I need to do?

## Products

No products are associated with this question.

### James Tursa (view profile)

on 1 May 2013
Edited by James Tursa

### James Tursa (view profile)

on 1 May 2013

If you are looking for rows where any value is > 1500, then

```find(any(data18>1500,2))
```

Or if you are only interested in rows where the 1st column is > 1500, then

```find(data18(:,1)>1500)
```

Locks

on 1 May 2013

thanks

### Youssef Khmou (view profile)

on 1 May 2013
Edited by Youssef Khmou

### Youssef Khmou (view profile)

on 1 May 2013

hi try :

` [x,y]=find(data18(:,1)>1500);`

Locks

on 1 May 2013

thanks!

### Jarrod Halpin (view profile)

on 14 May 2016

How would you implement this in a loop for a variety of values?

#### Join the 15-year community celebration.

Play games and win prizes!

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi