Forum Discussion
Dennis Depoorter
Feb 20, 2020Brass Contributor
Select the x accounts who are visited the longest time ago with extra filters
Hi all, I want to make a report in excel that gives me a list of the (by example) 20 accounts who are visited the longest time ago. That works fine with the following formula: =INDEX('10 Acc...
Patrick2788
Feb 21, 2020Silver Contributor
I enjoyed this one:
=INDEX(FILTER('10 Accounts with tasks'!B:E,('10 Accounts with tasks'!A:A="Jay")+('10 Accounts with tasks'!A:A="Vee")*('10 Accounts with tasks'!H:H="Pharmacy")*('10 Accounts with tasks'!M:M="Active")),SEQUENCE(20,1,1,1),{2,1,4})
Dennis Depoorter
Feb 24, 2020Brass Contributor
Hi Patrick, happy to hear you had fun with it.
THANKS for the help so far!
I tested the formula on the full excel file (see attachment), and there are still some doubles in. I uploaded a new file with the doubles in orange and red. This is also a file with a lot more data (anonymized because of privacy reasons).
To purpose of this file is to provide it to our sales reps so they see what pharmacists they haven't visited in a long time, an need to visit ASAP!
Thanks,
Dennis