I think that's not possible with a normal function because of the different amounts for the MDN's. You don't know in advance how many MDN-01 and MDN-0...
Hi Mohamed, attached a possible solution: you make a pivot table from your data. In the settings of the Pivot table you fill in that every new MDN ...
This depends on the way you select and copy and paste. In your example you want to have the average B5:B11 in cell C11 I think? So in cell C11 y...
Not sure if I understand you well. In the column U to AF you now put the desired answer by hand I think? If you want in that columns things more...
It's guessing without seeing. Are they using the same Excel version (2010-2013-2016-365)? When we know, maybe there is an explanation for it. An...
I just answered on the other question about recovery file. Frans
Hi Mitul/Mike, I think the purpose of the Forum is that one askes his/her questions and somebody else tries to help with an answer. By doing this i...
Thanks Sunny, nice to get such an explanation! I did the F9 'trick' myself before asking you and it didn't make sense to me. But now I think I unde...
Hi Sunny. I see that it works fine. Can you explain the 'how and why'? Why the '2', why the 1 divided by C2:N2 (if that's what's he doing). And ...
Hi Matthew, From the data you provided I made this little example to start with. On the same sheet as the data (with some extra to show what you...
There are different ways to accomplish this, if I understand your question well. Always difficult without real examples. It sound the most easy to ...
Anders, you put me on the right track! It's easier than you're solution. I only have to color the text the same color as I want to format the cells...
Thanks for this one Clark! I tried it out. It does work, but not everytime. Sometimes you don't see the color (specially in the uneven rows where alre...
OK, good you figured it out for your settings. Strange is: here it is the other way around! So must have to do something with localised settings of...