Cells L5 - L65 have percentages. B5 - B65 Have the associates names. I want to write something in another cell that looks for the highest percentage and then prints the name as the highest.
View 11 RepliesI have a list of names in one column and in the next column I have a list of numbers. The names and numbers go together. In anohter cell I would like to extract the highest number and the name related to it. The list changes often.
I would like to be able to put a heading saying that "name" (in anohter cell) made the highest score and the name is entered into a cell automatically.
I have a sheet, along the top is the Months of the year, to the side I have a list of products. At the bottom of each month in a cell I want to display the name of the product that has sold the most for that moth, is this possible:
I can display the highest number i.e Highest item sold in January was 108, but I want it to write the product name.
I have a whole number value in cell F18. In cell F24 I want to enter a formula that allows me to divide the value in cell F18 by 4 and if the result is not a whole number, round it up to the next whole number.
View 2 Replies View RelatedI am looking for a way to find a highest (and/or) lowest value in a list of numbers. The list keeps getting longer and after a certain point I will need the 2 highest (or lowest), then the 3 highest (or lowest). I know MIN and MAX will find the high and low, but how do I find the 2nd highest, etc?
View 3 Replies View RelatedI have a column of one to three digit numbers (I5:I34), some of which contain an asterisk after them. In I35 i want a formula to find the highest value from that column. Additionally, if two numbers in the column are the same value, but one contains an asterisk after it, it should use that value in I35, instead of the one without the asterisk.
View 6 Replies View RelatedI have a cell containing alpha and numeric. I would like to extract the highest number in the cell
the cell looks like this
the answer I would like is
====G99876554321000
9
T1111111100000000
1
I am using Excel 2010
simple example.
A1 = 155
I need to print 3 pages where B1 is equal to 50 and 1 page where B1 is equal to 5. A1 may change, but B1 will always be multiples of 50, plus whatever is left over.
I have two columns.
A column = contains dates but does not always have 5 days in a week. Holidays are not entered.
B column = price data for each day
All I want to do is get the highest price from the previous week. So for example last week highest price was 5000 then column C will display 5000 for this entire week. I tried using WEEKNUM and WEEKDAY but i am clueless on what to do after that. I'm trying to avoid macros or VB since im not that advance with that. But if I have to I will.
At my work we use excel to keep a large number of labels done in one day, those labels are then added up to give our weeks total, running total and average by day.
What i am looking to do though on a seperate sheet though is find out which day we had the most, an example of what it looks like
I am using VLOOKUP with the not_exact_match set to True, however instead of finding the next largest value that is less than value, I want to find a way of returning the next largest value that is greater than value. I have looked at using MATCH and OFFSET to try and increment the returned value by 1.
View 9 Replies View RelatedI am trying to work out the 'Upper Percentile' of some donations we have received.
To do this I thought it would be rather simple, I just used
Code:
=LARGE(A1:A100,ROW(INDIRECT("1:9")))
This worked but obviously puts the values in 9 different cells, my work would like it shown as 1,2,3,4,5,6,7,8,9 in one cell.
I've got an excel sheet that has a series of successive numbers down the side from 1-15 per sheet. I've done this by putting the cell formulas as previous row +1. (these are being used as unique reference numbers)
I want to be able to print this out multiple copies of this in one instance without having to manually adjust the first number multiple times then print the sheet. I also want it to be automatically saved as the most recent page printed, so that when it's printed the number continues on from the previously printed sheet.
I found a macro online which I have adjusted to increase a cell by 15 each time it is printed (to change the first number of the row). But I've realised that I'm printing the final page twice if I run the macro again. Is there any way to get round this? If I print 1 sheet there is also no adjustment in numbers.
I also haven't got onto the save part.
This is the macro I am currently using:
"Sub PrintSequence()
'
' PrintSequence Macro
' Macro recorded (altered) 8/16/2005 by Roy Wagner
[Code].....
I have a column that updates automatically by placing a value in in the next blank cell in the column. I am trying to write two formulas to identify the highest and lowest values in the preceding 10 cells of each update in the column but seem to be stuck in MIN/MAX/OFFSET hell.
View 8 Replies View RelatedI have a spreadsheet and on sheet 1 it currently has 45791 rows filled with data and it increases each day.
Each row looks like this
A RACECOURSE
B DATE
C RACE DETAILS
D HORSES NAME
E RATING OF THE HORSE
On Sheet 2 I have 3 columns. These are the list of horses that are running on a particular day.
A DATE
B RACECOURSE
C NAME OF RACEHORSE
What I want to do is to be able to list in columns D,E,and F on sheet 2 the last three ratings the horses achieved from sheet 1.
how to acquire the latest rating of the horse by using the following formula.
=IF(ISNUMBER(v(LOOKUP(9.9999999999999E+307,1/SEARCH(C2,Sheet1!$D$3:$D$45790),Sheet1!$E$3:$E$45790))),v(),"")
This works a treat but for the life of me I can't fathom out how to get the formula to pick the latest three ratings and place them on sheet 2.
I am using excel 2003
I have a 2010 Excel spreadsheet where I have a macro set up to print the page. What I need it to do though is to increase a number in a cell and display it each time I print the page.
View 9 Replies View RelatedI have a very large spreadsheet with daily sales for over 140 different items, over the past 2 years.
This is how my data looks like:
ITEM NAME 4/1/12 4/2/12 4/3/12 etc
item1 10 15 500
item2 5 0 3
item3 0 0 5
etc
I'm trying to build a formula that allows me to see which item is the highest trending over a period of time I input.
I figured out the way how to select data between specific Start and End dates, but don't know how to interpret "trending" in a formula.
I was thinking maybe highest jump from beginning to end of interval, but what if it's a new item that was launched halfway through the interval and does poorly throughout, that would still be "trending" under that rationale....
I have a reference value(say 'X') at L3, now i want to select a value next higher to this value(ie..'X') in the column ''C'' say and also i have to print the corresponding values of the row corresponding to B,C,D,E,F etc.
View 1 Replies View RelatedI have a report that is generated from a manufacturing process that looks like the example below. the report is 40 pages long when all the data is printed. i am looking for a way to only print this range if a dimension is "out of tolerance". if the dimension is within tolerance, there is always the "garbage" text of plus and minus. if every row is "within tolerance" in the range the cells in the OutTol column would all contain the "garbage" text but it will not always be identical. so, in summary, actual OutTol values = print and all "garbage" = not printed.
NomActDevLoTolUpTolOutTol
Y-0.956-0.9480.008-0.0030.0030.005
Z-1.413-1.4130.000-0.0030.003---*|++++
DIA0.4220.4240.002-0.0030.006----|+*++
POS0.0160.0110.005
I am having trouble using a cell reference with a VLOOKUP formula. i have 2 worksheets each containing an invoice number column. the first sheet uses the VLOOKUP to find a shipping code from a range of values in the 2nd sheet (the range includes the invoice number, shipping code and 2 other columns). i can get the formula to work by simply typing the lookup_value into the formula like so: =VLOOKUP(7128,'Detailed List'!$B$7:$Q$1500,5,TRUE)
this gives me the correct result but what i need to happen is for the formula to take the lookup_value from the invoice number cell reference in the first sheet for that record and match it to the same value in the 2nd sheet. so instead of the code above it would read: =VLOOKUP('F10','Detailed List'!$B$7:$Q$1500,5,TRUE). the value of cell F10 is '7128'. however, when i try this i get a return of #N/A and no matter what variation i try it still produces the same result.
I need to find the row number of a cell based on a particular value. I am populating a row within a spreadsheet with a value (the columns have unique identifiers). After that is done, I need to go to a different spreadsheet, grab different values, and place them in a different column in the above referenced spreadsheet. So, what I want to do is find the row number for the unique identifier, then place the value in the column.
View 3 Replies View RelatedOn sheet 2 in cell C5 I need it to find it from sheet 1 referring it from the word "Drinks 1" thats in Q1 and so on along the row
View 9 Replies View RelatedHi, sorry for posting this twice but i wasn't sure which category it fell under!
I have a slight problem with excel and and was wondering if anyone can help.
I have 3 columns, A, B, C: .....
The find value will always be the same...its just a placeholder that is randomly inserted. (currently i am using the value "Placeholder"). basically in column B i want to insert the iteration of the Place holder. the attached spreadsheet better illustrates what i am trying to do. starting the count at zero is kind of important, but not the end of the world if it is impossible.
View 3 Replies View Relatedi have duplicate cell entries occuring. I have a column of about 8000 entries (Column B) and would like to have a cell at the top of my spreadsheet that displays where the first duplicate resides (Row No. will suffice).
At present i have a conditional format on dupllicates, but is is a big task to scroll down through all the data looking for them.
I want to get highest number from filenames in a folder.
for example below are files in folder
AB-1234-001.plt
AB-1234-002.plt
AB-1234-003.plt
AB-1234-004.plt So I want to get "004"
XY-12345-001.plt
XY-12345-002.plt
XY-12345-003.plt
XY-12345-004.plt
----
----
XY-12345-075.plt
XY-12345-076.plt Here I want to get "076"
file format is same but some times 4 digits in middle (AB-1234-001.plt) and some time 5 digits (XY-12345-001.plt)
My idea is , counting files ignoring suffix (eg 001,002,003) and count howmany are in folder. So code counts based on AB-1234 and return me value how.
I'm using this CF to show me the largest number in a range;
=F10=MAX(F$10:F$33)
I now want to also show the second largest number in the same range.
I have a few rows in an excel sheet and I want to highlight the highest number(s) in each row.
I've been playing around with conditional formatting, and using the formula:
=$C23=MAX($C$23:$C$55)
in the conditional formatting box and selecting a formatting type, I can automatically highlight the highest number in column C (row 23 to 55). However, this formula only seems to work when I'm selecting columns of data rather than rows. If I want to highlight the highest number in row 23, the formula I'm using is:
=$C23=MAX($C$23:$M$23)
Which I think should highlight the highest number From C23 to M23, but it doesn't - nothing happens.
What am I doing wrong?
in cell A1 i have the balance. i would like to record the balance every time it reaches a new high in cell B1. how would this be possible please using excel 2007
View 9 Replies View RelatedI have a table of information which is sorted in ascending order. I have created a vlookup to find the highest value as close to 1 as possible.
Say it returns the value 0.95.
i now have another cell which i need to find the second highest value from the column of data.
however i dont know how to do it. because the second vlookup function just returns the 0.95 all the time and not the second highest value..
E.G.
Column A
0.70
0.75
0.81
0.84
0.87
0.90
0.95
So in the cell with the first Vlookup i get the value 0.95 returned.
I need then for the second cell to return the next highest value in this case 0.90.
Then third cell third highest
fourth cell fourth highest value etc.