I'm not sure if you calculate the percentages the right way on the dashboard (in the middle I see for instance 100% and 50% and 50%, which makes 200%)...
Agree with Anders, but as I read the question we can surely say that this is possible (either with Vlookup or with Index/Match constructions). So with...
Hi Mark, welcome on Mynda's Forum! See if the attached is what you want. I did the conditional formatting on the above part of the sheet. I made a ...
Welcome Robert at our great Forum here. Your problem has to do with your template settings and yes you can change them. In short: make an Excelf...
Well, testing yourself gives you direct the right answer for your data? Probably the direct import doesn't work. Then first export the sheet with t...
Yes, this one was downloadable. Works nice and fine Sunny. Hope this is what Paul was looking for. Frans
Can´t download or view the attached file to see your solution Sunny. Maybe a fault on the Forum, but can you try also and/or place it again? Thanks...
There is no file attached Ahmad, but I´ll give it a try. If it is text you are talking about, and every part of your example is in row 1, you can p...
Maybe with a macro you can do the way you present it. Another easy way is to make a pivot table. Put the customers in the rows and the result of...
I think your problem more has to do with the number of data where the trendline is based on. It now 'calculates' the zero's as well and so you see ...
no file attached!
Interesting case Julian. Do you have some examples on how you did it? I'm not familiar with DBCS and SBCS so have to guess what this is all about, but...
Hi Mitul, this is Frans 😉 Two things on this example, but you're almost there! 1) Your reference to cell H13 is not correct. This has to be a ...
Hope I understood your question well. See attached file with the solution and in red my explanation. I put the solution in place and not as text...
Ryan wrote: "Is there anything I can do to help support this site? The resources provided through this site are amazing!" Answer: Spread the word arou...