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