jeudi 28 mai 2015

excel sheet using logical operators

I have a a column of data in excel sheet

I want to filter those values the cell have values greater than previous or next cell eg i have values in Excel sheet in column A

Then my logic is

If (A2>A1 & A2>A3)
Then B2=1
else B2=0

I need to execute it for 1000 rows in column A. so something like if(currentcellnum value > currentcellnum-1 value and currentcellnum> currentcellvaluve+1) then print in adjacent column of current cell 1 else 0

Thanks and regards

Aucun commentaire:

Enregistrer un commentaire