Questions tagged [highest]

134 questions
0
votes
0 answers

Excel formula to return highest score (from one column) for each category (another coulmn) in a table

Basically I envisage having a table of risks in Excel for various projects. Each risk has a score and its project name on one row of the table (amongst various other pieces of information). What I would like is a formula, repeated in 3 cells with…
EBAK87
  • 1
0
votes
2 answers

BASH to compare two fields integrating informations from another file

I have the following two text files: fruits.txt nectarine strawberry orange peach grape apple mango watermelon numbers.txt strawberry 57 apple 48 mango 40 peach 44 watermelon 60 nectarine…
user9467855
0
votes
1 answer

Returning the highest value with different row lengths in Excel

I am working on an Excel file that gives different shareholder ratios per company. Now, I want to find the highest value of those ratios per company. The issue is that the number of ratios is different per company. So, company X has 11 shareholders…
Geert
  • 13
  • 2
0
votes
2 answers

Finding the Hishest Score. ValueError: invalid literal for int() with base 10: ''

I am creating a quiz in which each users score is saved to an external text file. However, whenever I output a report for the highest score in the maths easy quiz it says: ValueError: invalid literal for int() with base 10: '' This seems to be the…
user9215216
0
votes
2 answers

How can I grab highest number from two multidimentional arrays?

I have two arrays the structure is exactly the same only the values are different, like this.. // $array1 Array ( [Backlight] => Array ( [Supply_Type] => Backlight [Value] => 100.00 [Count] => 2 ) [Body…
0
votes
1 answer

Highest top 15 items from ArrayList

I am using Java -7. I want some help cause i stuck, i have a list that i add values all the time but in the end i want get the latest 15. The list handles DonateTable class that contains .getTime() which return long…
magneto30
  • 19
  • 3
0
votes
2 answers

Oracle - Finding the NEXT largest number

Say I have a list of dates & prices: 20170322 109.89 20170321 107.02 20170320 109.25 20170317 108.44 20170316 108.53 20170315 107.94 20170314 106.83 20170313 110.02 20170310 107.31 20170309 107.54 20170308 …
Landon Statis
  • 683
  • 2
  • 10
  • 25
0
votes
4 answers

highest of 4 numbers by conditional operater

#include using namespace std; int main() { int a,b,c,Highest; cout<<"Enter three numbers:"; cin>>a>>b>>c; Highest=(a>b&&a>c?a:b>c?b:c); cout<<"Highest is:"<
Rashed Sami
  • 141
  • 1
  • 4
  • 12
0
votes
1 answer

How Do I Minus A Total From It's Next Highest Multiple Of 10

So I have a total, say 24, I need my code to find the nearest hightest multiple of 10. This would be 30 of course, so I need the code to calculate (30-24). If the number is 20 it would be 20 beucase it is equal to a highest muliple of 10. I then…
0
votes
2 answers

Merge two columns of matrix, keeping only highest values

Is there a simple way of merging two columns of a data frame, keeping only the highest overall value per row? Example: test <- as.data.frame(matrix(rexp(12, rate=.1), ncol=2)) test V1 V2 1 9.945558 5.578294 2 5.141743 …
user5946647
0
votes
3 answers

Oracle SQL select highest values from different tables with "in line view"

I have a database containing product information in the two tables "prod_group" and "product". There are 4 different product groups containing mutiple products. I am supposed to select the most expensive product of each product group by using an "in…
Mongzyy
  • 123
  • 1
  • 10
0
votes
4 answers

finding highest number, no arrays, only if statements

I am currently taking a course in Python programming and we have been given an assignment to complete of finding the highest number given by prompting a user. This would be easy to complete with an array but we are unable to use them for this…
0
votes
1 answer

Php echo highest number from Json

I'm searching an external Json page, for $a and echoing $b. X as $X) { if…
Leviathan
  • 61
  • 7
0
votes
1 answer

Calculating the max value from a set of data

I'm currently developing a code which sorts the data from a csv file according to the user's choice. At the moment I'm having trouble as my sorting for highest score doesn't really work. It recognizes 10 as 010 and therefore infers it as less than…
0
votes
1 answer

MySQL second highest in each project

I want to calculate the SECOND highest hourly_rate of employee in each project. But I don't know where I am doing wrong My concerned table structure: project_team: project_code (FK), employee_id (FK), hourly_rate this is my query which gives the…
Imam Bux
  • 1,006
  • 11
  • 27
1 2 3
8 9