| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#N/A in mode worksheet function
Can anyone telle me when #N/A occurs as the answer to an worksheet function? If I try to find the mode of the list of codes below, I get #N/A 7372 7379 7379 7379 7372 7375 Does this have anything to do with the first two digits being equal? How do I workaround? I am trying to find the most frequent ocurring code in the list. By the way, how does the mode work if out of 4 values, both pairs of two are equal? Thanx! -- broer konijn ------------------------------------------------------------------------ broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402 View this thread: http://www.excelforum.com/showthread...hreadid=552394 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a WorkSheet from a Function??? | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
| changing type style and colour within a worksheet function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Threaded Mode
