Hi Sunny, I see it works, but can't figure out why it works? What does the 'isnumber' while nothing is a number?? Maybe you can explain in norma...
Hi Hitesh, Maybe you look for something simple like this example? Frans
In WIN10 go to all settings. Choose 'Apps'. Choose 'Standard Apps'. Scroll a little bit down and choose (in Dutch, think that is what you are and see?...
Hi Dick, Just now saw your post of some weeks ago. I managed to download your zipped file and unpacked it. I'm not sure if I understand you wel...
Hi Mohamed, Can't help you with all three questions, but fixed the last one. @Anders: I think he is looking for formulas and that's why they can't ...
Thanks Anders, this explains a lot to me! Frans
Do you know if there are differences in language versions, regarding to these update schedules? I thought the localised versions also had a different ...
Hi Paul, did you try ´Getpivotdata´ to get the right information from the pivot table? Frans
Hi Jay, do you want all the data in just one table to use that as a reference table or such? Or do you want to have a kind of lookup through this d...
Hi Anna, I made an example to check if I understand you well. See this Excel sheet. If this is correct, you can make some differences but you al...
Maybe you're looking for scenarios? You find it here on MOTH: Frans
I´m afraid your data is not consistent for what you want, seeing your xlsx-file. In your sheet2 under header 2 you have more than one value for eac...
I tried some other solutions in the pivot table itself, but encountered the same issues. So maybe it's indeed something that can't be solved this way ...
It looks like somebody wants you to learn some basic Excel by doing this. Asking for help is one, but asking for doing it for you is something else, I...
Since there is no attachment I can't show you, but you can ungroup this in the pivot table. Somewhere on the ribbon you can find this when you select ...