Hi, I would like your help to solve an issue for me:
When I have a wide range of data (in columns, say from A to X) and I only need the values in columns A and X, how can I then avoid to include the whole range of data in the pivot table range? (As is: Range A:Z. Would like: A:A Z:Z).
Thanks, that's also my experience. I hope that MS some day will make the input range more flexible. Large range slows things down and adds only more kb/mb to the file size ..
Eller du kan bruge: funktionen der på engelsk hedder HSTACK.
Synes godt om
1 synes godt om dette
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.