Forum Discussion
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...
That could be
=IFERROR(
INDEX('10 Accounts with tasks'!C:C,
AGGREGATE(15,6,1/
('10 Accounts with tasks'!H:H="Pharmacy")/
('10 Accounts with tasks'!A:A="Jay")*
ROW('10 Accounts with tasks'!N:N),
ROW()-ROW($B$1)
)),"")
Thank you very mutch!!! But I forgot 1 thing...
Reason for that rapport will make it all clear...
I want our sales rep's to have a rapport of the 20 accounts that they have visited the longest time ago. Because for every visit they make a task with a "day visited", we have to select first for all accounts the last day they have been visited, and then select out of that the 20 oldest... is this possible within 1 formula?