-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
19/20
-
E
Chart Help - 1 stacked column into 3
Hi I have been periodically creating a stacked column chart. This now has been divided in 3 sections and so the chart has to follow! I'm sure this should be really simple but I just cant seem to manage it. I eventually got it split into 3 by transposing the data but now I am missing P6 from my...- esmecat
- Thread
- 19/20 chart open overdue total
- Replies: 8
- Forum: Excel Questions
-
Data Validation List help
Hi all, I have a table with to Data Validation drop down lists. Business Area Financial Year Budget Name I need to create some sort of cascading drop down list from this table (data is added to this table all the time) <tbody> Business Area Financial Year Budget Name 1 18/19 General 1...- wrightyrx7
- Thread
- 18/19 19/20 business general list
- Replies: 6
- Forum: Excel Questions
-
J
Adding Numerators from fractions
I am adding numerators from fractions and currently using this formula: =SUMPRODUCT(--(LEFT(0&I35:I38,FIND("/",0&I35:I38)-1))) <colgroup><col></colgroup><tbody> 25/20 20/20 19/20 19/20 </tbody> 83 I want my formula to cap out at the denominator however, for example on my first cell IF...- JrayK2
- Thread
- 19/20 denominator formula fractions numerators
- Replies: 4
- Forum: Excel Questions
