Search results

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!

So if I understand, if the result is 24 hrs or more, the result will only show the remainder OVER 24 hours. That is what it appears to do. So how do I take a result that is 44 hours and 35 minutes and multiply only the hours by 60 and also add the minutes? Or any result as far as that goes?

Simple worksheet where: Cell E6 is time in as in 7:28 AM cell formatted as h:mm Cell F6 is time out as in 4:32 PM and the cell is also formatted as h:mm Cell G6 is total using formula =IF(F6<E6,F6+1,F6)-E6 That works fine giving 9:04 My Problem is when I try to add say five days of the...

As a matter of information, now that my tournament is coming up, I used this and ultimately found that it will duplicate players. I also found using the formula =INDEX(range of names,MRAND()) in the number of cells I want results in it works great without VBA but does not restrict the team...

Thanks. I really appreciate that.

=IF(ISNUMBER(F9),IF(SUM(F9-E9)>=0,ROUNDUP(SUM(F9-E9)/2,0)+E9,IF(SUM(E9-F9)>1,(E9-1),E9))) This formula is in cell G9. It works fine except if there is no entry in cell F9, it displays the word FALSE. I want it to remain blank until there is an entry into F9. I have tried incorporating the ""...