Forum Discussion
Solved
Proximity Tracker
Hi,
I'm a golfer and I'm trying to track the average distance to the hole sorted by the club. Basically, I think I need an equation that goes something like, if column S matches column H, in column T for it to show the average of column E when the value of column C is 1.
Try this in R3:
=IFERROR(COUNTIF(tblPutts[Club on approach],S3)/COUNTIF(tblPutts[[Club on approach]:[Miss Green?]],S3),"")
Format R3 as a percentage, then fill down.
