It can be done much more effective than this 'quick one', but maybe when you've got the point you can improve it yourself
I'm afraid this can't be done with a simple formula. The data is too unstructured to say so. In the past I sometimes got these kind of data and tried ...
Thanks Sunny! It are the most easy things that sometimes don't come up..... I started with the copy-paste and that's not the trick here. Maybe that's ...
For the record: this also can be done 'by hand' of course with copy or moving the sheet to one file and place them in the order you want to......
Did you try making an Excel table of it? (select data, tab insert, button table (on the left)). And after that you can either choose your colorstyl...
Can be lots of things. I was thinking of: check if the file extension indeed is .xlsx and if not try rename it and open it again. If you open in Windo...
First I didn't do it myself, it's a question somebody else asked me. And yes: I think the way it looks is the same (see attachment). I suggested...
Thanks Sunny for this reply! So we think it's possible. What can be the fault, because it doesn't seem to work? As far as I know now there are litt...
In my example (shown above) you see only Lisboa when you filter on Portugal.........
Maybe first make a kind of conversion table and then with Vlookup search for the right multiplier?
Well in fact it is working correct I think. The outcome (28) is correct. So it has to do something with the way you present it. When I make a 'n...
Think I solved the problem (at least for this case and this moment). I'll probably come back on it later (after this project ends, end of the month), ...
One other thing I thought of (but didn't had the change to verify): can it be that I created my own trouble by first making the get pivotdata formula ...