# Highest Permutation Value

May 5, 2007

This is for an online sports management game I play. Basically I have calculated each players skills in each position, and I need to find the best combination of the players on the field to give me the best team.

I have a table as below, and I need to find a solution that gives me what the best combination will be....

## Permutation/Combinations

Aug 3, 2009

Can this be done in Excel? Using the digits 0,1,2,3,4,5,6,7,8,9 create all the permutations/combinations with limits on some of the digits. The digits 0,7,8,9 can only be used a max of 3 times in any one permutation/combination, digits 2,3,4,5,6 can only be used 4 time in any one permutaion/combination, producing a 5-digit string.
Example of expected results.
0 1 0 2 7

## Permutation List

Sep 18, 2009

I am trying to create a list of permutations in a column for example I need a list of numbers 1-20 with no numbers repeating. This is causing my head to hurt and I have been working on this problem for some time.

## Create A Permutation Of The Numbers 1 - 7

May 11, 2009

I have been asked if I can create a pseudo Lottery/Bingo card of 7 images with no repeat cards. The best i can tell is that I need to create a Permutation of the numbers 1 - 7. There should be 5040 combinations of unique possible cards. My problem being I don't know how to create this Permutation in Excel.

## Bulk Permutation Of Words

Jan 27, 2008

i have read through all threads about permutation, and also a few others. I if I were an Excel Pro I would probably have been able to come up with a solution to my problem based on all the suggestions made, but unfortunately it is (still) all a bit too complex for me.

The problem:

I have between 2 and 5 lists of words, each list in one column:

Column A

red
green
yellow
black
blue green
pink

Column B

shirt
jumper
blouse
coat
t-shirt
skirt

Column C

for women
for men
for girls
extra large
for boys
one size fits all

Column D

## Create A Permutation List

Feb 20, 2008

I have several items that I would like to combine, lets call them characters A, B, C, D, E

Each character is situated in a different column, next to each other. Below, I would like to create a list of all possible combinations of these characters. The sequence is not important and each row should contain a unique combination of characters.

I have counted 31 combinations for the ABCDE set, namely

1 for ABCDE
5 for A, B, C, D, E each
5 for choosing 5 unique sets of four from a set of five (5!/(4!*(5-4)!)
10 for choosing 10 unique sets of three from a set of five (5!/(3!*(5-3)!)
10 for choosing 10 unique sets of two from a set of five (5!/(2!*(5-2)!)

To complicate matters, I have several other character strings where I would like a list of combinations. For example A, B, C, D, E, F, G, H 9 (a longer set).

By the way, each combination should be spread accross several columns (e.g. one colum per character, see the question marks in the table below) ....

## Every Possible Number Combination/Permutation

Aug 22, 2006

Can Excel work out every possible combination of 3 numbers from a numbered set 1-24.
I need every combination of 3 numbers.

## All Permutation And Combinations Of 4 Letters And 4 Numbers?

Jan 18, 2013

getting All permutation and combinations of 4 letters and 4 numbers?

## Sort List Based On Permutation

Dec 16, 2008

I'm new here, google helped me to find this place. Hope someone here can help me a bit on my excel spreadsheet. I have one list of numbers and it need to be sorted under Perm condition so the list become shorter. The function should go through the listed number and output new list after sorting it. I have attached my excel here.

## Permitted Permutation/Combinations With Some Rules

May 25, 2007

I have found this very challenging, and have really confused my self on how to systematically approach this. I have the user enter the value in the black highlight boxes, some subtraction produces a base value, the user may also enter the tolerance of the working value (base value), effectivlly giving rise to a small range to generate the permutations from.

What I would like to do then is find all permutations of the inventory (letters in the sheet) with their corresponding values right above them to the small range determined via the user (working value and tolerance). There are also quantity limits for each item. There four basic rules that need to be adhered to:

1) Permutation can't have both S and PP, so one or the other
2) Sum of H and HN must be greater or equal to sum of S and PP
3) H or HN or both must be present, so their sum cannot be zero
4) If HN is less than or equal to 2, and H is greater than 2, then NA and NG must equal 0.

## VBA Extract Highest And Second Highest Values

Nov 27, 2013

I'm attempting to put together a script which in simple terms finds the 'Highest and Second' highest activity and associated FTE for a given sub group.

To be more specific:

On the "Slide 1" sheet look at the values in column J starting at row 7 until blank;For each value, then search the "All Monthly Direct Activities" sheet in column C for the same value, excluding the 'Subtotal' rows;Where a match is found, compare all the values in column E for that sub group;And Find the highest and second highest figure;

