Hi,
I have in table 1 the data for error points by staff. In table 2, I would like to use a formula to populate the data from table 1 by the highest error point.
I tried using a IF and LARGE formula but I cant get it right.
Table 1 is populated automatically at my work place and the report is refreshed everyday. I have to use the sort function manually everyday and therefore I was wondering if I can formula this data in table 2 by the highest error points so that everytime the report in table 1 is refreshed, it automatically sorts by highest error points in table 2.
Appreciate help and thanks in advance.
Bookmarks