Hi everyone,
I have an array which contains #N/A values.
What should i do so Median, Percentile, Min functions will ignore the #N/A values in the array?
Thank you,
Moty
Hi everyone,
I have an array which contains #N/A values.
What should i do so Median, Percentile, Min functions will ignore the #N/A values in the array?
Thank you,
Moty
hi Moty, something like this perhaps?
=PERCENTILE(IF(ISNA(A2:F2),"",A2:F2),0.25)
=MEDIAN(IF(ISNA(A2:F2),"",A2:F2))
=MIN(IF(ISNA(A2:F2),"",A2:F2))
they are all array formulas. which means you must paste the formula inside the formula bar, & press CTRL + SHIFT + ENTER to confirm
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Works perfectly. Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks