Next up, a hard pull calendar. Note that because this involves formulas that will recalculate results based on the current date when you open the excel doc, every time you open it you will be asked to save changes even if you didn't change anything.
- I use the abbreviations EQI, EXP, and TRN
- Let's say A2 on the exposure/calendar sheet is the issuer whose pulls we want to know about.
- Column B on 'Account History' is the date of application
- Column F on 'Account History' is the bureau pulled (multiple is allowed, ex EQI/EXP)
=COUNTIFS('Account History'!B4:B400,">"&TODAY()-730,'Account History'!F4:F400,"*"&A2&"*")
Gives you the number of pulls from the issuer in A2 in the past 2 years (roughly)
=COUNTIFS('Account History'!B4:B400,">"&TODAY()-365,'Account History'!F4:F400,"*"&A2&"*")
Gives you the number of pulls from the issuer in A2 in the past year (roughly)
=COUNTIFS('Account History'!B4:B400,">"&TODAY()-183,'Account History'!F4:F400,"*"&A2&"*")
Gives you the number of pulls from the issuer in A2 in the past 6 months (roughly)