The arguments are a column of division formulas, like c4/d4 all equaling around 100-120 with plenty of duplicates(I read are required to avoid #n/a). Nothing fancy or fishy about it. What's the problem now excel?? Thanks
The arguments are a column of division formulas, like c4/d4 all equaling around 100-120 with plenty of duplicates(I read are required to avoid #n/a). Nothing fancy or fishy about it. What's the problem now excel?? Thanks
Hi,
Almost impossible to say without seeing the workbook. Any chance you could upload it or at least the relevant bit?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
If you display some more decimals, you'll see that there are no repeats.
You could change in formula in D4 and down to
=ROUND(A4/B4, 0)
.. then you'll see the mode (107).
I expect, though, that you may want the median, not the mode. For that, leave the formulas as is, and change MODE to MEDIAN (108.26)
Last edited by shg; 04-10-2016 at 04:01 PM.
Entia non sunt multiplicanda sine necessitate
Hi,
Mode always returns #N/A if there are no duplicates. Your column D values are all unique hence you get #N/A
If you only want to consider the Integer values then use =MODE(INT(D4:D38))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks