Search results

Very close. Thanks. Can you keep the data from "refreshing" each time you put a number in? If I have 9 players,is there a way to move the 9th player to participate in the 2nd, 3rd, and 4th bracket if there is not space in the 1st one? Once that functionality is complete, I think I know...

I will have multiple users who will enter either 1,2,3,or 4 brackets. Each bracket will have 8 positions, these will be determined randomally and are different sheets on the spreadsheet. Ex: Joe 4 Jerry 3 Matt 2 Mike 1 So Joe will have to get put in all 4 brackets...

Ok here is the file, hopefully this will show the interface requested. Couple of things, I understand now (thanks to you guys) how the ISBLANK() function and how to return the "last" number of the list using the VLOOKUP() so I know how to clean up the ledger balance on each individual customer...

Nevermind, I figured it out how to do it. Totally unreleated, but did you see that I responded to that CreditBook post I had a couple of weeks back? The one where it could be multiple sheets or single sheets? I was wondering if you can elaborate a little more on how the "single sheet"...

Sheet1 has categories A B C with subsets D E F respectively (ie. Fruit makes list apple, orange, and starberry/Vegetable makes list onion, potatoe,) On Sheet2 I want to reference subgroups fruit and vegetable which are located on sheet1 What does the "source" area look like for that to...

Should I post my current file? Would that help? Thanks.

Well I have over 275 people right now in the "Multiple Tabs" style. I can operate it fine and maintain it fine and it seems consistent in my eyes, tho not to the other users on it. What would a Single list format look like? Can you give me a quick sample to see if that will work....I'm not...

I did a file in the past doing this with multiple tabs, one tab for each person involved and had a summary sheet for quick access but was not very dynamic and user friendly so i'm hoping there might be a better way... I have X amount of people who have independent balances. These balances...

Awsome. Thanks. "COUNTIF" is really strong, 1st time using it.

Close......I need it to count 0 as a "0 value" so 5,6,0,4,A,B Returns .375

Example A1: 5 A2: 6 A3: 9 A4: 2 Each of these values are out of a possible 10, so I would like the cell used to show the result to be able to count the "entries" and then return the correct percentage for the value against the total amount of the entries. So above should be able to...

Awsome. Thanks! This is sooooooo much better than what I conceived originally. One more question though, I have people using both platforms (2003 and 2007). My version is 2007 so functionality wise do I need to do this in 2003 or do the table properties xfer over once I saved a 2007 file...

2 sounds good though i'm finding difficulty understanding how that visually would look. Sample file? Im basically looking for the company to have two ways to traverse the list, one by tool number and one by customer. Just trying to simplify it for them as their present list was just in...

Here is the link to the shared file. Thanks for your help! http://www.4shared.com/file/197783843/d5c08067/Testfilea.html

Hello My 1st post. I am pretty good at excel, but not good at macro programming. Trying to create a spreadsheet with a couple of things going on so hopefully I will explain it well. -Have a datatable with 6 columns and data in one of the columns repeats frequently -Have several different...