lowest

Hi all, I know this problem has been answered more than once, but the solutions I found so far don't work... The task: I have a row of values that starts with large negative numbers and in each column the values become smaller until they eventually become positive. I need to automatically...

Hi, I have a list of postcodes in column A, carriers in column B, and their rates in column C as below. I'm looking for a for a formula to replace "XXX" under the lowest cost section to look up the postcode in the list in column A and return the applicable carrier from column B based on which...

i have a column that includes a subtotal, when i click on the filter of the row with the subtotal and select filter then up top sort highest to lowest (it is a range of %s in that column) it doesn't sort in that order of highest to lowest. it is just kind of random any ideas

HI, Please help me write a formula to sort the 10 lowest scores out of the last 20 games and either mark them or copy in the next col. I can add and average the result. The real and complete way to calculate HDCP is 5 or 6 games Lowest 1 7 or 8 games Lowest 2 9 or 10 Lowest 3 11 or 12 Lowest 4...

Here is what I am trying to do. There are two columns of data for my waterfall chart Y axis. I would like the code to read the two columns and find the lowest and highest values. I would then like the code to set the lowest value on the Y axis to $500k less than the lowest value and $500k more...

I have a spreadsheet containing a combination of numbers ($ values), zeros, errors (#N/A) and text. For each row I want to highlight in green the lowest dollar value shown. I have used the following formula to display the lowest value from the row in another cell...

Hi Guys, I run a few golf pools a year and have a pretty good spreadsheet that automates a lot of stuff (now if only I could tie into alive leaderboard). One of the things people want to see is their lowest 7 scores highlighted. I can total the lowest 7 using the SMALL function, but when...

Good afternoon Is there a way to average a range excluding zero values if any and the highest and lowest value

If you can help that would be great. Here's the example Dates in years 2018 2017 2016 2015 2014 Prices 5 5 5 7 10 First the lowest price is 5 but then based on that I want the most recent or closest date to current which in this case would be...

I've searched Google but not able to find this answer because I don't think I entered the correct search verbiage. Does one need to have a complicated VBA in order for me to do what I want? I want to give points to each category where the player is ranked then ranked from lowest. Example. Ty...

Hello, I'm trying to average scores, but need to ignore/drop the lowest score for every six entries. But the catch is I have to ignore the lowest of each six groups of scores. So every six data entries triggers the ignoring/dropping of the lowest within that set and so on and so. So after...

Hi everyone! Hoping you can help me. I'm trying to build a pricing database for building supplies. I have prices from many suppliers for products and would like to have a page displaying only the lowest price for each product, along with relevant data such as product code and pack size. I...

Hi all, I am hoping to find a formula that will subtract each value in a column (B2:B25) directly from the lowest value in that column. Example: Column B 59 54 56 50 Column C B2 - B5 (59-50 = 9) B3 - B5 (54-50 = 4) B4 - B5 (56-50 = 6) B5 - B5 (50-50 = 0) The lowest value can vary where it...

Hi All, I have a list of values, both positives and negatives and I would like to find the lowest point that can be obtained by summing any of the possible sum combinations of that list. However they do have to stay in sequence. For example: A1: -3 A2: 5 A3: -4 A4: -1 A5: 2 Adding -3, -4...

I need to figure the average of the 4 highest of 6 quiz scores for a class that I am teaching. I drop the two lowest scores, but those are the two lowest submitted quizzes; a zero (= student skipped the quiz) does not count as one of the two dropped. So: a sample student has these six cells...

Example Data: Column B Column C Column F Apple 1234 1.00 Orange 1234 1.25 Orange 4321 5.00 Pineapple 4321 3.50 Banana 4321 3.50 Grape...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica; min-height: 13.0px}table.t1 {border-collapse...

I have product codes in column A, prices in column B, and Names in Column C. I Am looking for help with a formula or a macro to do the following: Delete duplicate rows in column A but keeping the lowest dollar value B. Also if the lowest dollar values are duplicates then I would need a...

Here is the deal, i have 2 columns in a google sheet doc with a bunch of values and #error ! and #ref ! I use =$B:$B=max(IFERROR(B:B)) and =$C:$C=min(IFERROR(C:C)) to highlight the lowest value in C and the highest value in B, and ignore errors Problem 1= how to compute the spread and the...

Hi, I have thousands of lines and trying to find the lowest value per line, yet I need to identify which supplier is the lowest by (on line 1) . Looking for help in this scenario. <colgroup><col><col><col span="3"></colgroup><tbody> Supplier A Supplier B Supplier C Result Part...