Forum

Hans Hallebeek
@keebellah
Reputable Member
Joined: Oct 17, 2018
Topics: 8 / Replies: 365
Topic
Reply
RE: Average lowest x values in a column

How true, blind spots pop-up out of no where

2 years ago
Reply
RE: Grab value based on dynamic column selection with an offset

Hi Greg, Sorry for the delay but the is is as follows. If you check the worksheet named Basic Report you might see what I have tried to explain (I'm n...

2 years ago
Reply
RE: Need Formula help please!

You count use the COUNTIFS() Function to do a count on the project and two criteria checking the start and end date To make it easier I suggest you...

2 years ago
Reply
RE: How To Change An Integer Entered In Cell (C5) While Still Keeping Your Formatting Written In VBA

I do not see what you want to achieve with all the extra codelines in Module2. You can do this with conditional formatting

2 years ago
Forum
Reply
RE: Slicers lose formatting - all data is greyed out

I checked and what does indeeed surprise me is that the slicers are greyed out but do work as intended

2 years ago
Reply
RE: Slicers lose formatting - all data is greyed out

I see what you tried to achieve, so much is clear. When I open the file (Excel 2021) I get the error message that a relationship between tables may...

2 years ago
Reply
RE: How To Change An Integer Entered In Cell (C5) While Still Keeping Your Formatting Written In VBA

Hi, I think I know what you're trying to do but you should keep in mind one important thing. You have hardcoded Italian function names in your macro (...

2 years ago
Forum
Reply
RE: Slicers lose formatting - all data is greyed out

Well, it seems the file is 'greyed-out', no just kidding, it's not even there just two images

2 years ago
Reply
RE: How To Change An Integer Entered In Cell (C5) While Still Keeping Your Formatting Written In VBA

Well, your macro does not work, we do not know what your Data is in "=data(A2;A4; 1)" and your expalnation is very unclear. I suggest you to add...

2 years ago
Forum
Reply
RE: Grab value based on dynamic column selection with an offset

Give me a moment and I'll try and put my idea in the file you attached Can I assume that the basic report (yours) is the Comparison sheet with the ...

2 years ago
Reply
RE: Slicers lose formatting - all data is greyed out

Maybe a picture tells 1000 words but without a sample file to determine what you're doing, well, that's a different story Suggest you attach a samp...

2 years ago
Reply
RE: Grab value based on dynamic column selection with an offset

Hi Gregg, I paly around with similiar issues and different sources which need to be placed in the one single table. What I did and I hope I can ...

2 years ago
Page 16 / 25