Please include the Excel function/formula used for this question.
5. Append Foreclosure Step (extract from the foreclosure comment). The field should be blank or "n/a" for loans not in foreclosure. i.e.: "This Loan is in Step: Service" --> Service Foreclosure Step o u Loan Loan Number Seller Name Loan AmountAnnual Rate Term (Years) Payment Payments MadeCurrent Balance Loan Type Agency Delinquency (Months) Status 1 83449837 Shanna's Loan Headquarters 280,000 6.34% 30 $0.00 191 $0.00 VA 2 41209504 Shanna's Loan Headquarters 370,000 4.79% 30 $0.00 322 $0.00 UCONV 3 25055860 Shanna's Loan Headquarters 210,000 6.14% $0.00 32 $0.00 USDA 4 61173887 Shanna's Loan Headquarters 120,000 6.99% $0.00 $0.00 VA 5 51398733 Shanna's Loan Headquarters 350,000 5.01% $0.00 154 $0.00 UCONV 76906141 Shanna's Loan Headquarters 220,000 4.28% $0.00 $0.00 ICONV 49304139 Shanna's Loan Headquarters 330,000 7.99% $0.00 $0.00 USDA 8 23473039 Shanna's Loan Headquarters 160,000 3.78% $0.00 317 $0.00 USDA 9 53651842 Shanna's Loan Headquarters 370,000 5.65% $0.00 73 $0.00 ICONV 10 77159777 Shanna's Loan Headquarters 240,000 5.67% $0.00 174 $0.00 VA Foreclosure Foreclosure Comment 0 This Loan is in Step: n/a o This Loan is in Step: n/a 0 This Loan is in Step: n/a o This Loan is in Step: n/a o This Loan is in Step: n/a This Loan is in Step: n/a O This Loan is in Step: n/a O This Loan is in Step: n/a o This Loan is in Step: n/a O This Loan is in Step: n/a 30 5. Append Foreclosure Step (extract from the foreclosure comment). The field should be blank or "n/a" for loans not in foreclosure. i.e.: "This Loan is in Step: Service" --> Service Foreclosure Step o u Loan Loan Number Seller Name Loan AmountAnnual Rate Term (Years) Payment Payments MadeCurrent Balance Loan Type Agency Delinquency (Months) Status 1 83449837 Shanna's Loan Headquarters 280,000 6.34% 30 $0.00 191 $0.00 VA 2 41209504 Shanna's Loan Headquarters 370,000 4.79% 30 $0.00 322 $0.00 UCONV 3 25055860 Shanna's Loan Headquarters 210,000 6.14% $0.00 32 $0.00 USDA 4 61173887 Shanna's Loan Headquarters 120,000 6.99% $0.00 $0.00 VA 5 51398733 Shanna's Loan Headquarters 350,000 5.01% $0.00 154 $0.00 UCONV 76906141 Shanna's Loan Headquarters 220,000 4.28% $0.00 $0.00 ICONV 49304139 Shanna's Loan Headquarters 330,000 7.99% $0.00 $0.00 USDA 8 23473039 Shanna's Loan Headquarters 160,000 3.78% $0.00 317 $0.00 USDA 9 53651842 Shanna's Loan Headquarters 370,000 5.65% $0.00 73 $0.00 ICONV 10 77159777 Shanna's Loan Headquarters 240,000 5.67% $0.00 174 $0.00 VA Foreclosure Foreclosure Comment 0 This Loan is in Step: n/a o This Loan is in Step: n/a 0 This Loan is in Step: n/a o This Loan is in Step: n/a o This Loan is in Step: n/a This Loan is in Step: n/a O This Loan is in Step: n/a O This Loan is in Step: n/a o This Loan is in Step: n/a O This Loan is in Step: n/a 30
