# smallest

1. ### PivotTable Sort Multiple Filters Per Field

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.
2. ### Formula to establish next smallest value

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...
3. ### Index and match question

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...
4. ### Sorting in Array

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)...
5. ### Sort by percentage (small to large)

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...
6. ### Using SMALL function to determine smallest of groups

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...
7. ### VBA - quickest way for multiple sort depending on criteria

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...
8. ### Lookup First "Smaller-Than" Value Within a Specified Date Range and Return the Value and the Date the Value Occurs

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...
9. ### Formula that can determine the pair of values that gives the smallest difference

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...
10. ### First Value in defined Range

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...
12. ### VBA - Smallest number in range (greater than -1)

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
13. ### Two way lookup with smallest reference value

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...
14. ### smallest out of all index-match results

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...
15. ### Smallest number - fill in this field name

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...
16. ### The k-th smallest elment of a sub list defined dynamically form a super set based on 2 criteria

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...
17. ### Can't seem to hide the "oldest" year/month code in a pivot table via VBA

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...
18. ### Largest and smallest values, restricted

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...
19. ### Counting the first and second best ranks for a ranking spreadsheet

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...
20. ### Returning Smallest/Largest Value of Multiple Matches With Index-Match

I am working on a pressure loss calc worksheet and need to have an index match formula return the smallest/largest value from the matches. I have replicated what a typical sheet would look like below. Each Pressure In cell has the formula...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...