Once these are found copy this figure and associated value in column B and paste onto the "slide 1" sheet.

I'm not particularly well versed in writing VB, but I've been working with the code to see if I can get this work, which I have been unable to do.

I have attached a file which may perhaps provide a greater detail than my description of the problem containing the 'Source' and 'Destination' sheets.

## Quick Max :: Possible To Show The Next Highest Rather Than The Highest

Jan 15, 2008

If I use =MAX(A1:G1) I get the highest value. Is it possible to show the next highest rather than the highest and if so how?

## Getting Value From Next-highest 'header' Row

Jan 28, 2009

I have a worksheet that contains a number of rows. [Thank you, Captain Obvious!] These rows are logically grouped to represent a series of "items", with each item having one or more rows (with a "header" row at the top). The rows for a particular item represent different types of information about that item, and therefore make use of different formulas based on the row type. Due to the relative complexity of the formulas in these rows, I am creating a series of row "templates" from which I can copy and paste every time I want to create a new item or add rows to an item. As such, I am trying to avoid direct cell references to different rows, as these would easily get messed up during cut and paste. Instead, I am trying to limit myself to various lookup functions (e.g. OFFSET, MATCH, etc...) that will work regardless of where a row is added.

In order to accomplish this I am using a "key" column to group all rows for a particular item together. Until now I have had to type in the key value for every row for a particular item. What I would like to do is to only have to type the key value in the header row, and have a formula populate the key value in all subsequent rows ... until a new header row is reached, at which point the new key value will be used. Take a look at the following example: ....

## Highest And Lowest Value

Aug 4, 2009

I'd like to record the highest / lowest value in a single cell without it being written over i.e record the highest value and if there is another value lower it wont overwrite it.

I've tried using the =max or =min but whenever a newer value appears in the cell it just follows that without keeping the higher value?

## Getting The Second Highest Value From An Array

May 23, 2007

Is there a way to get the second highest value from an array in vba?

## Lookup Next Highest Value

Dec 2, 2008

I have an excel work book that has distances in column A from A2:A10 like so:

ABCD
15013401400
240
3900
4800
5600
61400
71200
81100
91150
101600

I would like to compare the value inputed into cell C2 against the distances and return the exact match or next highest distance to D2 if there is no exact match.

i.e. If 1340 is put in Cell C2 I would like excel to return 1400 to cell D2 as 1400 is next highest distance from 1340.

Here is the kicker, the distances cannot be sorted and I would prefer not to use VBA but I will if i have to.

## Highest Letter In A Row

Jan 7, 2010

I'm trying to list the latest revision of a drawing in an issue sheet spreadsheet. What I need is to be able to enter a formula that will find the highest alphanumerical value in the columns beyond. Alphabetic characters take precedence over numerical - i.e., drawing issue numbers usually follow a 00, 01, 02, 03, then switch to A, B, C, D,... order.

To try and illustrate what I mean a little better, I have the following table, with dates in DD/MM format. Sorry it's not laid out too well, my HTML isn't great:

Drawing title latest revision 01/01 02/01 03/01 04/01 05/01 06/01
example010001AB
example02000102
example0300

I want the cells in the "latest revision" column to report the highest value. So, I want it to say this:

Drawing title latest revision 01/01 02/01 03/01 04/01 05/01 06/01
example01B0001AB
example0202000102
example030000

I won't have control over the numbers and letters reached (i.e., the drawing revision could get up to Z or something - or the number revision reach 15 before switching to alphabetic revisions) so I'd rather avoid having to set up a crazy IF function with "00", "01", "02", "03", "04", etc etc. But -

## Highest Time

Jan 13, 2010

I have 2 columns of times (military) I need to highlite the highest time. Can this be
done with conditional formatting and how can I do that?

## Retaining Highest Value

May 14, 2006

I am starting to use formulas and I am constantly amazed at the power of Excel. I am trying to write a spreadsheet and I'm having a problem getting Excel to do what I want; I have 2 column, each cell in Column 1 will have a numeric value changed daily. I want Column 2 to retain the highest value that has been added. i.e. If I type 4 in A1,(for example), on Monday, then B2 will read 4, if I type 5 in A1 the next day, then B2 will change to 5, but if I type a value less than 5 in A1, then I still want B2 to read 5. The value will be input daily for an indefinite period and needs to be user friendly. I can't work out how to achieve this.

