There is a spreadsheet created every so often in Excel 97, containing 10 - 15
thousand rows of data. Each time a user must manually sort through the data
using the criteria listed below. Is this possible in Excel via, grouping, a
pivot table or more advanced use of macros or visual basic programming?

Criteria:

sort data by name, then date, then amount.

then find within each name if there are 4 or more different dates
OR
find within each name if there are 2 or more dates within 5 days where any
amount is greater then 20.00