segment

If you need to ascertain the radius of something circular and all you have is a segment, you can use this spreadsheet to do so. Just take two measurements and put them into the two cells and the spreadsheet will reckon the radius, as well as some other trigonometric stats. Here is a photo of...

Hello All, I'm looking for a way to conditional format each segment of a line chart. Basically, if the segment is positive (from a lower point to a higher point) I want to the segment to be green. If the segment is negative ( higher point to a lower point) I want to the segment to be red. Any...

I have a table that has a bunch of =SUM()/CALCULATE Calculated Fields. Items like: Total Gallons:=SUM(MasterData[Net Quantity in GAL]) Total Gallons YTD:=CALCULATE ( [Total Gallons], DATESYTD ( MonthOnlyDateTable[Date] ) ) etc. for the usual financial metrics I created a pivot table to list...

Hello, Can anyone show me how to write a formula that will find the MEDIAN of a group of numbers in one column related to specific criteria in another column? My business segment name data is located in column T and my days open numbers are located in column U. Below is the formula I've...

I am trying to develop a countdown timer that will countdown multiple segments from a Worksheet and keep track of the total countdown time. The following code works for the first segment, but when I read the second segment, my time starts counting by two, when I reach the third segment it...

I have a long column of dates that I want to segment by year. For example, =IF(AND(C2>=8/1/2018,C2<=7/30/2019),"2018-2019",""). This will give me for one year, but how do I write the formula for say a 10 year span of dates so that 8/1/2017<>7/30/2018 will then give me 2017-2018, etc?

Any one knows how to use VBA to get the coordinates of two endpoints of a line segment in a worksheet? Million thanks.

I want to assign a value segment to a range of values I have, the value segments and criteria are shown below. Would filter and manually adding these be the best way to do this? Or is there a formula that would work better? <colgroup><col><col></colgroup><tbody> Value Segment Criteria 500...

Hi I have the below progress bar which goes from 10% to 100% changing every 2 seconds and runs in the status bar. This works fine.. I run 12 main macros that need the progress bar to run and each macro will have a variable amount of records to process, and changes each time I use the...

Good Evening, I have my coding complete, it works but it's a little sluggish and slow. I'm thinking it could be improved so I wanted to share in case anyone is able to assist in the clean up. Thanks! Sub FuturePDI() Sheets("Property Segment Data").Range("B2:I18").Clear Sheets("Property...

Hi, I have a simple 2 segment pie chart (Chart 33) located in a wksht named 'Results'. Its source data is in cells AH3:AH4 (percentages) in a wksht named 'Data'. AH3 contains the result, eg.65% and AH4 balances it to 100% (eg.35%). When AH3 is less than 50% I would like it's segment to be RED...

Hi all - I am trying to create a multi tiered donut chart and keep getting labels repeating in each tier as shown - Would anyone be able to advise what I might be doing wrong. I would also like to be able to change the colour of each segment based on it's value. I assume I will need a macro...

Book1ABCDEFGHIJKLM1IDTechnologyPowerEnergyIDSegment 1Segment 2Segment 3Segment 4Segment...

Hi! I have a problem creating a formula for a dynamic column in my database. A condensed version of the table below. What I want is a formula that checks if there are any shared ranks (same ranks) withing a segment, and if there is, put a star (*) infront of that rank. In my original table...

I have a strings of data that often look whats below, I can isolate the first segment and the last segment...but I can't get the middle segments. The number of spaces can vary and it's turning out to be a nightmare. Forums/Google haven't yielded results (I may be looking for the wrong thing)...

The Right function in below formula pulls two digits from a string in G2. G2 = 282110ZOCT08 in the example the last two digits "08" represents the year 2008 =CONCATENATE(LEFT(G2,2),"-",MID(G2,8,3), "-",RIGHT(G2,2)) this results in: 28-OCT-08 I want to add 2000 to just the last segment so it...