Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










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:
Rounding Up A Cell Value To Next Highest Whole Number
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 Replies!   View Related
Finding Highest Number And Printing Anothers Cell Value
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 Replies!   View Related
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
Extract Text & Number From Cell
How can i extract text and number from a cell .For example I have a series of data like 453x, 45y in Column "A". I want text in column "B" and numbers in "C" column. The cell has variable data with diffrent length.

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
Highlight 2nd Highest Number
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.


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
Overwrite Highest Number
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 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
Taking Next Highest Number
I have a dilemma. What I want to do is: If I input a date in a cell I want the adjacent cell to take the next highest number from a list on another worksheet. My example attached

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 Jones---56. In cell b1 I have another name i.e.,
Johnson---45. How can I subtract 45 from 56, take 60% of the difference
and in cell c3 show the following; Johnson---6. All numbers are to
rounded down to 0. The final result would look like this;
a1 Jones----56, b1 Johnson----45, c1 Johnson----6. I have other cells
with the same type of info in them. Example; a2 Smith----34, b2
Jones----78, c3 would show Smith----26.(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
Return Highest Number With Date
column a has dates & column d has values - what is formula to find highest number in values and return it's date (using =large(Dxx:Dxxx, 1) to find highest number

View Replies!   View Related
Return Based On Highest Number In Row
Formula: ......

I am looking for the value in column G, a formula that will search B-F and return the Group with the highest percentage for each zip.

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
abc-09-001.xls
abc-09-002.xls
abc-09-003.xls
abc-09-004.xls

Next available filename should be "abc-09-005" 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 1-7 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
Quick Max :: Possible To Show The Next Highest Rather Than The Highest
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 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
Extract Two Digits From Number
I want to extract the fifth and sixth digits from an 8 figure number i.e. 20010891 would equal 10.

I have tried every combination of Left & Right combined with Find that I know and nothing works.

View Replies!   View Related
Extract A Row Number From A Range
I would like to know if it is possible to extract just the number of a row from a range. for instance range("c5") would give a row number of 3. Its probably simple but its evading my attmept to work it out.

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 Street Number From Address
I have a list of street addresses. I want to alphabetize them. I just want to remove all the text (usually just numbers but not always) up to and including the first space only.

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.

ab24s-12-g4a

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. egg12-6-z2z). 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) egg12-6 --> would return 6
3) egg12-6-g2c --> would return 6
4) egg12-g2c --> would return 12

View Replies!   View Related
Extract The Total Number Received For The Various Scenarios
I have a spreadsheet with 4 columns named:

type
date received
time received
number received

Is it possible to use vbscript and extract the total number received for the various scenarios:

all numbers received
numbers received before specific date
numbers received on specific date before specific time
numbers received after specific date

View Replies!   View Related
Extract Number From Alpha-numeric 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
Formula To Lookup The Numbers From Above And Only Extract A Number Once
I have a spreadsheet on a weekly data with diferent reference names
e.g.
101
101
101
105
105
101
101
109
109
114
114
101
101

what I want is a formula to lookup the numbers from above and only extract a number once
e.g
101
105
109
114


View Replies!   View Related
Extract Number From Alphanumeric String Located At Different Row
What is the formula to be used to extract number from a alphanumeric string located at different row?

example:
test123test128test131
test124test129test132
test125test130test133
test126test131test134
test127test132test135
test128test133test136

result: ....

View Replies!   View Related
Extract 7-digit Number From A Mixed String
I am trying to extract a 7-consecutive-digit 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 Number In Column + Delete The Rest
I have the following which is in a column.

View Replies!   View Related
Extract The First 5 Characters In A String, And Convert Them To A Number
Say I have a string "09800EBHR052708"

How would I take the first 5 characters and get a number out of them?

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
Extract X Number Of Characters Followed By Specific Character
How can I extract mid section of the string which is always 5 characters long and is always followed by a period "." ?

My account strings are in 3 sections (but the third section isn't always used)

For example,
1.10210
1.22556.001
900101.56201
955261.54444.001
5566625.58886.957756

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
Conditionally Formatting Highest Valued Cell
I have 7 rows in the same column of type percentage. I'd like to turn
the text of the highest valued cell red. How exactly is that done with
contional formatting (vs. IF statements for each cell)?

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
Extract Fraction From Text Without Converting To Date Serial Number
I have a cell with the following text in it that is being imported from a website "5/1 Smith T win". What i want to do is extract the "5/1" part without it being in the format of a date. I want it to be extracted in the format "?/???". I have entered the following formula to extract the "5/1"

View Replies!   View Related
Countif (extract The Number Of Times A Name Appears On A Certain Range Of Cells On A Worksheet)
I am trying to extract the number of times a name appears on a certain range of cells on a worksheet, now I can get this to work, but I am sure there is a better way I just cant get it to work!

=SUM(COUNTIF(sales1!$B$8:$F$11,A18),COUNTIF(sales2!$B$8:$F$11,A18),COUNTIF(sales!$A$8:$B$11,A18))

I have only used 3 pf the worksheets, but in time there could be up to 30.

View Replies!   View Related
Extract Character From Date Format & Number Of Days Between Date
I have two questions regarding date format and hope you can provide input.

1) say 01/01/2010 displays as Jan-10 and i need a new column to state it as JAN. What function should i use to achieve it?

2) i need to state the difference between first day and last day of the month. What function should i use to achieve it?

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved