Search results

Hi I have a set of charts with titles that appear to have lost their dynamic links. They link to cells on a separate sheet. has anyone had this issue before and know how i could fix this? Currently each week on a Friday i go into the workbook, and restore the links individually (approx 50...

I am not sure i understand your problem correctly - would the =SUMIF function help you?

No worries Kim, yes it pays to keep it to minimal / simple change where other people are the primary user. Have you tried adjusting your initial formula to the following: =IF(OR(C4="D01",C4="D08"),IF(OR(C4="D01",C4="D08")*AND(I4<50),I4,50),"") that may eliminate the helper column

Hi Kim The way I would approach this would be to use a helper column. There is probably a way to do this all in the one cell, but i find helper columns a good way of seeing the in-between steps. Try this: 1. Create a lookup table of all of your twenty (approx) codes out to the side or on a...

Hello I have a scatter plot that I prepare monthly, comparing our supplier performance across two variables, both in percentages - a quick way of identifying our poorest performing suppliers. The trouble is it can get quite messy in that there can be approx 200 suppliers on this chart each...

sorry, rushing, got my letters mixed up in the formula. Replace with: =if(and(a1=1,b1=5,c1=11),"Yes","No).

Hi There This might be a work around, but is relatively formula and method to follow (for me anyway): I would firstly create a helper field in the next available comlumn (I assume column D, titled "Yes/No Flag") using the following formula: =if(and(b1=1,c1=5,d1=11),"Yes","No). Then you can...

Hi Narayan Yes it is a strange problem. After ticking the "Don't Move or Size with Cells" option it seems to have solved the problem for myself, however the problem appears to still prevail when other users have been in the spreadsheet. I wonder if alternative versions of Excel have something...

Hi there Jaefo the answer to your question could be as complex or as simple as your project is i guess. To clarify, are you after a simple sum of the individual task durations? Or are you after techniques for visualising the project timeframe? Chandoo has a Project Management course coming...

In addition to my post above, if your data runs across multiple years, then you can use the formula =year(A1)&" "&month(A1) to identify the year also. Could use this instead of the month formula suggested above.

Hi There An alternative suggestion so you don't have to change your current data is to insert a new column with the formula =month(Cell reference), linking to your date column. This would mean that you can keep accurate records of which day the sale occured while still summarising by month...

Hi There I am revisiting this post as the above fix appears not to have resolved my issue. The chart titles are still reverting back to their initial font size (way too big). All of the charts have the "Don't Move or Size with Cells Option" ticked. Any other suggestions I could try? The...

Hello - I have a similar problem that I am working with. Robert, did you find a solution in the end? I am not sure if it is appropriate to post an extension question on an existing post so please advise if I should start a new one... For application to my particular problem i want to have a...

Thanks Hui, that seems to have worked at this stage. As an aside, I wonder what the solution would be if I only had 1 chart, as "Size and Properties" appears to be only accessable when multiple charts selected?

Hello I have a large number of charts, of which the titles are driven via a formula linking to their relevant cell on a separate worksheet. For some reason, the titles have decided to default themselves to size 18 font rather than my desired size 12 font. This means that every time i reopen...

thanks for everyone's thoughts, very helpful! cheers rob

Sorry I will repost the above soultion so the columns line up..... 0 1 2 3 4 5 6 7 1 a b c d e f g 2 a c d b f g e 3 b c a f d e g 4 b g d e c f a 5 c g a b e d f 6 c X g d f e a 7 X X c e d g f 8 X b g f c d e

Hi Yes Narayan that is correct. As mentioned initially it is your 2nd constraint that seems the most difficult part. Mike - yes it would look something very similar to that. Although if i text-to-columns correctly there are 13 issues with that solution. My closest solution so far is as...

No sorry, I will try and explain it a different way. What I didn't mention at the start is that there are limited resources, i.e. only one Chess Board, only one Draught board, only one Poker Set, so you can only have two teams at this venue at one time. So round one would look something...

Hi My name is Rob from New Zealand. I am working as a business analyst and i use excel often for a whole range of things. This site is great - i have picked up lots of tips and tricks since i found it earlier in the year. I have especially enjoyed learning about and trying to develop...

Hi There Try referencing cells holding the dates rather than inputting the dates directly into the formula - I get 15 when i do this. hope that helps Rob

Hi Narayan Thanks for having a look. All are correct except the 4th constraint which I would restate as "No team can play the same game (i.e. at the same venue) more than once per tournament". I want each team to play each game once, but not more than once. And each game has a fixed venue of...

Hi Everyone I have a problem regarding a sports tournament schedule that I was hoping someone would be able to help with. My constraints are: -8 teams -Each team needs to play all other teams once (and only once), i.e. 7 games each = 28 games for the total tournament. -7 rounds (i.e. 4...