Spreadsheet: 59673d1260261860-excel-2007-retrieve-top-10-records-from-data-through-formula-709991_madan
Sheet: Data

Region | Owner | Customer | category | Status | probability | close date | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Sub product 1 | Sub product 2 | Sub product 3 | Sub product 4 | Sub product 5 | Sub product 6 | Sub product 7 | Sub product 8 | Unique id | flag | Country |  | Created Date | Updated Date | Industry | Direct/Indirect | Partner Name | [NAME] | Action to close | Days Since Create | Days Since Update | Range | >=40 | TOTAL
IN | Name 1 | Company 1 | category 1 | status 1 | 100 | 2009-11-06 00:00:00 |  |  |  |  |  |  |  | 0 | 200 | 10 | 20 | 30 | 60 | 20 | 20 | 0 | Unique id 1 | Y | IN | Q210 | 2009-01-12 00:00:00 | 2009-11-23 00:00:00 | Industry 1 | direct | Partner 1 | Approval 1 | action 1 | date 1 | date 1 | Range 1
GC | Name 2 | Company 2 | category 2 | status 2 | 30 | 2010-05-18 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 2 | N | CN | Q410 | 2009-05-07 00:00:00 | 2009-11-02 00:00:00 | Industry 2 | indirect | Partner 2 | Approval 2 | action 2 | date 2 | date 2 | Range 2
GC | Name 3 | Company 3 | category 3 | status 1 | 20 | 2010-03-23 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 3 | N | CN | Q410 | 2008-08-01 00:00:00 | 2009-09-20 00:00:00 | Industry 3 | direct | Partner 3 | Approval 3 | action 3 | date 3 | date 3 | Range 3
ANZ | Name 4 | Company 4 | category 4 | status 2 | 10 | 2010-02-24 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 4 | N | AU | Q310 | 2009-09-22 00:00:00 | 2009-11-24 00:00:00 | Industry 4 | indirect | Partner 4 | Approval 4 | action 4 | date 4 | date 4 | Range 4
ANZ | Name 5 | Company 5 | category 5 | status 1 | 100 | 2009-07-06 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 5 | Y | AU | Q110 | 2004-07-25 00:00:00 | 2009-10-26 00:00:00 | Industry 1 | direct | Partner 5 | Approval 5 | action 5 | date 5 | date 5 | Range 5
ANZ | Name 6 | Company 6 | category 6 | status 2 | 40 | 2009-11-30 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 6 | N | AU | Q210 | 2007-11-15 00:00:00 | 2009-11-25 00:00:00 | Industry 2 | indirect | Partner 6 | Approval 6 | action 6 | date 6 | date 6 | Range 6
ANZ | Name 7 | Company 7 | category 7 | status 1 | 30 | 2010-04-28 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 7 | N | AU | Q410 | 2008-11-17 00:00:00 | 2009-11-24 00:00:00 | Industry 3 | direct | Partner 7 | Approval 7 | action 7 | date 7 | date 7 | Range 7
ANZ | Name 8 | Company 8 | category 8 | status 2 | 30 | 2010-05-21 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 8 | N | NZ | Q410 | 2009-03-10 00:00:00 | 2009-11-18 00:00:00 | Industry 4 | indirect | Partner 8 | Approval 8 | action 8 | date 8 | date 8 | Range 8
GC | Name 9 | Company 9 | category 9 | status 1 | 10 | 2010-05-30 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 9 | N | CN | Q410 | 2009-09-16 00:00:00 | 2009-09-20 00:00:00 | Industry 1 | direct | Partner 9 | Approval 9 | action 9 | date 9 | date 9 | Range 9
ANZ | Name 10 | Company 10 | category 10 | status 2 | 20 | 2010-05-28 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 10 | N | AU | Q410 | 2009-08-06 00:00:00 | 2009-10-26 00:00:00 | Industry 2 | indirect | Partner 10 | Approval 10 | action 10 | date 10 | date 10 | Range 10
ASEAN | Name 11 | Company 11 | category 11 | status 1 | 40 | 2009-12-25 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 11 | Y | ID | Q310 | 2008-08-12 00:00:00 | 2009-11-10 00:00:00 | Industry 3 | direct | Partner 11 | Approval 11 | action 11 | date 11 | date 11 | Range 11
IN | Name 12 | Company 12 | category 12 | status 2 | 20 | 2010-04-07 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 12 | N | IN | Q410 | 2009-07-16 00:00:00 | 2009-09-14 00:00:00 | Industry 4 | indirect | Partner 12 | Approval 12 | action 12 | date 12 | date 12 | Range 12
IN | Name 13 | Company 13 | category 13 | status 1 | 100 | 2009-08-31 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 13 | Y | IN | Q110 | 2008-11-14 00:00:00 | 2009-09-04 00:00:00 | Industry 1 | direct | Partner 13 | Approval 13 | action 13 | date 13 | date 13 | Range 13
ASEAN | Name 14 | Company 14 | category 14 | status 2 | 40 | 2009-11-30 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 14 | N | MY | Q210 | 2007-03-29 00:00:00 | 2009-11-10 00:00:00 | Industry 2 | indirect | Partner 14 | Approval 14 | action 14 | date 14 | date 14 | Range 14
ANZ | Name 15 | Company 15 | category 15 | status 1 | 20 | 2010-05-25 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 15 | N | NZ | Q410 | 2009-06-08 00:00:00 | 2009-11-10 00:00:00 | Industry 3 | direct | Partner 15 | Approval 15 | action 15 | date 15 | date 15 | Range 15
ANZ | Name 16 | Company 16 | category 16 | status 2 | 30 | 2010-04-16 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 16 | N | NZ | Q410 | 2009-11-08 00:00:00 | 2009-11-22 00:00:00 | Industry 4 | indirect | Partner 16 | Approval 16 | action 16 | date 16 | date 16 | Range 16
KR | Name 17 | Company 17 | category 17 | status 1 | 40 | 2010-05-31 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 17 | N | KR | Q410 | 2009-09-03 00:00:00 | 2009-11-21 00:00:00 | Industry 1 | direct | Partner 17 | Approval 17 | action 17 | date 17 | date 17 | Range 17
IN | Name 18 | Company 18 | category 18 | status 2 | 30 | 2010-04-29 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 18 | N | IN | Q410 | 2009-04-27 00:00:00 | 2009-10-01 00:00:00 | Industry 2 | indirect | Partner 18 | Approval 18 | action 18 | date 18 | date 18 | Range 18
ANZ | Name 19 | Company 19 | category 19 | status 1 | 80 | 2009-11-30 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 19 | Y | AU | Q210 | 2009-10-19 00:00:00 | 2009-11-25 00:00:00 | Industry 3 | direct | Partner 19 | Approval 19 | action 19 | date 19 | date 19 | Range 19
KR | Name 20 | Company 20 | category 20 | status 2 | 20 | 2010-05-24 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 20 | N | KR | Q410 | 2009-10-22 00:00:00 | 2009-10-23 00:00:00 | Industry 4 | indirect | Partner 20 | Approval 20 | action 20 | date 20 | date 20 | Range 20
ANZ | Name 21 | Company 21 | category 21 | status 1 | 10 | 2010-05-20 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 21 | N | AU | Q410 | 2009-11-23 00:00:00 | 2009-11-24 00:00:00 | Industry 1 | direct | Partner 21 | Approval 21 | action 21 | date 21 | date 21 | Range 21
ASEAN | Name 22 | Company 22 | category 22 | status 2 | 40 | 2010-04-18 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 22 | N | SG | Q410 | 2009-06-26 00:00:00 | 2009-11-04 00:00:00 | Industry 2 | indirect | Partner 22 | Approval 22 | action 22 | date 22 | date 22 | Range 22
GC | Name 23 | Company 23 | category 23 | status 1 | 60 | 2009-11-30 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 23 | Y | CN | Q210 | 2008-12-15 00:00:00 | 2009-11-19 00:00:00 | Industry 3 | direct | Partner 23 | Approval 23 | action 23 | date 23 | date 23 | Range 23
GC | Name 24 | Company 24 | category 24 | status 2 | 60 | 2009-11-30 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 24 | Y | CN | Q210 | 2008-07-18 00:00:00 | 2009-11-23 00:00:00 | Industry 4 | indirect | Partner 24 | Approval 24 | action 24 | date 24 | date 24 | Range 24
GC | Name 25 | Company 25 | category 25 | status 1 | 60 | 2009-11-30 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 25 | Y | CN | Q210 | 2009-07-08 00:00:00 | 2009-11-09 00:00:00 | Industry 1 | direct | Partner 25 | Approval 25 | action 25 | date 25 | date 25 | Range 25
IN | Name 26 | Company 26 | category 26 | status 2 | 100 | 2009-10-28 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 26 | Y | IN | Q210 | 2009-05-12 00:00:00 | 2009-10-29 00:00:00 | Industry 2 | indirect | Partner 26 | Approval 26 | action 26 | date 26 | date 26 | Range 26
ASEAN | Name 27 | Company 27 | category 27 | status 1 | 10 | 2010-03-31 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 27 | N | SAGE | Q410 | 2009-08-10 00:00:00 | 2009-10-22 00:00:00 | Industry 3 | direct | Partner 27 | Approval 27 | action 27 | date 27 | date 27 | Range 27
ASEAN | Name 28 | Company 28 | category 28 | status 2 | 60 | 2009-11-30 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 28 | Y | PH | Q210 | 2009-05-29 00:00:00 | 2009-11-17 00:00:00 | Industry 4 | indirect | Partner 28 | Approval 28 | action 28 | date 28 | date 28 | Range 28
ANZ | Name 29 | Company 29 | category 29 | status 1 | 10 | 2010-05-28 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 29 | N | AU | Q410 | 2009-07-27 00:00:00 | 2009-11-03 00:00:00 | Industry 1 | direct | Partner 29 | Approval 29 | action 29 | date 29 | date 29 | Range 29
ANZ | Name 30 | Company 30 | category 30 | status 2 | 40 | 2010-02-01 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 30 | Y | AU | Q310 | 2008-12-02 00:00:00 | 2009-11-09 00:00:00 | Industry 2 | indirect | Partner 30 | Approval 30 | action 30 | date 30 | date 30 | Range 30
ANZ | Name 31 | Company 31 | category 31 | status 1 | 30 | 2010-05-21 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 31 | N | AU | Q410 | 2008-10-23 00:00:00 | 2009-11-24 00:00:00 | Industry 3 | direct | Partner 31 | Approval 31 | action 31 | date 31 | date 31 | Range 31
IN | Name 32 | Company 32 | category 32 | status 2 | 40 | 2010-03-16 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 32 | N | IN | Q410 | 2009-07-16 00:00:00 | 2009-11-06 00:00:00 | Industry 4 | indirect | Partner 32 | Approval 32 | action 32 | date 32 | date 32 | Range 32
ASEAN | Name 33 | Company 33 | category 33 | status 1 | 30 | 2010-02-15 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 33 | N | SG | Q310 | 2009-03-11 00:00:00 | 2009-10-19 00:00:00 | Industry 1 | direct | Partner 33 | Approval 33 | action 33 | date 33 | date 33 | Range 33
KR | Name 34 | Company 34 | category 34 | status 2 | 10 | 2010-02-28 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 34 | N | KR | Q310 | 2009-10-20 00:00:00 | 2009-11-16 00:00:00 | Industry 2 | indirect | Partner 34 | Approval 34 | action 34 | date 34 | date 34 | Range 34
ANZ | Name 35 | Company 35 | category 35 | status 1 | 40 | 2009-12-15 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 35 | N | AU | Q310 | 2008-11-25 00:00:00 | 2009-11-17 00:00:00 | Industry 3 | direct | Partner 35 | Approval 35 | action 35 | date 35 | date 35 | Range 35
ANZ | Name 36 | Company 36 | category 36 | status 2 | 20 | 2009-12-10 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 36 | N | AU | Q310 | 2009-10-22 00:00:00 | 2009-11-24 00:00:00 | Industry 4 | indirect | Partner 36 | Approval 36 | action 36 | date 36 | date 36 | Range 36
ANZ | Name 37 | Company 37 | category 37 | status 1 | 30 | 2010-05-28 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 37 | N | AU | Q410 | 2009-11-24 00:00:00 | 2009-11-25 00:00:00 | Industry 1 | direct | Partner 37 | Approval 37 | action 37 | date 37 | date 37 | Range 37
GC | Name 38 | Company 38 | category 38 | status 2 | 10 | 2010-05-28 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 38 | N | CN | Q410 | 2009-08-31 00:00:00 | 2009-09-07 00:00:00 | Industry 2 | indirect | Partner 38 | Approval 38 | action 38 | date 38 | date 38 | Range 38
ASEAN | Name 39 | Company 39 | category 39 | status 1 | 20 | 2010-02-28 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 39 | N | SAGE | Q310 | 2009-02-04 00:00:00 | 2009-11-05 00:00:00 | Industry 3 | direct | Partner 39 | Approval 39 | action 39 | date 39 | date 39 | Range 39
ANZ | Name 40 | Company 40 | category 40 | status 2 | 100 | 2009-11-15 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 40 | Y | AU | Q210 | 2008-07-21 00:00:00 | 2009-11-20 00:00:00 | Industry 4 | indirect | Partner 40 | Approval 40 | action 40 | date 40 | date 40 | Range 40
ASEAN | Name 41 | Company 41 | category 41 | status 1 | 60 | 2010-02-28 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 41 | Y | SAGE | Q310 | 2009-04-15 00:00:00 | 2009-08-31 00:00:00 | Industry 1 | direct | Partner 41 | Approval 41 | action 41 | date 41 | date 41 | Range 41
ANZ | Name 42 | Company 42 | category 42 | status 2 | 30 | 2010-03-19 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 42 | N | AU | Q410 | 2009-07-09 00:00:00 | 2009-10-20 00:00:00 | Industry 2 | indirect | Partner 42 | Approval 42 | action 42 | date 42 | date 42 | Range 42
ANZ | Name 43 | Company 43 | category 43 | status 1 | 30 | 2010-04-29 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 43 | N | AU | Q410 | 2009-08-05 00:00:00 | 2009-10-21 00:00:00 | Industry 3 | direct | Partner 43 | Approval 43 | action 43 | date 43 | date 43 | Range 43
ANZ | Name 44 | Company 44 | category 44 | status 2 | 20 | 2010-04-25 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 44 | N | AU | Q410 | 2009-01-06 00:00:00 | 2009-10-21 00:00:00 | Industry 4 | indirect | Partner 44 | Approval 44 | action 44 | date 44 | date 44 | Range 44
GC | Name 45 | Company 45 | category 45 | status 1 | 30 | 2010-02-19 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 45 | N | TW | Q310 | 2009-08-05 00:00:00 | 2009-10-09 00:00:00 | Industry 1 | direct | Partner 45 | Approval 45 | action 45 | date 45 | date 45 | Range 45
ANZ | Name 46 | Company 46 | category 46 | status 2 | 20 | 2010-04-30 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique id 46 | N | AU | Q410 | 2009-06-26 00:00:00 | 2009-11-05 00:00:00 | Industry 2 | indirect | Partner 46 | Approval 46 | action 46 | date 46 | date 46 | Range 46