Recent content by BobNTN

I finally had to completely remove the one I had in Excel then shut Excel down and restart the desktop and laptop. Then reinstalled the addin from the 'Default' directory and it appears to work. Thank you so much for putting me on the correct path. I should have thought of that but alas, I...

Yes you are correct. I added the Microsoft/addins directory under user 'default and copied the file over then changed the path in Excel. I will do the same on laptop, and try the file there. It should work, we will see. I will let you know. Thanks so much.

Ok, how do I do that since Excel puts it there?

May not belong here but since it is a Windows subject: I added a third party addin called Xlookup to my two desktops and laptop. Works great. Problem is, when I take a spreadsheet from one puter to another, it fails to see the addin path because each puter name is different. So I have to...

Yeah, I guess if someone looked at mine they would be confused but over time and changes and refinements I have made (for my personal reasons) it works for me. I thought about starting it all over to simplify but not sure if it is worth all the trouble. We play 2 courses over 3 days and it is a...

Thanks Minty. You gave me a couple more ideas to consider. This is an annual 2 man team 3 day event strictly based on points system we have been having for around 28 years. We usually have 50 to 60 players, this year 66 and next year looks like 70. We adjust each player's points after each round...

Thank you so much Isaac. I can work with that.

Thanks for all the lessons in breaking ties in golf. I am well aware of those methods. Although they have little to nothing to do with my original question, I appreciate your time. Apparently, it appears, the answer to my question is "no". Furthermore, just so it is clear, time constraints at...

Thanks anyway.

In theory, if my list of players is in alphabetical order and I was first in the list I would win every tie that I had. As I stated in the other reply, the only PURE way to tie break in golf is to mitigate based on the score of those tied by hardest handicap hole in order. But don't even want to...

I would think it would do the same regardless. This is for a large group in a golf tournament. Either way, the only PURE way of a tie breaker is to go to the hardest handicap holes and mitigate on each score starting at the hardest hole. But that would be so difficult......

=IF(ISNUMBER(I4),RANK(I4,$I$4:$I$34)+COUNTIF($I$4:I4,I4)-1,"") This will break ties but it assigns 1, 2, 3, 4 etc starting at the first in the list then the next then the next and so on. Is there a way to have it randomize first second third, or fifth, sixth, etc of those tied? Thanks in...

Not sure I am going to get a reply. Maybe I was not clear in my post?

I added the xLookup addin to 2 pcs and a laptop. When I copy a file from one to puter to another, I get error message on the xLookupformulas because it adds the complete path of the 'from' puter to the formulas. (User/appdata/roaming/microsoft/addins/xlookup.xlam then will not 'Update' saying...

Pretty much works except 44 hours 55 minutes comes out as 44 hours 52 minutes. And that total came from 9:05, 8:35, 9:05, 9:05, 905. 44 hrs 55 min so there should not be any rounding down of whole minutes. Never mind. I got it. Was using wrong column in the minutes calc. Thank you so much!