LinkBack URL
About LinkBacks
Hi all,
I have a excel table with three columns. I need help calculating the median for specific codes when specific criteria are met. Please see attached workbook.
/Masun
Hi all,
I have a excel table with three columns. I need help calculating the median for specific codes when specific criteria are met. Please see attached workbook.
/Masun
I used this "array formula" in K2
=MEDIAN(IF(LEFT(B$12:B$300,LEN(G2))=G2&"",IF(C$12:C$300<>"",D$12:D$300)))
confirmed with CTRL+SHIFT+ENTER and copied down
Edit: or you can use table refs like this:
=MEDIAN(IF(LEFT(Tabell1[Code],LEN(G2))=G2&"",IF(Tabell1[Date]<>"",Tabell1[Wtn days])))
You may require semi-colon separators for your region rather than commas, see attached
Last edited by daddylonglegs; 03-22-2015 at 11:53 AM.
Audere est facere
Hi,
Thanks, works great. If i add data in the table is there any risk with using an array formula? Do i need to re-confirm it?
/Masun
No, if you are using the table notation any data added should be included in the formula. You only have to re-confirm the formula if you need to change the formula for some other reason, e.g. changed or additional criteria
Hi,
Thanks for the help and lesson.
/Masun
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks