kweaver
Well-known Member
- Joined
- May 12, 2009
- Messages
- 2,934
- Office Version
- 365
- 2010
I've created a named range for a block of data. AVERAGE, MEDIAN, COUNT, COUNTIF, and STDEV all work with the named range.
MODE, however, returns a #VALUE error. If I use MODE without the named range by dragging over the data (need to use CTRL as I drag because the data is not contiguous), it works.
There is only one MODE for the data.
MODE, however, returns a #VALUE error. If I use MODE without the named range by dragging over the data (need to use CTRL as I drag because the data is not contiguous), it works.
There is only one MODE for the data.