Find all rows where valuea is less than valueb

[mreidiv]

How do i find all rows where MAP is less than WNET and put them in a new sheet.

[Steph1]

Welcome @mreidiv!

You can create a new column with the formula on the second row:
=IF(B2<F2;1;0)
(assuming MAP is in column B and WNet in column F), then copy this formula up to the last row. Then, select the first row and click on the menu Data > Autofilter. Now, in the first cell of the column where you created the formula, select only the value 1. Only the rows you want are now displayed. You can now select all of them and copy them into a new sheet.