Another Unique min value excluding zeros conditional formatting question :-/

Hello all!

I am new to this form, as well as somewhat new to excel. After searching and trying to trouble shoot this formatting issue, i am still stumped.

Here is what I would like

To conditional highlight lowest value in a column only if it is unique, excluding 0

Here is what is happening:

With other answers I have found it is either not highlighting, or not highlighting at all. I have included a copy of my work sheet here:

Golf League.xlsm

you can use the following formula in your conditional formating, and it shoudl provide the desired result.

you will need to make sure G7 is the first cell selected when entering the formating.

=AND(G7=SMALL(G$7:G$54,COUNTIF(G$7:G$54,0)+1),COUNTIF(G$7:G$54,G7)=1)

Thanks that worked like a charm!

Would it be possible to send the final score of a player to another sheet based on the team number assigned to match sheet 1 that I posted? Perhaps using index/match?

I would like to take the finals scores from match 1 sheet and put them into the corresponding spots in the infoRaw sheet. The only problem I can't wrap my brain around (due to inexperience) is that the team set up in match 1 sheet will not be the same week to week. The workbook is set up to take the team number as a first to enter in basis, so it recalls their Names and handicap.