Forum

Paul Benjamin
@benjamip
Estimable Member
Joined: Jul 11, 2017
Topics: 32 / Replies: 57
Reply
RE: Filter between Positive & Nagative numbers

Thanks Riny, I thought that was the case, just wanted confirmation

4 months ago
Reply
RE: If & CountIF

Thank you Saliha.

1 year ago
Topic
1 year ago
Replies: 3
Views: 95
Reply
RE: Average IFS Error

Hi Velouria, I have attached an updated the attached sheet, When I add in all other services the old formula (cell C185) returns an average of a...

2 years ago
Reply
RE: Average IFS Error

Thanks Velouria, I'm away at the moment, let me try this when I get back, will confirm all OK the, Regards Paul

2 years ago
Reply
RE: Average IFS Error

Thanks Riny & Velouria @Velouria: the formula works but gives me the average of all 2382 rows, I need to know the average for each of the ...

2 years ago
Topic
Replies: 8
Views: 69
Reply
RE: Pivot Table Query

Thanks for your help, all sorted now. Regards Paul

2 years ago
Reply
RE: Pivot Table Query

Hi The data for Ibis Swansea on row 70 on the 'Sites & Groups' tab, should be feeding through to the 3 tables on the 'Report' tab, but 'Ibis Sw...

2 years ago
Topic
Replies: 4
Views: 147
Reply
RE: Index/Match which is best to use?

Thank you, Riny, I did not know you could use SUMIFS for this type of query, you never stop learning. Regards Paul

3 years ago
Topic
Reply
RE: Navigate to Selected Pivot Table Site When using a Hyperlink

Thank you so much for your help Catalin, Sorted, I would not of thought of that solution, Regards Paul

3 years ago
Forum
Page 1 / 6