Search results

Thanks

Deep Hidden? Never heard that term. Ok, thank you so much.

I have tried that. No matter where I right click. Not listed. I have tried find and go to, does nothing. I have tried everything I could find from searching for it. Really a mystery. I think I will just create and use another table. Thanks anyway.

I am trying to open (find, see, etc) a table so I can edit it. The file is most likely too large to upload.

Excel. I can't find a way to pull it up (existing) to edit the range nor table.

I have a range (values) which is located in a table (CardTable) I am trying to locate to edit. I have searched and tried everything I can find but no luck. (Find and Go To, Name Manager, List tables, list worksheets, etc) The entry in Name Manager refers to (=CardTable!$B$6:$C$13). The range...

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...