My approach would be to insert a column to left of your SalesDayBook range
In the new column, cell A6 place this formula:
=IF(C6='Billing Statement'!$E$7,1,"")
In A7 place this formula and copy down:
=IF(C7='Billing Statement'!$E$7,COUNT(A$6:A6)+1,"")
You can now do VLOOKUP() formulas within your statement to find the 1,2 & 3 using a check on the number of times Joe Blogg appears by using a COUNTIF() function
Bookmarks