I am trying to create a list that will add new clients (Worksheet name 'Metric', starting in cell A5) based on criteria from another Worksheet (Clients, cells A29:I250). I would want this list to populate if on the Clients worksheet H was 'Write Up' and I was 'Active'. I feel like this may be an INDEX MATCH that I'm just flubbing on coming up with?
Clients in column A on the Clients worksheet do duplicate with either 'Write Up' or 'Sales' in column H, which is why I need the distinction as to not duplicate them. Any ideas where I'm hiccuping?
Clients in column A on the Clients worksheet do duplicate with either 'Write Up' or 'Sales' in column H, which is why I need the distinction as to not duplicate them. Any ideas where I'm hiccuping?