## Look Up Highest Scores

May 9, 2007

What is the best way to look up and return the 10 best performers out of a list of say, 40. I have columns representing people's names, their school's name, their age and their total score. The following formula is to add up the 4 highest scores for each school: SUM(LARGE((\$A\$2:\$A\$499=Y2)*(\$C\$2:\$C\$499),{1,2,3,4})) (entered as an array) Now I want to display the 10 best performing schools (who will be determined by calculating their 4 best scores).

## Find Highest Value For Each Day

Dec 24, 2007

I have a massive amount of data made up of values taken every five minutes over several months. I want to find the highest value in a day for every day. I'm wondering if the best method is to define each day as a dynamic range and then use the max value command to get the highest value?

## Return Highest Value From Within Group

Jan 31, 2014

I have a data table in which the values are reported daily. I have created a pivot table using this data and grouped the dates in to week long blocks.

What I require is for the group value to return the highest values found within the 7 day period, this would link with the grand total column.

________A B C D E Total
01/01/14 1 1 1 1 1 5
02/01/14 1 1 1 1 1 5
03/01/14 1 2 2 2 1 8
04/01/14 1 1 1 1 1 5
05/01/14 1 1 1 1 1 5
06/01/14 1 1 1 1 1 5
07/01/14 1 1 1 1 1 5

In this example when grouped by week i would get the result:
__________________ A B C D E Total
01/01/14 - 07/01/14 1 2 2 2 1 8

I have also attached a sample spreadsheet.

## Return Value With Highest Frequency

Apr 9, 2014

I need a formula that can lookup the sell price with the highest frequency. For example, I need to look up item 2100 in sheet2 and sheet1 contain data for vlookup like this:

ID No_Frequency Sell Price
2100 4 2.99
2100 5 3.49
2100 1 1.99

I need to be able to look up and return the sell price of 3.49 since it has the highest frequency.

## Return Column Of Second Highest Value In Row Where It Is Same As Max Value

Jun 13, 2014

I have a row of numbers (per example below) and I would like to return the column header for the max value and the second highest value, even when the second highest value is the same as the max value.

For example

A B C D E Highest Second Highest
1 2 3 2 3 C E
3 1 3 2 2 A C

The return values are under the highest and second highest column headers?

## Using Highest Of 2 Numbers In Formula

Jan 20, 2014

I'm trying to wrap up a spreadsheet and I'm trying to figure out how to have my formula use the highest of 2 numbers when making a calculation.

For example:

If:
Cell A1 = 5000
Cell B1 = 3828

I want the formula to use A1 in this case. However, if the total of B1 = 6000, I want the formula to use B1 instead of A1 in the calculation. (A1 = 5000 will always be a constant/base).

## Pull Top 3 Highest Values

Jan 28, 2008

I have a column of numbers that I would love it if Excel could pull out the top 3 or 4 highest values from the column.

## Find Highest Value From Range

Mar 31, 2009

I have a large spreadsheet of data that contains 3 columns: Columns are Name, Revision, # of items. I want to find the # of items for the highest revision for each name. List looks like this:

Smith, 1, 30
Smith, 2, 36
Smith, 3, 18
Johnson, 1, 125
Johnson, 2, 130
Lopez, 1, 8
Lopez, 2, 12
Lopez, 3, 15
etc…

I'm only interested in the data for the latest Revision. There's over 500 names. A lookup or pivot could be possible?

## Formula To Look Up The Highest Value From A Range

Apr 20, 2009

i want my formula to look up the highest value from a range (the =max column), then return a name in the leftmost column. What it actually is, is a player of the month for fantasy football. Each week the player gets a score, then each month, a total of four weekly scores. i want to look up who scored the most and return the player name to me. see the attachment.

## How Do I Look At 3 Cells & Add Together The Highest & Lowest Value?

Sep 24, 2009

Could any of you Excel bods please help me find the correct formula to enter in order to calculate the following reasonably simple sum:

3 cells with numbers, say, 1, 3 & 7.

I simply need to get my worksheet to look at all three cells and then calculate the result of adding the biggest and smallest number together. i.e. 8 in the example given.

## Find Highest Value With VLOOKUP

Nov 8, 2009

using vlookup I am trying o find the highest value>>>>

e.g

Column A Column B

111036 01/05/09
111036 08/08/09
111036 09/10/09 <<<<

Is vlookup the correct way to go,,, if not could someone point me in the correct direction