point

  1. P

    Summing the number of times a value occurred, into a percentage

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

    Line graph with different colours depending on criteria

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

    Formula Based Scoring Time Between Two Dates

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

    Change linked worksheet based on cell value

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

    Mph/eta

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

    Nearest point

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

    Excel coordinate pointer on line graph or curve.

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

    Need help creating a formula

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

    Chart Query

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

    Missing Formula Bar Functions

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

    Looking for a tool to produce documentation when your Workbooks get out of control

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

    Subtract last value in the row.

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

    How to fix the address of a cell that is returned by a function?

    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!
  14. A

    How to set Share Point 'ContentTypeProperties' at generating pdf in (Excel) vba

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

    Sumproduct

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

    Frequency question

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

    Sort/Remove Duplicate Macro

    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!
  18. I

    Match, sort and count numbers

    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)...
  19. K

    Point a formula to a OneDrive Location?

    =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...
  20. C

    Awarding Points on a Scale

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top