How To Find The Biggest Numbers

Apr 22, 2014

I want to create a formula that values if the number in the cell is in the biggest 25 numbers in the column and also check in another column the same thing.If the number is within the 25 biggest from the first column or the second then to give me the number of the cell. I created a formula but it is very large in order to apply for the 1st to the 25th biggest number. The formula is:

IF(AND(or(K16=LARGE($K$16:$K$152,1),I16=LARGE($I$16:$I$152,1)),K16<>0),K16,"") but only for the 1st biggest number of the columns.

View 2 Replies


ADVERTISEMENT

What Is The Biggest Difference Between Numbers?

Mar 6, 2009

The attached sheet has two rows of numbers. The top one shows used energy, the bottom one produced energy. What I need to know is during what period of the day one has the biggest difference between the two. In this case this is between 1400 and 2000, 28 used and 9 produced (a difference of 19). The question is how this difference can be determined automatically?

View 7 Replies View Related

How To Find The Biggest Value On The Sheet

May 21, 2007

i have one sheet of data (numbers)
How to find the biggest value in this sheet?
Is too many numbers...

example:

A1
1.12
3.14
5.16
2.11

the biggest is = 5.16

View 9 Replies View Related

VBA To Find Nearest Biggest Number And Lowest Number?

Mar 26, 2014

I need a VBA code to find the nearest biggest number and nearest lowest number between the data of D2 to H2. In the attached file, I have mentioned my required output (Column A and B - blue highlighted)

View 2 Replies View Related

Biggest Value In A Column

May 31, 2006

I have a column, Column A. It has numbers, how do I create a loop that finds the biggest number in that column?

View 4 Replies View Related

Finding A Name With Biggest Number

Feb 2, 2006

I have a hockey scoring sheet, which has player names, goals and assist with it. What I want to do, is to print in to a different sheet player's name and goal amount, who has scored the most goals.

Example of a scoring sheet:

View 11 Replies View Related

Return Biggest Three Value In Every Column

Feb 26, 2009

i want to give me the biggest three value in evry column
as show here in the table

#123456789101112Max_1Max_2Max_3Item_1299242125337148718323298445727102552393948115244Item_2242716194629563225502082559525342959133655124421Item_3455828445295587555555875418534073598426013194389Item_4390156585416347250301403516015655246267636873711Item_5188727551589244431265659417542195533396516004724Item_6126947325832581357662528574353554011451551032154Item_7153536252203199715785849547836595209164541812305Item_8269417022795180521133892393929963348152850762866Item_9366353801726203742892207485436273497184517322414Item_10396556815031362225614483311627081528424020274103Item_11131435895482502656452278207422582673309942034475Item_12299533682560392230732014482554313483215330063366Item_13452648175613126941863069177221443608500257084066Item_14211549493056283920553149183421443441368513243752

View 10 Replies View Related

Finding The Biggest Value In Custom List?

Apr 26, 2014

I know how to make customs lists, but it's not getting me anywhere.

Let's say I have a lot of data containing values as follows and in the following list I sorted them from small to large:

5a
5a+
5b
5b+
5c
5c+
6a
6a+
6b
6b+
6c
6c+
7a
7a+
7b
7b+
7c
7c+
8a

and so on... In the list, the date isn't sorted from small to large, many values (if not all) occur multiple times and on occasion some values are added to the column. With that last part I mean that you can see it as a batch of 500, and if so far the batch only contains 450 values there will be (for the time being until items get added) 50 empty cells in the column as well.

You can't order numerically or alphabetically. I know I can make a custom list and then just sort according to that custom list so the biggest value would come out on top or bottom but that's not what I'm looking for either, as the data needs to be sort by another colomn (dates in chronological order).

So I'm just looking for a formule saying "return the biggest value if the order of things is as I typed above'.

View 14 Replies View Related

Function To Returns Biggest Change (+ Or -)

Feb 1, 2010

I have some survey data for 2008 & 2009. I have a column calculating the difference on each question between the two years. I need to show the 20 biggest changes, positive or negative. Which function can I use for this?

View 9 Replies View Related

Order Lines In Decresecenting Classifitcation And Sum The 5 Biggest

Jan 13, 2008

I need to do a decresenting classification of data available in lines (2 hundreds of lines). I have headers in the columns that cannot change position. Then I need to sum the 5 biggest values in each line.

View 11 Replies View Related

Find Missing Numbers And Added (new) Numbers

Jul 14, 2013

I have two columns of numbers (this week - Column A and last week - Column B). What I need to do is look at the numbers and pull two lists out in Columns C and D. In columns C a list of the numbers that are missing from last week in column D numbers that are missing that were added from the previous week. The two lists consist of about ten thousand rows of data.

