|
|
|
|
#1
02-09-2019, 11:23 PM
|
||||
|
||||
The Moderator never gets tired of advising all OPs to attach a sample sheet on which others could base their replies and/or suggestions instead of everyone making their own hypothetical data. If I got Arvi's reply right, attached is a sample sheet for the OP to work around. Hide column B. 
|
|
#2
02-10-2019, 02:42 AM
|
|||
|
|||
|
Thanks to both of you
My problem is that my criteria are on one column but the data that I need to do the average on based on that criteria is on another column How can I do it?
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to highlight the cells using conditional formatting? | LearnerExcel | Excel | 1 | 01-01-2019 01:43 AM |
| Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
| Dynamic, Formatted Cells (Linked) | ShankedS | Excel | 1 | 08-11-2015 02:34 AM |
| Header must toggle text & color + show count of conditionally formatted cells below | Franktoon | Excel | 3 | 02-18-2014 02:10 PM |
| Odd behaviour in formatted cells | furface00 | Excel | 3 | 03-11-2011 08:02 AM |
Windows 7 32bit 
Office 2007
Hybrid Mode