smallest

Hi, I have a table and when I update it, it loses its "Sort largest to smallest", and I have to press the filter and then set the criteria again. I would like to avoid this and "keep" the table sorted by my first column that has the large and small numbers in it. Any idéa on how to keep a...

I have the attached data. I am trying to sort column F from largest to smallest but after the Month, LOC and then Disch Service. Please help.

Hello I have data from a game simulator that lists six available tokens with non-repeating values from 1 to 6 in any order. The smallest value token is selected first (for an action that I have already constructed) For each subsequent round of the game the next next smallest token is...

Hi guys, I need to find the smallest batch size of a product that is made on particular equipment So on the right I have Equipment 1 (Cell K4) and on this equipment, Product A and Product are made What are the smallest batch sizes of these products? The source table is on the left The results...

I wrote the following: Sub mark6() Dim A(6) As String For i = 1 To 6 A(i) = InputBox("Enter Number " & i) Next i End Sub I would like to know how to write the script so as to rearrange and sort the 6 numbers from the smallest to the bigest. ie A(1) is the smallest and A(6)...

Hello, A3:G200 has my data that gets pulled in by macro. In I10:I210, I would like a formula or a automatic method to sort D3:D200 (percentage value) from smallest to largest while keeping original data in the columns next to it. As of now I have I10 filled down to I210...

I know how to use the SMALL function to determine the nth smallest figure; however, when you have a table like this, how do I determine the 3rd smallest figure from the GROUP? For example, if I could $25,000 as a single group, $30,000 as another group, and so forth. In this case, $35,000 would...

Hi All I have data in columns A4:DR & LastRow (4 being the header row) I want to be able to look at each column from G onwards and see if the word "Hello" appears in there - if it does, sort smallest to largest based on that column. Continue to look at every column and if it appears again then...

Hello, I have been facing a "lookup" problem for most of the day today. I have tried vlookup and index-match, however I am unable to return the resulting values that I am looking for. Thank you in advance for your assistance. In short, I am trying to do accomplish two things. These two...

Hi I have values in five different cells scattered across my excel sheet and I want to find the pair of those values that gives the smallest difference. Assuming I have the value in a1, b1, c1, d1 and e1 Then I test the difference as follows E.g. a1-b1 = 0.50 a1-d1 = 0.53 b1-c1...

Could some one please help me with a formula that can give the smallest value within a defined range. So let's say in column 1 there are vales and in column 3 I have manually copied the smallest values between 1-1.9999, 2-2.9999 and 3-3.9999. Is there a formula I could write in column 3 cells...

Hi, everyone! :) First of all this is my first post in this great site of information. I found many solutions in here like filtering data values, sorting and gathering array values in excel. Ok, here I want to ask for some help. The problem is getting smallest date values of C904. In my excel...

How would I state the following in VBA? ... If ActiveCell.Offset(0, 1) > -1 AND _ ActiveCell.Offset(0, 2) > -1 Then ActiveCell.Offset(1, 0) Else Below is my question on how to state in VBA. Would go right after "Else" in the above code" ... Thanks for any help everyone

My current table form is <colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;"> <col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <col width="150" style="width: 113pt; mso-width-source: userset; mso-width-alt...

Hi guys, I have 2 columns (part number A1:A100 and date B1:B100). On second sheet I have just a column with part numbers F1:F10. I want to have a second column G1:G10 in which each cell checks the part number in the F column, does an index match on the A and B columns to get the earliest date...

Hello, I am not a power excel user and while I'm sure this is easier than I'm making it, I'm struggling with the formula I should use. I have used a geocoding software to tell me how far customer addresses are from each of my companies offices. I need a formula that will look at C2:G2 and then...

Hello, I'm trying to solve the below problem using only Excel: -Column A contains dates -Column B contains scenarios number -Column C contains object -Column D contains a risk measure for this particular Object for a given date and scenario My challenge here is to find the k-th smallest risk...

Hi all, I’m using Excel 2013. I swear my VBA code used to work on pivot tables under Excel 2010, but it hasn’t worked for a few months now. We use a year/month code in our database. It’s not a ‘date format’. It’s actually treated as a text field. The month code for March 2014 would be...

Hello, I need help evaluating a range for the largest and smallest values, but I would like to restrict my output based on another range. Assume A1:A100 include values ranging from $100 - $100,000 and column B1:B100 includes percentages ranging from 0% - 50%. I would like to identify the top...

Hi All, I am struggling with getting this to work using Excel formulas. If anyone can help, would be highly appreciated! I have a table that stores Matches between players and records the Winners/ Losers Name. It also shows the State Ranking of the Losing Player. Now I need to create a list with...