It's a different approach than what I was playing around with (which, obviously did not work) but this latest code achieves the objective. Thank you ...
I appreciate the assistance but the above code does not achieve the objective. When double-clicking the "Data" column, it is sorting the "Data" colum...
I was just coming to upload a file, realizing I forgot. See attached. Sheet1 is the VBA working fine other than when I double-click "Data", I want...
I wondered as all my attempts were failing. I appreciate the reply and letting me know. Thank you.
My apologies, I spoke too soon. With regard to the last group, after #"Added Custom" = Table.AddColumn(#"Added Index", "Grouper", each if [Team] = nu...
Okay, I see what you did here; I can follow every step. Yeah, that works. Just "got stuck." Thank you for the help.
Thank you for helping. The group number does not matter as long as each two are paired together. And, I keep the blank row to show separation from...
Very interesting thought. That does the trick for my example. Never thought of that. Thank you very much for the suggestion.
Final post. I was able to incorporate this into the larger file with multiple queries and is working as intended. I was originally looking to stay a...
Thanks Phil. You got the idea of what I was trying to accomplish even though I could not explain the situation well. I am certain someone who knows ...
I am fairly certain my "error" occurs within the grouping and ranking (indexing). Is there a way to group/sort/rank all in one step and solve my prob...