segments

  1. J

    Coloured segments on a spider plot

    OK, I'm a long time reader of MrExcel, great resource, but this has me stumped and I can't find anything here. How do I make a spider plot with filled in segments of different angles? What I am trying to do is make a spider plot for data which has 18 categories, called M1 through M18, in Office...
  2. V

    Determining number of segments based off time

    I have a sheet that I have taken seconds and converted it to minutes. simply took the seconds / 60 to get a number. Need to determine based off those minutes how many 30 minute increments there are in a given number. For instance 66 minutes would be 3 segments. Any help would be greatly...
  3. W

    Finding Count of Groups of Data in a Row

    Hello all my Excel Gurus! I want to count the number of segments, or groups of data, in this array. The results should be 3. (I think I might have to add zeros in the blanks) <tbody> <tbody> 20 85 65 65 20 22 </tbody> </tbody> Then add one more step into this. If I had...
  4. A

    How can I divide amount in proportionally in two segments?

    https://drive.google.com/a/writingline.com/file/d/1TLHGZw3XuXqn3CkziIjqDFwhjeaccopc/view?usp=sharing Here you can see an example of what I want to achieve. Please let me know the simplest way to divide the value? Thanks
  5. G

    Power Query Add Column w/ Lookup from a Different Table

    I have a sheet now where I created a conditional column which required me to enter the data manually. I'd like to be able to this with Power Query grabbing the info from a separate table. Example Code (Now): #"XX Create Segments" = Table.AddColumn(#"Sorted Rows", "Segments", each if...
    • gimmeexcel
    • Thread
    • column custom segments table text.contains[keyword]
    • Replies: 1
    • Forum: Power Tools

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