Skip to main content

Author Topic: Recovery Payment Received for Charged Off Loans

  • Posts: 300
Recovery Payment Received for Charged Off Loans
OP: February 19, 2019, 12:00:00 AM
Hello,

Do any readers have notes from following loans in their portfolio? I am looking for information on how much recovery amount were they paid on these charged off loans. Original amount lent, amount charged off, and recovery amount paid information on any notes from following list of Loan ID is appreciated.

Thanks.

Code: [Select]
  • IP logged

j
  • Posts: 143
Recovery Payment Received for Charged Off Loans
#1: December 31, 1969, 07:00:00 PM
Could you dump them into a single column so its easier to get into excel to match?  Doesn't go in cleanly as is.  Curious where this is going.
  • IP logged

l
  • ****
  • Sr. Member
  • Posts: 323

T
  • Posts: 6588
Recovery Payment Received for Charged Off Loans
#3: December 31, 1969, 07:00:00 PM
Thanks lascott.  No matches here either.
  • IP logged

  • *****
  • Hero Member
  • Posts: 602
Recovery Payment Received for Charged Off Loans
#4: December 31, 1969, 07:00:00 PM
Thanks for putting them in one column.

No matches here.
  • IP logged

R
  • Posts: 484
Recovery Payment Received for Charged Off Loans
#5: December 31, 1969, 07:00:00 PM
None of them in here.
  • IP logged

.
  • Posts: 61
Recovery Payment Received for Charged Off Loans
#6: December 31, 1969, 07:00:00 PM
No matches from my 10k+ loans.

For those excel challenged (like myself), I simply pasted this list to the first column of the bottom of my latest notes_ext.csv, then  highlighted the column, and selected "Conditional Formatting", then "Highlight Cell Rules", then "Duplicate Values". Duplicate values will show up colored.

Let me (everyone) know if there is an easier way.
  • IP logged

r
  • *****
  • Hero Member
  • Posts: 575
Recovery Payment Received for Charged Off Loans
#7: December 31, 1969, 07:00:00 PM
You can put the list in Excel and use this formula: =match(AnilLoanID,RangeofLoanIDs,0).    Rank by the result. Things with numbers are matches

For example, =match(187383,A:A,0)
  • IP logged