See also the example in:
Since you're saying "And the problem exists in all Excel files on this computer". I think something might be wrong with the printersettings on the com...
I'm with Sunny here, also for the technical reasons Anders describe. If you don't know how to use the Vlookup in this case, I made an example. G...
Not sure if I understand your problem well Lea. I see two different things. In the print1 picture I see the file will be printed on lot's of pages. An...
Sorry Anders, we were answering same time I think so I didn't saw your post until I posted mine. Frans
Hi Mrashant Manjrekar, welcome to Mynda´s Forum. I think when material has arrived it makes no sense to have a number in column F, right? Maybe a t...
You also have ´BH´ in some cells. Don´t they have to count as well? Frans
In addition to Mynda´s advice I would say: practice, practice, practice! I hope you have a working place where you can use Excel, because that'll h...
Sorry, but don't see an attachment? Frans
Thanks Anders. Actually I didn't write the formula. Just clicked on the total of the right pivottable. Excel gives you the proper formula back. You ca...
Here are my examples, maybe it helps, don't know. Frans
Hi Anders, I'm not sure if I understand what you mean in the sheet by 'adding data'. I suppose extra rows with data in the columns A-C. When I do t...
Yes, same to me: I am cautious about working with VBA. Despite following some courses (didn't finish yet). So I like it when with some easy adjustment...
Nice and elegant Sunny, as always! Frans
Hi Sunny, I was working on this, but couldn't get the right idea about ordening the data. Your helper column 'Sequence' and the formula in it are very...