Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jul 24, 2026
Topics: 61 / Replies: 1590
Reply
RE: Formula to identify data not in sequential order

Hi Helen, No file attached! What version of Excel are you using? regards Phil

6 years ago
Reply
RE: Power Query Error

Hi Charmi, Welcome to the forum, but please read this I moved your qs to its own thread rather than leave it tagged on to a resolved qs from over...

6 years ago
Forum
Topic
Forum
Replies: 1
Views: 803
Reply
RE: VBA userform Commandbutton1 shortcut key

Hi Steve, What you're trying to do isn't totally clear and without your workbook again I can't see any code or the form. Why not just create a s...

6 years ago
Forum
Reply
6 years ago
Forum
Reply
RE: QC LJ charts

Hi Amel, Please see the attached workbook as a starting point. Once you've calculated your Mean and SD it's straight forward to calculate 3SD, 2SD...

6 years ago
Reply
RE: (If) Function

Hi Amel, Try this = IF(N5="Alinity hq I (173)","Amel Al Faris", IF(N5="Alinity hq II (198)","Amel Al Faris", IF(N5="Sysmex 2500","Moneer"))) ...

6 years ago
Reply
RE: VBA : The color of the shape (country) doesn't change accordingly to the value in a cell

Hi Damien, When you are attaching files to the forum you are attaching XLSX files which cannot have VBA code in them so each time we have to add th...

6 years ago
Forum
Reply
6 years ago
Forum
Reply
RE: ANDing 3 criteria

Hi Bruce, Welcome to the forum, can I please ask you to review this I'm not really sure what you are asking. As Mynda already told you in emai...

6 years ago
Forum
Reply
RE: VBA : The color of the shape (country) doesn't change accordingly to the value in a cell

Hi Damien, Can you please explain exactly what it is you are trying to do? I'm not clear if you are trying to colour in all countries at once, or ...

6 years ago
Forum
Reply
RE: VBA : The color of the shape (country) doesn't change accordingly to the value in a cell

Hi Damien, If you can attach your workbook I can write something specific for you but without it I can only give you something generic like this us...

6 years ago
Forum
Reply
RE: Filter Syntax error

Hi David, We don't know how you intend to use the data so before you go writing VBA, why not use filters as Purfleet suggests? See attached. ...

6 years ago
Reply
RE: Can you use the "Show report Filter Pages" when using Power Pivot or Pivot with measures

Hi Declan, Create a PT = Create a PivotTable. If your dummy workbook can have a PivotTable with the same fields/structure-visualize-data as the re...

6 years ago
Forum
Page 66 / 111
0