highest

Hi! Need some help with a formula to calculate a discount. 20% off all items EXCEPT the highest value item. Where 2 items are same value, only 1 gets the discount. Here's my example: price discount 40 8 100 0 100 20 60 12 This seems to work when there's no duplicates...

Hi All, So I've got a table in excel that is laid out like below; <colgroup><col><col><col><col><col><col span="5"></colgroup><tbody> 8am-9am 9am-10am 10am-11am 11am-12pm 12pm-1pm 1pm-2pm 2pm-3pm 3pm-4pm 4pm-5pm 5pm-6pm 1 2 3 4 5 6 7 8 9 10 1 12 72 124 209 322 450 500 644 678 1 2 3 4 5...

Looking for a macro that can count the occurrences of the decimal values in column O2-O20 and count and write them from highest to lowest in Q2-Q20 .Any help much appreciated https://files.fm/u/6k5ug2cq#/view/Count.jpg P.S Your upload picture dont work on this website

Hi- I would like to pull the amount from the chart, but to the next highest number. When I go to pull like 3390 it pulls the 3300 amount, I need the 3400 amount- Any ideas, thanks <tbody> Date: Reading Usage Chart amount <gwmw class="ginger-module-highlighter-mistake-type-1"...

Hi I would like a formula that allocates 10 point to highest bidder, the second bidder get proportion of the 10 point as distance from the highest bidder, so same from bidder 3 etc. Hope the above makes sense Any help would be much appreciated Thank you

I have a question which says: "Refer to the "Final Marks" column (Column N) and find the student with the highest mark. Display the student name (from Column D) into the cell Q2. Answer should be in the form of VBA codes." I have managed to do this using Excel function...

Hello Good Day, I need a formula wich will show the highest 2 numbers in related cell ranges as given sample below. Thank you. <colgroup><col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt"...

Hello, need some help please! I have a userform to enter data on a table. I'm in need of having the code search column "H" to find the highest number/value and then place the next highest number/value in the cell "H" of the row that the userform is entering data to. (I hope that makes sense)...

Hello all, I've been stuck trying multiple ways to get a formula in col F to J to work. I have a row of numbers in col A to E say; 5,5,4,3,2 and I need a formula that will add 1 to the second and third highest numbers and display that in col F to J as 5,6,5,3,2 using LARGE I keep getting...

Is it possible to do this? I have this sheet <tbody> Team NAMES SCORE T1 JOHAN 1 T1 ANNA 23 T1 MARIA 3 T2 BENJAMIN 5 T3 OLOF 55 T1 LARS 16 T3 LISA 12 T3 OSKAR 5 </tbody> Id like to get the top 3 highest scores. of each team. I want to present the...

Good afternoon! I'm using the following formula to determine the address of the cell containing the highest value in a range =CELL("address",INDEX(HW28:II28,MATCH(MAX(HW28:II28),HW28:II28,0))) but I now want to return the value from the corresponding column in Row 20, So, if the highest value...

I inserted a ranking in my pivot table based on the final score. But when i am trying to sort it from smallest to highest, it does not work. How can i sort it. Thanks

Hi In the excel sheet, I have the date in J8:J9999 and Invoice number in the Column K8:K9999. Invoice number having 4 series as below, 1 to 1000 1001 to 4000 4001 to 5000 10000 to 15000 Invoice number entry will be like this 1&2&3 1005 1006&1007&1008 4004 4005&4006&4007 I used a formula in...

hi, i have an array of random numbers and i need to find the minimum number between the first highest number and the new highest number that will come later on. for example 1,2,10,7,5,3,9,2,11 - 10 is the highest, than 11 is the new max so i need to find the min between - 2. that calculation...

Hello all, Have a table which looks like this: in A1 is a value of 3000 in A2 is a value of 100 <colgroup><col><col span="2"></colgroup><tbody> X Y Side 25 55 Z 25 55 Y 115 55 Z 115 55 Y 205 55 Z 205 55 Y 2233 75 Z 2233 75 Y 2302 45 Z 2302 45 Y 2950 50 Z 2950 50 Y...

I am making a dashboard in excel, and I have been stumped as to if this is doable or not. I have 2 sheets, one with data and one with a dashboard that I am making. I have the id# for each individual user in one field (g4) and use that to populate the data in the rest. I have 6 Error Columns S:X...

Is there a formula to find the highest score(s) for Bob in a list with all of his games, and all of his teammates games? Something like "MaxIf" would be perfect, but I don't think it exists. It seems logical, but I'm stumped. If that is possible, can it be taken a step farther to have a...

Hi, I have been working on a debt consolidation calculator. Basically I want to list a set of debts and have excel calculate when each debt is being paid off and create a graph over time. The part I am having trouble with is as each debt is being paid off, the contribution of that debt now...

Would it be possible to loop thuru all the worksheets , counting how many rows are used in colum A, and move the position of the worksheets so the ones with the highest @ of entries are on the left , diminishing to the right?

I have a list of supplies in Column A and prices in Column B. I am constantly adding rows of data to the worksheet. I want to get the highest Value for "Sugar" and also the highest value for "Lemons". Is there a way to combine an IF Supply = "Sugar" with a Max function?