Forum

John Fazio
@gfaz
Eminent Member
Joined: Jun 7, 2019
Topics: 6 / Replies: 21
Reply
RE: How to create a Visual Basic to highlight cells when the value changes

Hi This is great. I'm wondering if it's also possible to clear the cell fill if the user decides to revert back to the original value? Thanks f...

4 years ago
Forum
Reply
RE: How do I add a feature to unhide tabs

Hi Purfleet, I just noticed that after I select an option and I begin filling in the fields on the main Bidder Profile tab that the select tabs hid...

5 years ago
Forum
Reply
RE: How do I add a feature to unhide tabs

Good Morning Purfleet, This is very helpful. I greatly appreciate your guidance. Thank you! John

5 years ago
Forum
Reply
RE: How do I add a feature to unhide tabs

I haven't had success. Please see my file. Thanks for your guidance.

5 years ago
Forum
Reply
RE: How do I add a feature to unhide tabs

Here is the current layout of my file (see attached)

5 years ago
Forum
Reply
RE: How do I add a feature to unhide tabs

Thanks Purfleet, I'd like to use the buttons as well. How would you go about it? Thanks

5 years ago
Forum
Topic
Forum
Replies: 9
Views: 48
Reply
RE: Calculating average hour by day with a Pivot Table

Sorry Mynda, I can't seem to get it to work out. Here is my latest attempt. I'm also missing the part of using "Int64" and I'm not sure ho...

5 years ago
Reply
RE: Calculating average hour by day with a Pivot Table

Hi Mynda, I added the column but I'm coming up with the proper outcome. I've attached a screen shot for you to see as well as the following edit...

5 years ago
Reply
RE: Calculating average hour by day with a Pivot Table

Mynda Treacy said Hi John, I'd use Power Query to calculate the 'Minutes from Last Ticket' and then you can use the PivotTable to average. See Sheet...

5 years ago
Topic
Forum
Replies: 1
Views: 75
Reply
RE: Calculating average hour by day with a Pivot Table

Hi Mynda, Sorry another question, how do import more data so that it matches the current file layout?

5 years ago
Reply
RE: Calculating average hour by day with a Pivot Table

Thanks Mynda, I appreciate all your help. I signed up for your Power Query course to help me better understand the application. John

5 years ago
Page 1 / 2