# 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....

View 9 Replies
ADVERTISEMENT
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

View 9 Replies
View Related
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.

View 9 Replies
View Related
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.

View 4 Replies
View Related
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

View 9 Replies
View Related
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) ....

View 9 Replies
View Related
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.

View 3 Replies
View Related
Jan 18, 2013

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

View 2 Replies
View Related
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.

View 7 Replies
View Related
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.

View 4 Replies
View Related
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.

View 9 Replies
View Related
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?

View 9 Replies
View Related
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: ....

View 14 Replies
View Related
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?

View 12 Replies
View Related
May 23, 2007

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

View 9 Replies
View Related
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.

View 9 Replies
View Related
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 -

View 9 Replies
View Related
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?

View 9 Replies
View Related
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.

View 5 Replies
View Related
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).

View 4 Replies
View Related
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?

View 6 Replies
View Related
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.

View 2 Replies
View Related
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.

View 4 Replies
View Related
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?

View 5 Replies
View Related
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).

View 4 Replies
View Related
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.

View 12 Replies
View Related
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?

View 3 Replies
View Related
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.

View 2 Replies
View Related
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.

View 8 Replies
View Related
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

View 4 Replies
View Related