pts

I have a sheet that represents a score card for a sporting event. Row 3 contains the dates of the game, row 4 contains the day of the week and row 5 contains a ‘points’ heading. The remaining rows contain the scores of the games and the team name For example. Row 3 contains 01/01/19...

Hello, Below is a championship table for the model cars that I race. There are 4 championship rounds - Coulsdon, Roedale, Haydon & Pinewood and I would like a formula in the last column where it currently says #NUM ! that shows the best 3 results only - we are yet to race at Pinewood, but I'd...

I have used this code before and it functions fine. I want to modify it for another use. original code {=IFERROR(INDEX(Entry,MATCH(1,(B56=Div)*(B57=Model)*(MAX(IF(Div=B56,IF(Model=B57,Pts)))=Pts),0)),"x")} I no longer need "model", so I thought I could just removed it, but it's not...

Hy guys need help on a tricky one, i guess <tbody> TEAM 1 21 X 18 TEAM 2 TEAM 3 15 X 21 TEAM 4 TEAM 1 16 X 21 TEAM 3 TEAM 2 21 X 16 TEAM 4 TEAM 4 21 X 16 TEAM 1 TEAM 3 21 X 12 TEAM 2 </tbody> I now need to rank them, this is what i have so...

To all those who have helped me in the past with the excel sheet I'm making, thank you. I just made a few tweaks to make my other tables work better so some of the stuff you showed me dose not work. This is my standings sheet <colgroup><col width="70" style="width: 53pt; mso-width-source...

Hello! My name is Jenny and I am working on some code that will insert 6 rectangle shapes based on corresponding length and width values that are in 12 separate cells. I got the code figured out to do this, but the calculation doesn't seem to 100% be working. I realized that VBA reads things...

Hi There, I'm putting together a performance appraisal form with checkboxes. Picture tasks down the vertical, and checkboxes across the horizontal in a chart format. There are 7 rows (tasks), and 5 columns (rating points from 1-5). My grid looks like 35 checkboxes, with only one possible...

Hello all, Here at work, I need to figure out how many more PTs are needed to reach the target goal of 15%. What formula can I use in order to get the amount without figuring it out myself. Any help is greatly appreciated. Thanks! <tbody> PTs WELDS PTd % GOAL % PTs NEEDED TO REACH...