DGET
Extracts a single value from a column of a list or database that matches conditions that you specify.
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Shared/String.php on line 526
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Shared/String.php on line 527
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Shared/String.php on line 538
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Shared/String.php on line 539
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Shared/String.php on line 541
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Shared/String.php on line 542
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 2551
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 2551
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 2672
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 2672
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 2676
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 2764
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 2768
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 2780
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3034
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3166
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3168
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3169
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3457
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3457
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3460
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3461
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3891
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3891
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3936
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3942
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3998
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 4001
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 720
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 720
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 812
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 813
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 816
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 817
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 817
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 819
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 820
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 820
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 820
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell.php on line 824
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 90
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 90
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type float in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type float in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type float in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type float in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type float in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type float in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Database
array(7) {
[4]=>
array(5) {
["A"]=>
string(4) "Tree"
["B"]=>
string(6) "Height"
["C"]=>
string(3) "Age"
["D"]=>
string(5) "Yield"
["E"]=>
string(6) "Profit"
}
[5]=>
array(5) {
["A"]=>
string(5) "Apple"
["B"]=>
float(18)
["C"]=>
float(20)
["D"]=>
float(14)
["E"]=>
float(105)
}
[6]=>
array(5) {
["A"]=>
string(4) "Pear"
["B"]=>
float(12)
["C"]=>
float(12)
["D"]=>
float(10)
["E"]=>
float(96)
}
[7]=>
array(5) {
["A"]=>
string(6) "Cherry"
["B"]=>
float(13)
["C"]=>
float(14)
["D"]=>
float(9)
["E"]=>
float(105)
}
[8]=>
array(5) {
["A"]=>
string(5) "Apple"
["B"]=>
float(14)
["C"]=>
float(15)
["D"]=>
float(10)
["E"]=>
float(75)
}
[9]=>
array(5) {
["A"]=>
string(4) "Pear"
["B"]=>
float(9)
["C"]=>
float(8)
["D"]=>
float(8)
["E"]=>
float(76.8)
}
[10]=>
array(5) {
["A"]=>
string(5) "Apple"
["B"]=>
float(8)
["C"]=>
float(9)
["D"]=>
float(6)
["E"]=>
float(45)
}
}
Criteria
ALL
The height of the Apple tree between 10' and 16' tall
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation/Functions.php on line 321
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation/Functions.php on line 324
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation/Functions.php on line 562
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation/Functions.php on line 612
Notice: Trying to access array offset on value of type null in /var/www/u1913982/data/www/vetta.tv/contests/results/excel/Classes/PHPExcel/Calculation.php on line 3370
DMAX() Result is 14
Criteria
array(2) {
[1]=>
array(1) {
["A"]=>
string(4) "Tree"
}
[2]=>
array(1) {
["A"]=>
string(6) "=Apple"
}
}
DMAX() Result is