Formula to exclude loans with certain criteria

brandonmcg

New Member
Joined
Jan 14, 2009
Messages
22
I have a list of loans with data ranging from A to AU and 33,000 rows. Each column has its own header or title.

I need the results of my formula to appear on a new tab so I am guessing put the formula on the new tab?

If Column B equals $0.00 and column C (date field) is null or a date prior to 01/01/2020 then I need all of the remaining loans and their data to be moved to the new spreadsheet.

Column B could be $0.00 but if it has a date in 2020 that is fine I need the results.
B Could also have a dollar amount but should not have a date in column C.
LOAN NUMBERFIRST PRINCIPAL BALANCEPAYMENT IN FULL DATEMove to new spreadsheet?
123456123,456.00Yes
46514651345,678.00Yes
6516510.00No
123455475,165.00Yes
6516510.0003/24/2020Yes
32136510.0011/17/2020Yes
16416984,811.00Yes
864841,563.00Yes
73918520.0002/01/2019No
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

brandonmcg

New Member
Joined
Jan 14, 2009
Messages
22
I am fine if there are other alternatives and open to suggestions how to remove these from the list.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,675
Messages
5,637,733
Members
416,981
Latest member
PLonchar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top