highest

This is going to be a really complicated issue to explain but I am going to do my best. I am using PowerPivot for measures and PQ to clean the data. I am building a tool that projects energy charges for the next 12 months at facilities that my company owns. The way it works is the highest...

Hello all, I have two cells in C1 and C2 with values totalling 15. I have another two cells in F1 and F2 totalling 30. What I'd like to do is create a formula that will look at the above values and always gives me the highest number? Any help would be greatly appreciated. Thanks

Hi to All, Can I extract the highest numbers in a string? For example, I have a string as below. abc12334.12nvdv cdv5123.12ncdbcv234564.35 I want to return the highest number value which is 234564.35. Thank you in advance.

I am way in over my head. I'm trying to make a spreadsheet for our future events that would automatically rank the people via the highest of three scores. In case of ties, it will then compare the other two scores to see who had the highest one there. If there are still ties, then whoever...

Hi everyone, I have the following array formula...

Hi all, I have a table with 12 columns. I would like to highlight the highest and lowest entry in each column. Highest in green and the lowest in red. there is a lot of copying and pasting which I find messes up the standard method so was wondering if VBA would work better Many Thanks

I'm trying to create a formula to rank the following from lowest to highest with a tie breaker. So far I've come up with this: =RANK(X2,X$2:$X21,0) but it does not work and does not account for a tie. Column X <colgroup><col></colgroup><tbody> 0.17 3.33 2.50 0.83 0.58 3.33 1.00...

Hello, I'm wondering if it would be possible to have a formula in a cell to always remember the highest value in a range of cells even when the numbers in those range decrease. It would be something like B2=MAX($A$1:$A$100), but the problem with the MAX function would be that as soon as the...

Hello, Have been registered for a while and have been using the forum to address my various problems over the years. Thanks a lot for all the help I have had and for the help provided to the various forumers. I've now come up with a problem that I just cannot seem to either solve or a...

In my excel I have a person entered 3 or more times. Credit score example Bob Jones 760 Bob Jones 750 Bob Jones 740 I want to remove the duplicate Bob Jones's but keep ONLY the TOP entry which is 760 the Highest. I already have my sheet auto sorting so the top one will always be the HIGHEST...

<colgroup><col span="3"><col></colgroup><tbody> NUMBER NAME HOURS HIGHEST HOURS 9999 XXXX 23 54 6577 XXXX 43 66 6577 XXXX 66 66 9999 XXXX 22 54 6577 XXXX 53 66 6577 XXXX 23 66 9999 XXXX 54 54 6577 XXXX 65 66 9999 XXXX 22 54 </tbody>

Hi All, I'm close to having a formula working =INDEX('Pivot Table - Monthly'!$B$2:$O$2,(MATCH(MAX('Pivot Table - Monthly'!$B$3:$O$3),'Pivot Table - Monthly'!$B$3:$O$3,0))) This returns a Value in Row 2 based on the position number of the highest value in row 3 that is working fine. What I...

Hi, The spreadsheet I am using has 3 orders which make one bulk order. The 3 orders have 3 different finish dates. Is there a way of putting on a vlookup formula which then chooses the highest date (this is to create a pivot table). For example: Order Finish date Bulk order 1...

Is there a way to apply conditional formatting to one Column, but reference the Adjacent Column for the values (highest to lowest)? See example below: <tbody> COLUMN 1 COLUMN 2 9 5 73 10 48 8 70 5 42 1 29 7 99 5 51 10 69 2 64 10 </tbody> One can select...

Hey folks, Could use the assistance by those smarter than me! Each sales person sells 2 categories. There are 2 products in each category. Trying to find a way to return the Top 2 largest values for each product: Red Delicious Apple Highest Sales = John Smith Red Delicious Apple 2nd Highest...

How to find the highest positive number above 0 from I4:I20?

I'm sorry in advanced if my explanation isn't very clear, but here goes! I've got a grid of results from four teams who are scored on a weekly basis. So far, my calculation has the following which highlights how many times each team has won (listed at the top of each team)...

I want to make a table showing Item, Price, Quantity Sold and Total. I can set either column to ascending/descending without any issue and have that include the other columns. But i want to know if there is a way for it to show for example the highest total with the highest quantity? Is it...

Hi, I need to find the adjacent cell of a min/max value and return it. However, I can't seem to make this work for my particular situation. I have two tables on separate tabs. One with all my data, and one I want to fill with specific data from the first table. Table #1 structure example...

Hi, I’m looking to return a TRUE or FALSE in a cell based on the values in 2 cells and then the highest value in a ranges of cells. I’ve been playing around with MAX, IF and AND but with no luck. To try and simplify my problem let’s say cell A1 has a sales value that needs to be over £100...