lowest

I'm working with a two rows and 12 columns. In range F24 to Q24 are numbers from 1 to 12 In range F25 to Q25 are months of the year from Jan to June. I need a formula to enter in F28 that will tell me which month of the year (row 25) corresponds to the lowest number in row 24. I will then...

Hi all I have a formula which I wish to include TEXT and a formula. Text will be : and your lowest time will be then add to that a formula to find lowest score on the 'Pivots data' page through column I formula like : MIN('Pivots data'!I:I) then add more TEXT like well done final...

Good morning! I need help with my table. I have two lines (Raw Score and Relative Rank): <tbody> Raw Score 390 100 660 350 310 Relative Rank </tbody> And I need the second row to list the numbers from highest to lowest. <tbody> Raw Score 390 100 660 350 310 Relative Rank 2 5 1 3...

Hi All, I have created a Random Number Generator using the code below Private Sub CommandButton1_Click() Range("d2") = WorksheetFunction.RandBetween(-2, 2) Range("d3") = WorksheetFunction.RandBetween(-2, 2) which works exactly how I want it to What I would like to do from here is generate a...

Determining a "skin" for a golf hole. With conditional formatting I can highlight the lowest number(s) for a given hole but I'm looking to highlight the number only if it's the lowest number without tying. Example: A1 thru A20 all contain numbers...the low number is 3 but there are two cells...

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 need assistance with conditional formatting, in cell AZ880 the user will enter a value, I need this cell to turn green if the value entered is equal to the lowest value in either cells AX or AY 880. If the value in AZ880 does not match the lowest value in either cells AX or AY880 I need...

Say I have 4 quizzes, and there is an optional Review Session. Student gets either 100 or 0 for attending/not attending the review session. If student attends the review, their lowest quiz scores will be replaced by 100, provided the quiz to be replaced is at least 70. Please note that there...

I admit I am a bit stupid on this subject... I have a table with 7 different colums I need on colum H to retrieve the lowest value from colum G - as long as this is the lowest amongst the relevant rows Coloms A, B & C are the filtering colums, they all have to match I tried making colum H my...

<tbody> ID Subject score 1000 Math 80 1001 English 45 1002 Math 60 1002 English 87 1001 English 50 1000 Chem 54 1001 Math 71 1002 Chem 83 </tbody> <tbody> ID Name Age 1000 matt 12 1001 john 15 1002 simon 16 </tbody> This solution needs to be a formula that must be...

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...

I will just use a simple data to describe what I trying to do. Column A has letters down A-Z (row 1-26) Column B through U has numbers 1-20 across I have used conditional formatting to find the lowest number in each column so I have 20 of the lowest numbers highlighted. Sometimes there are 2...

I would like a formula to find the highest number above 0 from I4:I20 and another formula to find the lowest number below 0 from I4:I20?

I would like to seek some help on the problem that I'm facing. I'm trying to highlight the lowest value in the sheet for each row based on selected columns, i.e. iot1, iot2, iot3. If you see the before and after image below, I would like to get some assistance on how to highlight the lowest...

I would like to seek some help on the problem that I'm facing. I'm trying to highlight the lowest value in the sheet for each row based on selected columns, i.e. iot1, iot2, iot3. If you see the before and after image below, I would like to get some assistance on how to highlight the lowest...

person1 A 66 person2 A 68 person3 A 70 person4 B 88 person5 B 89 person6 A 65 person7 C 90 person8 C 91 I WANT TO GET THE LOWEST SCORE FOR ALL PERSONS WITH AN 'A' NEXT TO THEIR SCORE? THIS IS THE IF/THEN I WROTE, BUT I DONT KNOW HOW TO IGNORE IF FALSE...

I currently have several charts that show the Top 5-10 items in a list. Currently, the chart sorts it by lowest to highest. In trying to figure out how to have it sort from highest to lowest, I located the "Categories in Reverse Order" option within the Axis formatting, however when I click...

Needing assistance with the following... Name Month Rank Time Order # Desired Result Bobby April 4 2:30 12433 0 Bobby April 0 4:30 14655 1 Bobby April 4 7:30 18654 0 Bobby April 2 3:30 98752 0 Bobby April 0 1:30 11548 1 Tommy April 0...

This is similar to a question I have asked before. Basically, I have a list of products and the product number repeats on a new row for every price variance we have sold it for. I would like to find the price we have sold it for most frequently. Variables to account for would be: 1 - It has...