Here's a screenshot of the area involved.
Hi Purfleet, Thank you for the rapid response. I ran the macro with my range and got the same error. I did not mention that the range is comprized...
Catalin - you've been great, thanks for your patience and all your assistance. Sal
Hello Catalin, Can you tell me what rw means in the formula.
Hello again Catalin, Thank you for the formula. As I said before, I am new to structured formulas, and was wondering if you could explain the formu...
Hi Catalin, Sorry for all the confusion. Let me start fresh. Looking at the net scores section. Lets say that it shows that I have 11 Salesman and ...
Hello Catalin, Nothing nor anybody to be removed. Referring back to the example, just below the net scores are the "Skins". A skin is either a bird...
Hi Catalin, Yes I tried the query and found several players on a hole that had the same min value. That's why I said "almost" in my reply. Anyway,...
Hi Catalin, Not bad for being full of holes. Almost, I need the min to be the lowest non-duplicated value. In english, the single lowest score. T...
Here is a picture of the query:
If you bring up the queries and open tblDay1 you will see the query. Each player has 18 scores, one score on each of the 18 holes. The end result is t...
I don't want to delete or change anything. I want to know the unique (single value) low score on that hole. I am new to power query and haven't been a...
Searching the internet the problem is solved. The floor function was not necessary for this situation, a simple integer division sufficed. This was th...