Hello having some issue with the LARGE function.
basically I have fields that are empty i.e. the branches have not input a employee name.
i have a graph, which sorts the revenue the employee made from largest to smallest.
i have worksheet called "data" where the employee name comes from, so there are 34 employees currently, with 20 extra space. for the extra space, it currently shows a NA()....but when i try to make my calculation for the "large()" function....it messes up and does not like the NA()s.
can someone pls advice!
also, for some reason, when i delete "JOHN DOE" from the data worksheet, my graph is messing up.....can someone pls help wid this issue!!!!!
i have hightlight the cells in yellow.
much appreciated!
Bookmarks