A code using this formula to "lift off" rows is "All I Need"

[panyagak]

Hi Mrexcel Greats!!

I belaboured to obtain this formula from YOU & it works well on data Filter.

=IF(MROUND(ABS(A1),0.25)=ABS(A1),"KEEP",IF
(ABS(A1)<=0.02,"DUMP",IF(ABS(ROUND(A1,0)-
A1)<=0.02,"KEEP","DUMP")))

Given my large excel sheet with computed values, I need to apply this formula on several columns one by one (there are 17 columns before these targeted columns - the code could be flexible to adjust to changing number of columns - between 13 & 24 etc), then extract that specific row & place all extracted data meeting the formula criteria, in a new sheet, "Final Tally".

Happy Labour Day

Regards
Patrick

 

[mole999]

No idea how to visualise what you want

think of the formula like this (first correct value wins)

=
IF(MROUND(ABS(A1),0.25)=ABS(A1),"KEEP",
IF(ABS(A1)<=0.02,"DUMP",
IF(ABS(ROUND(A1,0)-A1)<=0.02,"KEEP","DUMP"
)
)
)

 

[panyagak]

Let me try a bit:

In the more than 24 columns, each has its header. eg Column A - Date, Col. B - Subject names......values start from column C to col. 24 or nth col. & rows could be as many as 4,500!!

Coumns A to 13 is what needs extraction AFTER using the formula; focus of the formula being locating values AFTER Col. 14 sought by the formula up to col.24....nth). NB: its one col. AT A TIME; eg. if 5.99 in col. 18 on row 118 is picked, it needs accompanyment: I just need all the entire row with its column headers to accompany 5.99 hence "Lift-off"" to a new sheet, "Final Tally1", Final Tally2, 3 4.. for each column & its values.

My PC is not near to give specifics of the no. of columns though it wont change this info.

Regards
Patrick

 

[panyagak]

mole99

Let me attach on Saturday the condensed workbook:you'd rather have it to better understand my problem PLUS my IF conditions

Regards
Patrick