I have tried to find a solution to this problem, but so far nothing I've found has either worked or explained why it can't - so I'm turning to you guys!
I have a standard data table from which I wish to display the maximum and minimum value of a given criteria using in-cell dropdowns...
Hi wondering if anyone could help?
I have a report on questionnaires I'm doing where I have to return the MAX and MIN values of the results. I first started using the =VLOOKUP(MAX(C4:C12),C4:D12,2,0) formula but it only returns the first MAX value to me but instead I want a formula that can...
I would like to politely ask you for help to solve my little problem. I have already worked with generating random numbers before and have tried to look up for solution, but this is probably more delicate problem than just generating random numbers.
Previously i used just this...
I want a formula which will sum monthly amount in due column in accordance with the current month.
What I want is, if the amount is 120 and it should display 120*2="240" in the total due column after 28th february, and when it comes to March 31st it should display 120*3=360 and so...
I'm looking for excel formula for following set of data:
I'm having Names in Col A, Scores in column B and quantity lifted in Col C.
I need to find top 3 positions. First data needs to be scan through Col B and find highest score and if there is a tie, than Col C should be considered...
I have the following formulas in cells FQ3 and FR3 which return the numbers 16 and 19 repsectively
However I then want a formula that...
OK i have been racking my brain about this for far too long, hopefully someone here can help me
What i need is a formula that will tell me how many extra hours someone has worked over their contracted hours,
So the Min would be their Contacted Hours Per Week * 4 (32*4=128) the Max would be 160...
I have created a MAX(IF command in order to find the maximum temperature, from a table, between two times. it looks like this:
<h5,c16:c28226,0)))}, and="" it="" works="" great!
I have a worksheet with one tab that has a web query retrieving data from an online table and another tab that uses a series of formulas that start by referencing the tab with the web queries.
The order of the formulas is as follows:
web query --> cells referencing the table created by...
If Column A is Greater than 0 and Column B is greater than 90, then find the MAX of column B, and display Name Cell.
It should give you (1).
Also the same as above but instead of MAX I need the MIN...
How do I write, get the MAX value from column2 and Display the name for column1 to another cell in a formula?
So the answer should be (2)
This is only based on the max value and nothing else.
Hope you're all well. I am trying to do the following, if possible. I have found a way around it using formaulas but can't do it using conditional formatting.
What I want to do is to find highest value in a ROW if greater than n% to the second highest (say green) and also finding the...
Please help me look for a formula to get the Max and Min value based on given criteria.
Please help me look for a formula to get the maximum and minimum value based on certain criteria.
Dear Experts i found in typical vlookup situation. i use vlook up function but i can't use with other functions
please advice me on this illustration.