Sheet 2 contains:
A: names
B: dates of last sale
C: Commissions
What I am trying to do is display last 3 sales based on date - Sheet 1 C1 For example Sheet1!C1=03/23/16 I want to display name and commissions from sheet2 on sheet 1 in cells a2:a4 If there is only 1 person - then a3:a4 = "no other" - all based on date from sheet1 c1
Second Part:
Would it require some macro / vba to record new row in sheet2 based on another date from sheet1 - I39
Sheets works fine - just trying to eliminate so much cutting and pasting. Have posted an example
Bookmarks