point

Hi, I've got some data which is assigned to a raw value, eg: Strongly Disagree = 1 Disagree = 2 Neither Agree nor Disagree = 3 Agree = 4 Strongly Agree = 5 Lets say my raw data is as follows: Data point #1 : 2 Data point #2 : 3 Data point #3 : 2 Data point #4 : 1 Data point #5 : 5 For...

Hi all. I am looking to use a line graph to show momentum changes in a tennis match. I have a column showing momentum change ( +1 whenever player A win's a point and -1 when player B win's the point). I have then used an IF function so show when player A wins the point but show NA () when...

Hello all. My work is instituting an incentive plan to encourage overtime when needed. They decided on a point system where you earn points for each hour you work of overtime. Each hour of each day may be worth a different point. As an example: Working 6:00 PM - 7:00 PM on Tuesday would be 1...

Hello, I am trying to point excel workbook 1 to a worksheet in a linked workbook 2. basically the worksheet name changes and I need to update all the formulas that point to that worksheet on a weekly basis. Is there a way to automate this? i.e. in workbook 1, I have the formula...

Trying to create a spreadsheet which tells me the ETA to a destination but also gives the MPH based off of passing a certain point. The mph and eta to the next location would update based off the actual time entered for the previous location passed. If I were going a distance of 6150 feet which...

So, I have 3 sets of 50 point with x and y coordinate. Each set start from origin (0,0). What I must do is arrange all the points so that 1st point and 2nd point is nearest compared to 3rd,4th and 5th point. After locating 2nd point, I must then find the nearest point to the 2nd point. And so...

Hi all, I'm pretty new to excel and I'm trying to achieve something I think I've seen done before. I have a normal line graph in excel with data points. These data point are specific to the data i entered as the x and y values to make the graph. What I'm trying to do is identify a point on the...

I have created an attendance tracker. We recently implemented a point system. I need to create a formula that will allow me to subtract one point when the date of occurance has reached one year. Example: Employee calls in on 10/18/2018, acquires a point for the call in. The point will stay in...

Hi On a line chart, how I do put a green ball next to each data point ? Thanks kind regards Kaps

Lately I have been experiencing an issue with my formula bar that doesn't appear to have been picked up or questioned anywhere else. Essentially what is happening is that on some spreadsheets the insert function button and cell number/coordinate box are missing and the formula bar extends the...

Sometimes a workbook is born and evolves without a documented design--it can gain traction and become a trusted asset. But then a point can be reached where making changes becomes challenging and real improvements/simplifications very time-consuming. Having some sort of "tool" that could create...

Hello All, I am trying to get an excel formula to get result in row#2 based on the value data in row#1. The first value in row#1 is always equal to same value which is 5, following the next number, which is 16, the result must be 16-5=11, and scanning through the next value is 20 subtract the...

Hello! I want to use a function that utilises a range, such as =ROWS($H$8:H8) where the starting point of the range is fixed. How do I do that if the starting point is returned by another function? How to make that starting point fixed? Thanks!

Hi, I have used VBA to generate a pdf of an Excel worksheet. The pdf is saved at a Share Point site. Share Point settings require document properties to be able to group the files. For saving an Excel file the Share Point, the file properties are set with...

Hello, I have the following formula which I can't get to work. Have tried and tried and tried again but to no avail. All of the cells come back as Y, indicating it is FALSE which is not the case. Is anybody able to help point me in the right direction? Ta much...

Hi all, Apologies in advance for the excessive post, but hope it makes sense. I am in the process of analysing a tennis match. I would like to look at how many times a player wins just 1 point at a time, 2 points in a row, 3 in a row 4 in a row and 5+ points in a row. From my raw data is have...

I have about 20 columns of unsorted data, and I'm trying to record a macro that sorts (a-z) and removes duplicates without "expanding the selection". can someone point me in the right place? i searched but was unable to find. thank you!

Hi, I am using the formula below which works great - up to a point. After 21 cells it just repeat the last cell details. Anyone who can assist please. {=INDEX($R$353:$R$498,MATCH(SMALL(IF(COUNTIF($U$402:U403, $R$353:$R$498)=0, COUNTIF($R$353:$R$498, "<"&$R$353:$R$498), ""), 1)...

=SUBSTITUTE(REPLACE(CELL("filename",C1),1,FIND("]",CELL("filename",C1)),""), "_test","") Hi guys I have this formula above here ^ which I use, to take a part of the name, from the worksheet name and display it in a cell. I upload this document to my MS OneDrive. I'd like to use this document...

Hi Excel newbie here and would appreciate any help someone could give. I am trying to take points away (max 100) for exceeding a target value Lets take the example a service loading The team have a target of 350 (milliseconds) anything under that time gets you 100 points automatically...