Extract The Highest Number In A Row To Another Cell
I 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.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Extract Number From Text Cell
I have an extract from a call logging system; one of the columns is a description of the call (this column is extracted in Text format). Within some of the descriptions is a reference number which I need to extract (sadly this number isn't kept in its own field)  is there any way to determine whether a cell has numbers in it, and if so is there a way to pull them out into a seperate column? (preferably using a formula as I'm no good at VBA!)
View Replies!
View Related
Formatting The Highest Number In A Row
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?
View Replies!
View Related
Lookup Second Highest Number
I 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.
View Replies!
View Related
Round Up To The Highest Number
this is a formular that i used to divide =IF(Z6=TRUE,K6/MID(D6, FIND("1=",D6)+2,LEN(D6)FIND("1=",D6)1),K6) the problem i have is that if i have 14 in cell k6 and 1=10 in d6 the answer i get is 1.40 what i need the formular to do is always round it up to the highest number ie 2 not 1.4 example 1=10 20 answer 2 1=10 25 answer 3 1=4 11 answer 3 1=4 20 answer 5
View Replies!
View Related
Lowest/Highest Number Cells
I have a data listed from A1 to G1. What I want to do is Check out all the numbers written in those cells, take the highest number among and write to the following cell (lets say A3) also Check out all the numbers written in those cells, take the lowest number among and write to the following cell (lets say A4)
View Replies!
View Related
Find Highest Number Based On Name
In sheet 1: I have a list of customers and their current credit limit In sheet 2: i have a list of all payments received in the last 12 months. my customers credit limits are set by multiplying their highest payment in the last 12 months x 1.25 (e.g. payment of $1000 x 1.25= limit of $1250) what i want to do is: 1) look at the customers in sheet 1 2) check sheet 2 to see if they have made a payment 3) return their highest payment (if any) in sheet 1 Col. C 4) i can work out the rest
View Replies!
View Related
Subtract The Lower Number From The Highest
I have name and a number in this format: cell a1 Jones56. In cell b1 I have another name i.e., Johnson45. How can I subtract 45 from 56, take 60% of the difference and in cell c3 show the following; Johnson6. All numbers are to rounded down to 0. The final result would look like this; a1 Jones56, b1 Johnson45, c1 Johnson6. I have other cells with the same type of info in them. Example; a2 Smith34, b2 Jones78, c3 would show Smith26.(rounded down) I always want to subtract the lower number from the highest and take 60% of the difference.
View Replies!
View Related
Highest Number In Row Then Info 23 Lines Down
I am attempting to pull the Highest number out of a row of cells. Then grab the info 23 lines below. What I have is a spreadsheet that pulls from other spreadsheets and tracks all of my sales for the year. This is divided up into tabs for each day of the week. I am a formula to find the highest sales for Tuesdays {LARGE(Tuesday!B8:BB8,1)} then in the cell below it I need it to show the date that days sales happened on. That date is listed 23 lines lower. I have tried using {HLOOKUP((MAX(Tuesday!B8:B88)),Tuesday!B8:B88,23)}. This kinda works. It pulls from the 23rd line but only from the first column. Not the column that has the highest sales. I have searched for a solution but I must not be typing in my question correctly.
View Replies!
View Related
LIST Funtion: Find The Highest Number ?
I have several worksheets where I input data, and I would like a 'stats' page as worksheet 1. Work sheet one is a list of names in cells A4:A28. column B,C,D,E,F, and G contain the results using Countif. How would I now get excel to look down a column, for example B, to find the highest number in that column and then use the name from that line but in column A.
View Replies!
View Related
Highest Number From File Names In Folder
I need a macro which checks for next available number from list of filenames in a folder. Then it returns that value to one predefined cell in a new document (here Untitled.xls). For example: c: est has the following files: Untitled.xls  read only abc09001.xls abc09002.xls abc09003.xls abc09004.xls Next available filename should be "abc09005" and macro returns that value to predefined cell in a new document (Untitled.xls). There should be NO saving at this point whatsoever. Macro simply picks the next value from a filelist. As you've noticed the value has some constants too. New document doesn't know the last picked value before macro is active (predefined cell should be empty at startup).
View Replies!
View Related
Vlookup (search All Of Column A For The Highest Number In The Range)
I WANT it to search all of column A for the highest number in the range (which will change daily to a new high number above the highest currently), and return the value in column 4 (column D) that corresponds to that value from column A. This is what I have, but it is not working, it is giving me the number (1) in Cell A800 (which is the lowest valued number in my range. The numbers range in value from 1 to 762 with none repeating (they are sequential). The formula I have is : =+VLOOKUP(MAX(A76:A2000),A76:I2000,4)
View Replies!
View Related
Indirect Address/match: Pull The Highest Number
I am trying to do season stats for my roller derby league. I have a great spreadsheet going but the one thing I want to do, I can't seem to do. I am attaching a "test" file. very simple and small but shows what I need to do. I have different sections and I am trying to pull the highest number out of that section. For this example, it is under the green Jams Skated: Jams at Jammer. The number on the right is the highest number of jams skated while the number on the left should be the name of the skater who has this number. Okay, no problems there. My problem occurs when I try to move these same formulas to another sheet. in this case, sheet 2. It pulls all kinds of strange things.
View Replies!
View Related
Formula To Count Highest Number Of Continuous Cells With Data In A Range And Their Sum
I have a range of 30 cells in a row. From that row there are groups of cells that have data that might be 17 cells populated in a row and in between these groups are blank cells in the row. I need to see what is the highest number of cells in a continuous row that contain data, what the mode is for continuous cell counts, and what is the average value for the data from the continuous cells. The average is a nice to have but not entirely necessary as most cell data will be fairly similar and I can get a close enough average just by knowing the average number of cells that contain data in a row. I have to do this calculation for about 1000 rows of individual data so its important a formula fit in one row. Almost need a count function to count starting with each cell and then stopping at the first no no value it finds. Then it would show those counts and I could run a formula to pick the highest count and also show the mode of counts. I will let the experts at it!, my weak mind could not think this one through. I thought something to do with MATCH for a while but no go from what I could do.
View Replies!
View Related
Extract Even/odd Pairs From A Number
I would like to know if its possible to extract just the even/odd pairs from a number. Exp. I have the number 123 in cell A1, and would like to extract the even/odd pair, which in this case would be 13, the cell A2. I would like to be able to do this without the use of "Isodd" or "iseven" functions.
View Replies!
View Related
Extract Top Row Number After Filter
I have to find out the top first number aftet filtering the data based on particular column. ie each time when i am taking each filter value the row will start from different number. so how to find the top row number after filter? U got what i mean?
View Replies!
View Related
Extract And Merge Number
how can i extrac & merge number to set with three digit. on my sample image if i has number of Ditgit#1,Digit#2 and Digit#3 on "Result" title. How to make fomular with out VB to extrac each number and Merge number 3 digit/set on "Extrac and Merge number" title.
View Replies!
View Related
VBA Function  Extract Number(s) In String
My knowledge of functions is pretty limited, or negligible to be honest. I require a function to extract numbers from each cell in a selected range. Eg. cells contain the following data: cell 1: xxxxxx 45,59 cell 2: x xxxxx xx 6,45,27 cell 3: x xxxx 28 were x represents text I need to loop through each cell and extract each of the numbers and list them in a separate range. If applied to the above range of cells the function would show the below in the ouput range. Each number in its own cell. 6 27 28 45 45 59
View Replies!
View Related
Extract A Number And Name From Middle Of Text
I have a several hundred rows of data that are telephone line type, number and user name all concatenated. This is the way the data arrives. I need to extract the number and user name into 2 separate columns  I do not need the phone type. Is there a formula that can identify numbers within text. I can't use Text to Columns as the leading telephone line type varies and I don't want to use VBA to do the work. There are at least 10 different line types, example of some: SPECTRUM TIPT 0740357052 LUNCH ROOM SPECTRUM ANALOGUE 0744076642 J BROWN EXCHANGE LINE (PSTN/PSTN) 0742031346 HAYES SUB FAXSTREAM DUET 0742003232 NORTH SUBSTATION M/BANK (Spectrum) 0740318578 MB TO 4429 P PHONE (TELSTRA) 0744074159 B WILLIAMS WITHIN ANALOGUE 0784625967 I MAKIT the following phones start witn an "N" PRIVATE LINE (PAPL) N7035896P ROTHMANS SUBSTATION PRIVATE LINE (VGDL) VOICE LINK N7563069P P BLACK PRIVATE LINE 2 WIRE PREMIUM (PAPL) N70079 FITZGIBBON G PRIVATE LINE 4 WIRE PREMIUM (PAPL) N70335 SUBS SSKLB Can this be done or will I have to resort to code.
View Replies!
View Related
Extract 5 Digit Number From String
I need to extract a set of 5 numbers from a string of characters. The number set I need is always 5 digits long, always starts with a 1, and always begins after a period. But the number I need can occur in different parts of the string: In each example below I would want to extract only the 10572 portion. 5194003.10572.N 5194003.10572.R 5194003.1.0010785.10572 7500008.N.5999900.10572 Additionally (if possible) if the cell is blank I don't want anything to show up, and if the string begins with a letter then I don't want anything to show up either.
View Replies!
View Related
Extract Number From Alphanumeric String ..
I would like to parse a part number. ab24s12g4a if there is a "#" in the string, that is the value I want. If the "#" is not present, I would like to take the first number. Currently, as written in your first example, I am getting the first number  excellent and thank you! In the sku, the first digit reprepresents capacity. If a second number is present after the capacity portion of the sku (i.e. "#"), that means that they want to order it filled with less than capacity. For instance, a carton of eggs and they want 6 eggs instead of the max capacity of 12. (i.e. egg126z2z). Numbers after the second octet (i.e. z2z) do not matter. It would be a number only in the second octet. If there are characters with it, the equation should disregard it. Here are the scenarios, and what the formula should accomplish 1) egg12 > currently returns 12 2) egg126 > would return 6 3) egg126g2c > would return 6 4) egg12g2c > would return 12
View Replies!
View Related
Extract Number From Alphanumeric Data 
Aguirre: The Wrath of God 552 Ai No Corrida 619 Aileen Wuornos: The Selling of a Serial Killer 821 Airplane! 671 Akira 764 Albero degli Zoccoli, L' 641 [etc] I want to extract the page numbers (the final numbers) and place them into a new, separate column. I am using Microsoft Excel X for Max Service Release 1. I am competent on basic excel but not familiar with complicated formula etc.
View Replies!
View Related
Extract 7digit Number From A Mixed String
I am trying to extract a 7consecutivedigit number from a mixed string (letters and numbers). The only condition is that the number has to start with a "7" or "6" and be exactly 7 consecutive numbers long. My function only evaluates for one and one within the other but not both. It's faulted because it only looks for the occurrance of "6". rCell is the string range. Function ExtractNumber(rCell As Range) If Len(Mid(rCell, InStr(1, rCell, "6"))) > 6 Then ExtractInvoice = Mid(rCell, InStr(1, rCell, "6"), 7) ElseIf Len(Mid(rCell, InStr(1, rCell, "7"))) > 6 Then ExtractInvoice = Mid(rCell, InStr(1, rCell, "7"), 7) End If End Function
View Replies!
View Related
Extract Negative & Positive Number From String
I am using a regular expression in a function to extract numbers from strings. the code I am using is below. Function ExtractNumber(rCell As String) Set RegEx = CreateObject("vbscript.regexp") RegEx.Pattern = "d*.d*" If RegEx.Test(rCell) Then ExtractNumber = CDbl(RegEx.Execute(rCell)(0)) Else ExtractNumber = vbNullString End If End Function...
View Replies!
View Related
Identifying The Highest Value Displayed From A Cell
I want to be able to record the highest value displayed in a cell (b2) in another cell (c2). Cell b2 is a cell that has continuously updating numbers from a live feed, which are updated approximately every second. I'm not sure if I need to have a log created based on the changing numbers. If so, I wouldn't anticipate the length of time to determine the highest value would be more than 7 hours. Is there a function/filter that would be able to report the highest number recorded?
View Replies!
View Related
Compare Highest Value With Cell Above & Calculate
I have a set of values in the 2nd column (Col B). I have shown in Column C (I've added some notes to the right). mon........7..........(first value, so nothing here) tue........8..........na, or ERR.......................... 8 IS the highest value in B, so no math to do yet wed.......10..........na, or ERR.......................... 10 is greater than 8…the new highest value in Col B thu.........8...........(20.00)............................. The value, 8, is 20% less than the Highest value so far in Col B fri..........6..........(40.00)............................. The value, 6, is 40% less than the Highest value so far in Col B..... Namely, any value in Col B that is LESS than the highest, greatest, largest value that has preceeded it in chronological order will reflect by what % it is lower. (Eg, 8 is 20% less than 10). When a NEW higher value appears in Col B, there would be no answer in C (or simply "ERROR", or n.a.), and this new, largest value would be what subsequent values in Col B are compared to.
View Replies!
View Related
Pull/Extract Number Before Specific Character In Cells
What formula or function truncates a text field that is in the following consistent format: number. name ie. 3. Super Bella and 150. Taoist I wish to truncate the field so I have just the integer without the dot, space or word(s). Tried Len, Left & Replace but they require a specific number of characters. Since the number can be 1 to 3 digits long, this doesn't work.
View Replies!
View Related
Extract Number Of Variable Length From Text String
Imagine that I have this list of thousands of customers, who are listed in column B in the format "customer no+space+customer name". Now I want to extract ONLY the customer no from the text string in column B and insert it as number value in column A on the same row. Would have been easy with "Left" command, but as the customer numbers have variable length, I have a problem.
View Replies!
View Related
Extract Number From Number
One column has numbers and text. e.g, cell B4 contains 122 E4. I wish the numbers before the text to be placed in the adjoining cell in the previous column. So the above would now see A4 containg 122 and B4 containing E4. What formula do I need in order to extract the three numbers which begin in each cell and place them in the previous column? I attach small s/s to illustrate.
View Replies!
View Related
