points

<style><!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:" ";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr {mso-height-source:auto;}col {mso-width-source:auto;}br {mso-data-placement:same-cell;}td {padding-top:1px...

I have data that was created every 100 or so milliseconds over 5 minutes (about 3k data points). I want to average all data within a length of a second into a single data point. Here is an example of the raw data vs the desired data. There isn't a consistent amount of data points for each...

Hi All, I'm using the below table for as a lookup. This works fine. My question is I would like a column that tells the pupil how many points from the next grade? For example a pupils scores 1341 which equals a MPP grade. They are 38 points from a MMP grade. How do I do this in a formula? 0...

Another day another plea for help :) I have a spreadsheet with 255,398 rows. Each student has anything between 5 to a 1000 rows, however, not each row has the student's details. So the table (in a very simplified form) looks something like this <tbody> Surname Forename UPN Achievement...

Hi, I've got two columns where I need to make sure that the order respects: 1 - The large value from column A5 to A10 (Total differential of runs scored) 2 - The large value from column T5 to T10 (Total points awarded for a win) The issue that I see with the current Large(Array,k) is when...

I have a spreadsheet that is calculating a price per square foot of a building. The cell is formatted to Accounting with 2 decimal points. This is what is should be based on my calculator tape 52,000 sf x $61.68 = $3,207,360 This is what the cell multiplication tells me 52,000 x $61.68 =...

I had a hard time thinking of a good title for this since it is hard to explain. here is what I am hoping to achieve... There are four individual games that are each worth a point. If someone wins the game, then they win 1 point. If nobody wins the game, then that point "carries over" and...

I am sure my title is not correct on what I need to do. OK, I have a spreadsheet (work book) that has 2 sheets in it. Points has city and miles. <tbody> <tbody> Points Miles MEMPHIS TN 13 GERMANTOWN TN 18 BARTLETT TN 22 CORDOVA TN 24 COLLIERVILLE TN 27 MILLINGTON TN 29 EADS TN...

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

I have an OHLC stock chart with candlesticks -- it works well. Now, I would like to add occasional price entry and exit points to this same candlestock chart. I have five columns of data, Date (for the labels), and then the OHLC prices. I have added two additional columns for the price entry...

Hi, I have huge data which has lakhs of rows in excel I want get the reward column to be filled automatically by using formula. 1. If a customer earns 225 points in any Quarter he will get Mango. 2. If a customer earns 450 points (225 points any qrt+ 225 points any qrt) in any 2 Quarter he...

Hi all, Looking for some help with a formula that allocates 3 points for a predicting Home Win, Away Win or Draw, but also allocates 6 points should the person predict the correct score, in the instance below Susan predicted 3-3, which was correct, in turn gets a total of 9 points, 3 for...

Is it possible to add additional range value in the same graph points? For example in the second plot (1, 107.6) (8, 107.6) (7,105.6).. so on instead of the first figures 1,8,7, I need to plot data from a different range: 300, 250,250... so on So the result should be (300, 107.6) (250...

Ok, so I am creating an attendance sheet and I have it looking up the employee's # of points and letting it dictate by vlookup what level write up that employee is on. The catch is, if a employee has a no call no show they receive a point (like an absent) but also a right. Excel gives them the...

Hi guys, I am new to the whole VBA side of Excel and have hit a wall which requires superior knowledge. What I am trying to do it create a 'log' sheet so that i can record which cells are clicked and at what time they are clicked. Consider this like a scoreboard for basketball. Everytime the...

<tbody> <tbody> RED CONFERENCE SEASON TOTAL WIN LOSS WIN LOSS 1 2 3 4 5 6 7 1 Richards 2 0 2 0 1 7 6 5 4 3 2 1 2 Argo 1 0 2 0 2 6.5 5.5 4.5 3.5 2.5 1.5 2 Shepard 1 0 2 0 3 6 5 4 3 2 2 Evergreen Park 1 1 1 1 4 5.5 4.5 3.5 2.5 2 Reavis 1 1 1 1 5 5 4 3 6...

Hi everyone, I am looking for some help. I have to manage points and pay for a racing series and I'm trying to create a workbook to help me keep track of everything. So this is how I'm going about it so far. If you think I'm on the wrong track, please make any suggestions I am just a novice...

Hello all, I have an odd inquiry. I have a spreadsheet that contains cells that have multiple data points in them. Most of them look like this 120+120+60+50. This gives me a great total, but I am wondering if there is a way to find out how many entries there are in each cell. For instance...

Hi everyone, I am having a margin/ruler/scale issue. I had a bad macro that broke and now I can't get the exact format back in my workbook. When I look at the sheet in page layout view, my ruler is at different points on the page between the good layout workbook and the bad layout workbook...

Hi, Is it possible to have those data points that fall above the trend line one color and the data points that fall below the trend line a different color? Thank you.