Forum

If more than 1 player have the same minimum score, which one should be removed from the list? Based on what criteria or calculation?

Hi Sal, Have you tried the query provided? I continued your query with this step: #"Grouped Rows" = Table.Group(#"Changed Type1", { "Hole #"}...

Hi Sal, I added 4 steps to your query, please check if this is what you need: let Source = Excel.CurrentWorkbook(){[Name="tblDay1"]}[Content...

Can you upload a sample file so we can see what's in there? I don't play golf ... My knowledge on this is full of holes. 😉

Hi Bax, You can Group By the first 4 columns , without aggregation (All Rows) This will produce a new column with tables. If you look in a table...

It is possible, but it will be slower, is there a reason for that preference? You can convert the lookup table to a custom function, replace the na...

You should merge the data table with that Loookup table you described above, I guess you have a Product column in your data table, use the Product col...

I think you should only change this part: ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, IncludeDo...

Hi Laura, Do you want to export visible sheets to pdf, or just the visible ones? Use: Dim SheetVisibility as long 'possible values: ...

Hi, There is a "Next Wks" at the end of your code and I was not able to locate the start of this loop, this should be removed, there is no way the ...

Sounds like a "Group By" transformation to me. If you group by hole (and player probably, not sure) and choose a Count as aggregation, you will be abl...

Not easy. I use different codes on windows, for mac there can be at least 2 separate cases. The code is limiting the number of selected files to...

Hi Aye, Check the Names Manager, it's possible that one of the names has references to those external sources. Another place where links can "hi...

I think you are making a mistake here. IFERROR will not display blanks. IFERROR dislays whatever YOU want to display, like: =IFERROR(oldformula,...

Hi Sunil, You will have to clarify the request. For the moment, it's not clear what the code should search for, where it needs to display the resul...