******** language="JavaScript" ************************************************************************>
Microsoft Excel - Book3___Running: 14.0 : OS = (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp
(A)boutA1=ABCD1This WeekLast WeekMissingAdded
21002103110311002310271032103210274103310331034104051035103410361055610371036 
165571038   81040   91055   101655   Sheet1 [HtmlMaker 2.42]

View 2 Replies View Related

Find The Formula That Is Used To Find These Numbers

Dec 26, 2009

The first 7 digit number is the input to a certain equation. This equation outputs the 7 digit number after the space.

Input (7146127) ==> Equation ( Unknown) ==>Output (2871082)

These are some data that I have ( inputs and outputs). I was wondering if there is anyway to find this equation. I can get more data if that helps in finding the equation.

71461272871082
53820056426572
61070709150530
75833373805331
55466908456008
49264716615511
12387558353260
20013928484175
67975657084961
38006283229553
68973249414920
65179634653276
66971872613128
59646203411273
69785611400836
58284602307740
64723009925464
57930863495088
58816593932906
62736335606616
52119154778580
60043359437317
61921553996320
51507747216899
13197956063818
64210347411256
65399671193442
55656585589500
55148886441637
30850639587521
69081133766387
54139417804940
53408393698534
62310293191095
30512556590168
14514168265124
89078208134056
85177364363577
68714858216023
17584065849687
52691521917548
9840524785846
59268687494601
89374963791119
45989738961270
65040033345415
15061518946940
55392084949214
45103824265242
84181944909073

View 9 Replies View Related

Find Whole Numbers In Row Of Data?

Apr 9, 2014

##UPDATED## Hello

understanding the IF forumlas to calculate rows with whole numbers in them for the last columns

CBOOK1.xlsxBOOK1.xlsx

View 5 Replies View Related

Find Average Of Last 4 Non Zero Numbers

Nov 27, 2008

I am trying to figure out how to take the average of the last 4 "non-zero" numbers in a series of values.

The sheet looks something like this, numbers are all in one row:

7 , 7 , 7 , 7 , Total = 28 , 8 , 8 , 8 , 8 , Total = 32 , 0 , 0 , 0 , 0 , Total = 0 , 8 , 8 , 8 , 8 , Total = 32 , 7 , 7 , 7 , 7 , Total = 28 , 8 , 8 , 8 , 8 , Total = 32 , 0 , 0 , 0 , 0 , Total = 0 , 8 , 8 , 8 , 8 , Total = 32

I'm looking for a formula that will look at all the last few totals (starting from the end) and take an average of the last 4 totals that were > 0. In this case it would average {32, 32, 28, 32} ignoring the 0 total.

View 7 Replies View Related

Find Particular Numbers And Change

Jul 28, 2013

I have a workbook that has 3 columns (G, H I) with numbers from 1 to 7 in each column. I want to tell excel that if a row has a particular 3 numbers in these cells then change it to a specified number. I want to do this for the entire workbook. Is this possible?

View 3 Replies View Related

Find The Maximum Numbers In Each Day?

Aug 19, 2014

a macro finding the max number in col B in each day (hr 0- hr 23) and in col C put a "1" next to it.

View 10 Replies View Related

How To Find The Most Common Numbers

Apr 9, 2009

I have 300 number groups and each group has 22 different numbers (from 1 to 80).

Can I find the most common 5 or more numbers in these groups by excel, macro or any program?

for example, let us suppose that 4-15-23-36-45 are the most common numbers and these numbers are in 8 groups from 300.

View 11 Replies View Related

Find Sum In List Of Of Numbers

Jan 4, 2006

I have a list of numbers in a column and I need to find which numbers
when summed together equal a figure. I have a list of invoice amounts
that I need to match up with payments (the payments are always made for
several invoices so I need to come up with sums of several invoices to
get to this payment amount).

An example would be I have this in the following section (A1:A10):
$17,213.82
$4,563.02
$85,693.42
$1,166.01
$725.90
$580.09
$2,243.75
$240.16
$207.70
$725.90

I need to find which combination of these figures would sum $1,173.76.

View 14 Replies View Related

Go To Next Worksheet To Find Corresponding Numbers

May 12, 2008

I have a file with 2 worksheets: Worksheet "Data" contains Store Locations, Store Numbers, Categories, Brands, Sales, Clusters, % Demand, etc.

Under % Demand on Worksheet "Data", I need a formula to look for % Demand from Worksheet "Stores" that related to the same categories, brands and stores numbers.

View 14 Replies View Related

Find The Frequency On Numbers

Feb 24, 2007

(1) i have a project of a series of numbers running left to right in a random order what i am after is to sort them into order

(2)i want to find the frequenzy on numbers and how often they apear with other numbers compairing one line to the rest all the way threw

View 9 Replies View Related

Find Missing Numbers

Apr 17, 2008

I have a file with approx 3600 rows. In Col B there is a 13 digit EAN-13 code. I would like to find out which numbers are missing. I have to compare each cell from top to bottom in the B-column to the cell below and find out if there are some missing numbers. If the numbers are incremental then goto next cell. But if there's a gap in the numbers then it should insert the missing numbers with an increment of 1.
I think the logic statement should look like this:

i = 1
For x = 1 to last row
If the gap between B(i) and B(i+1) < 1 then
Insert a row and put the missing value in the cell on the new row.
Endif
i = i+1
Next x

The comparison has to be made from the 5 digits in place 8-12 in the code.

Here's an example (i've dimmed the digits that shouldn't be compared):

7330985920714
7330985920721
7330985920738
7330985920776

As you see there's a missing number between the third and fourth row. Here the value should be 733098592074 + the checksum that is a bit tricky to calculate.
Between the fifth and sixth row there are four missing numbers that has to be filled in.
The checksum is OK to leave out at this moment. The important thing is to get the 5 digits.

View 9 Replies View Related

Vlookup Cannot Find Numbers

Nov 8, 2006

I have a very large database (42455 lines) which has three columns. The column A is a shipment number which is a combination of numbers and letters, column B is a ship date, column C is a dollar value for each shipment. This range (A2:C42455) is named SHIPMENTS. I have a second database right next to it that contains warranty information. Column D has the shipment number, Column E has the date the warranty call came in. These last two columns have only 2788 lines.

I'm using VLOOKUP in column F to match Ship dates with Warranty Call dates. The formula is:

=VLOOKUP(D2,SHIPMENTS,2,False)

and was dragged down all 2788 lines.

Out of the 2788 lines it did not find dates for 301 of them. Some of those 301 have Shipment numbers that are only numbers (no letters). As a test I copied one of the "unfound and all numbers" shipment numbers and did a control+F for all of column A and it found it. Clearly VLOOKUP is missing some of the Shipment numbers. I made sure that the Shipment number in column A matches the number in column D by cancelling out of the Find window and clicking on the found cell. Then I made sure there are no stray spaces tacked onto the end of the number and there were none. I hit enter.

At this point excel starts calculating again and when I go back up to the VLOOKUP (In column F) it has now found the data I've asked it for originally. I've not changed any of the values of either cell...All I've done is use Control+F to manually find the Shipment number in SHIPMENTS and then verified that there were no spaces in the found cell by clicking on it and using the arrow keys. Once that was done I hit enter.

Somehow this sequence of actions allows VLOOKUP to now find the cell.

View 5 Replies View Related

Find The Numbers That Add Up To A Certain Number

Feb 14, 2007

Example:
I have a worksheet that has a column with amounts in it. I would like to find the numbers in that column that add up to a certain amount.

View 9 Replies View Related

Find Numbers From Various Rows / Columns?

Mar 2, 2013

I am trying to find some number which i have from a list of numbers available in various rows, for eg

11

7
11
13
17

i am tryng to find 11,13,14,15,16.... 38 from columns given i.e. 7,11,13,17....

View 3 Replies View Related

Find Like Numbers Over Two Spreadsheets And Highlight

Mar 16, 2014

I have two spreadsheets. Spreadsheet 1 has 6 columns and column E has a list of numbers. It runs from E2:E739.

Spreadsheet 2 has 9 columns and column A has the numbers I need matched against. Column A runs from A9:A5027. How can I find the numbers from Spreadsheet 1, Column E that are also in Spreadsheet 2, Column A. Once matched I would like to highlight the ROW on spreadsheet 1 that has a match.

View 3 Replies View Related

Find & Replace On Character Numbers

Aug 7, 2009

I currently have: ...

View 8 Replies View Related

Find And Replace Phone Numbers

Dec 8, 2009

I have a bunch of phone numbers that I'm trying to reformat.

Say I wanted to replace any phone number like this: 1##########

With this: ##########

Keeping the numbers intact, just getting rid of the 1 in front of them. Can't figure it out for the life of me.

View 6 Replies View Related

How To Find Differences In A Column Of Numbers

Jan 11, 2014

I've got a list of numbers and want to show the difference between the highest number and each of the other numbers. Here's an example: (The first column is the position, the second column is the number and the third column is the difference.)

1 - 20
2 - 18 - 2
3 - 15 - 5
4 - 14 - 6
5 - 11 - 9

View 4 Replies View Related

VB Code To Find Unique Numbers

Jan 26, 2014

Please refer to attached sheet.

I have numbers in column A thru G.

I need unique numbers from this list in column J as shown.

View 3 Replies View Related

Find Min Of 4 Numbers And Delete That Number

Feb 3, 2014

I need to find the minimum of 4 numbers placed in 4 columns and delete the one which is minimum among them. I know to find minimum I can use min function but i don't know after finding how can i delete that automatically. Also problem is if two or more numbers are identical and minimum value it has to delete any one of them.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved