tracks

  1. S

    tracking progress through multiple sheets

    hi guys, i need to write a function that tracks progress of a particular invoice through different sheets. I have a main sheet that should show numerical values of 25, 50, 75, 100. My function works with 2 sheets but if i add on more than that it fails the formula for 2 sheets is...
  2. F

    Count the number cells that have been conditionally formatted in a cell range?

    I have a worksheet that tracks leave taken. Cells in the range D4:Q29 fill with RGB,251,191,143, when it is <today. The range covers a 2 week pay period, therefor a 26 pay period year. I am trying to write a formula that counts the number of days till the last day in the last pay period, minus...
  3. J

    graph only part of a data table

    I have created a data log in excel that shows all of the changes that have been made in my workbook. How would i create a line graph that just tracks the changes in some of the cells, that also automatically updates when one a change is added to my log? Thanks.
  4. C

    Need an formula to track the number of draws a value follows another value.

    The formulas in columns Q2-T5 tracks number of times the values in column U and V1-Y1 have followed the values in in columns V1-Y1. Formulas in Q7-T10 tracks skips. I am not sure if sure if values are correct because of the formats of the value as 2-digit values...
  5. H

    Calculating W/L - multiple tracks

    Hi, all, Trying to find a way to explain what I need so bear with me. My daughter and I have setup 2 marble tracks. We have 5 sets of colors marbles and we want to have mini tournaments (seasons) racing the 5 different colors over 2 tracks. It is very easy to calculate the W/L as a total...

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