points

Hi All, my first post so sorry if its in the wrong place! Im looking to make a spreadsheet for a local club which im involved with that will track their points throughout a season and show who is the winner at the end. Basically its a horse riding club and they have around five events a year...

Hello Experts, I have single column showing decimal latitude and longitude of some points and they are separated by commas. This column has multiple no of rows but the no of digits after the decimal for each entry is not static. I would like to have code that will read the latitude and...

Hello, I have the attached image (left) of more than 45k data points and I want to delete all the points within a range from the trend line to have it like the one on the right side (only the points between the two red lines, deleting all other points that fall out). I can't think of a...

I have a program that opens an existing workbook, adds a date to the name and saves it as a new file. The code says to save it as a .xlsm file type but it ends up as a .xl01 or a .xl04 or a .xl010 file type. Excel does not recognize this file type when attempting to open in explorer. I cannot...

I need to accomplish the following with very little VBA experience!! Click on a cell that contains a date Check to see if a file exists using the selected date, "C:\Users\Jeff\OneDrive\LH\Events and Conference Points Table\date" If it does open it If it doesn't, create it from a template...

All, Trying to use lookup and address for the first time and think i am doing it wrong. SUMPRODUCT(--ISTEXT(address(7,LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245))):LOOKUP(address(7(2,1/(G5:G15245<>""),ROW(G5:G15245)-300)))) So i have a ton of stuff in coulmn G I need to find the last value that...

All, I have a data set were i do a sum product =SUMPRODUCT(--ISTEXT(F9:F15249))-COUNTBLANK(F9:F15249) the column has numbers all down it and sometimes it says null null is what i am looking for here thats what i am counting. the data set moves abd currently the last number or null value is at...

Hi all, I’m working on a simple sheet where I have a few columns. The important ones are: A = first name B = surname F = points On another sheet within the same workbook I am trying to get it to display any person who has 3 or more points. I want it to display first name, surname and points if...

Hey all, not sure how to explain this, but I'll try my best, I am looking for a formula to do the following: If A1 matches A2, then add 2 points (+2) to A3, If B1 matches B2, then add 2 points (+2) to A3, if C1 matches C2, then add 2 points (+2) to A3 If D1 matches D2, then add 2 points...

I'm trying to graph a changing amount of data, and need to coax Excel into showing only the relevant data, not blanks or zeroes. The amount of data changes on the fly (depending upon promotions, seasons, etc.) I have formulas that INDEX/MATCH the correct data, but there may be anywhere from...

I'm creating a scoresheet and I have a cell that will total the score, but I have other cells that I want to list how many points were scored in each quarter. So in the table below, E3 will have the total score of the game. After the first quarter, I want E3 to populate A1 and then stay. After...

<tbody> NAME NUMBER WEIGHT POINTS RANK JOHN 1 0.5 15 5 PETER 5 5.0 100 1 GERRY 6 CHARLES 2 4 60 2 TANK 3 6 50 3 BILL 1 3 40 4 1ST PLACE 2ND 3RD NAME? NAME? NAME? </tbody> Good day all, please assist me with a...

HI! We have a 12 month rolling attendance points policy. I have all of the formulas figured out except for we allow employees to earn points back by having perfect attendance for 30 days from their last occurance. Trying to figure out how I can add a column and formula in to automatically...

Hi there. Looking for advice on which formulas to use to determine the number days between two spreadsheets. I have one spreadsheet which contains point issuance information. On this spreadsheet the following fields are present: ------------------------------- - ID# - Transaction Date -...

Hi, Can you please help me to create a small macro to calculate % in the background and then do a summation on the sheet. Let me explain further. I have 10 pupils and they wrote 3 tests. I must now calculate the results and report on how they did per test. There are 4 results brackets and I...

I'm trying to get a formula that calculates points up to a maximum of 50 depending on how many minutes a result is. IE Cell A2 has an actual time in it Cell B2 has a guess time in it Cell C2 has a calculation which shows as points (spot on, 50 points, 1 minute under or over, 49 points, 2...

Hi, can anyone help me with a formula or VBA code to create a cumulative running total of loyalty points earned and Date stamped, which are valid for 1 year? Then when points are spent at a future date, the spent points are then allocated to the first Date stamped points in the table until the...

Thanks in advance. This is a copy of part of worksheet 1 which is a horse racing rating method: <tbody> Chelmsford City 16.45 (in cell A1) Horse Points Satchville Flyer 233 Irish Times 177 Red Cossack (CAN) 174 Kellington Kitty (USA) 143 Pass The Cristal (IRE) 138 </tbody> On...

<tbody> A B C 1 Item1 -2 Station25 2 Item2 -5 Station26 3 Item3 -7 Station27 4 Item1 -8 Station28 5 Item3 -10 Station29 </tbody> Hello, I need help please. I have been searching the internet and cannot find this solution. Column B is plotted on a chart as...

Hi, Please take a look at the image I linked below pertaining to my question. http://i.imgur.com/OagzyfM.png The above image is a spreadsheet keeping score of a sport league. The games are played on different dates and there are different players coming to different games (some players come...