Identifying The Highest Value Displayed From A Cell
Jul 15, 2008
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 10 Replies
ADVERTISEMENT
Dec 22, 2013
I have a number of workers in one column and how many dvds they have sold for the week in another column. how would I automatically identify the worker from the worker list who has sold the most dvds in that week? is there a formula for this?
View 11 Replies
View Related
Jun 19, 2014
I am trying to write a formula that shows the best grade for each each student and the subject in which
that grade was achieved.
In a previous post i was shown how to identify the highest grade
MAX(IF(A$3:A$34=A7,C$3:C$34))
I hit CTRL, SHIFT & ENTER to activate the formula - Result in column E
However, I also want to identify the subject in which they scored their highest grade in column F
I have two problems
1. I don't know how to write a formula that brings in the subject based on the grade for each student
2. I don't know how to write a formula in case there is a tie (see DAVID L)
View 11 Replies
View Related
Nov 27, 2011
I've data from A1 till G1. Now I will hide column B & D I just want to have total of displayed columns that must ignore values written in column B & D
View 1 Replies
View Related
Jan 3, 2012
I want to sum cell A1 and result will be displayed in B1
AB1ValueResult29292.50*10+8952*15+8550*10
View 9 Replies
View Related
May 24, 2012
I have the following data on a spreadsheet created by a formula:
A1: 1.1234
A2. 2.234
A3: 3.34
I have the data formatted to only have two decimal places so it looks like this:
A1: 1.12
A2: 2.23
A3: 3.34
I'm using the following formula in cell B1 to display the values of those cells in a single cell in order A1,A2,A3:
=A1 & "," & A2 & "," & A3
However when the values of A1, A2 and A3 appear in the in cell B1 they appear as: 1.1234,2.234,3.34
Is there a way I can edit the formula or format something so the values in B1 appear as with only two decimal places? i.e 1.12,2.23,3.34
View 3 Replies
View Related
Sep 21, 2009
I am trying to have a cell in a diffrent work sheet display information from another sheet.
I entered ='Weapons Table'!A48 and it is displaying in text not what is actually in that cell.
on the cell above it I have entered ='Weapons Table'!A47 and it displays fine.
I've tried typing = then just clicking the cell, and it is still just displaying it as text. I've spent 3 days on this sheet and have only 1 error, that is driving me crazy.
View 11 Replies
View Related
May 14, 2014
I have some data that has names but is not consistant i.e
Smith, John
Smith,John
I want a formula that says, if there is a space after the comma do nothing, otherwise insert a space between.
I have figured out the second part so my formula will look like
=if(some logic to identify a space after the comma ,"",already figured out this bit)
View 5 Replies
View Related
Jun 10, 2013
I want to sort a spreadsheet based on whether any of the numbers '1', '2' or '3' appear in a particular column.
There are 2 particular rows which I care if they have a '1', '2' or '3' in them, let's say row 17 and 18.
I want to create a formula say in row 20 which would tell me if there is a '1', '2' or '3' in the corresponding cells in EITHER (!) row 17 or 18.
An example to clarify:
Cell A17 = 1
Cell A18 = 2
Then Cell A20 would be = 1 because both A17 and A18 have a '1', '2' or '3' .
2nd example:
Cell C17 = 1
Cell C18 = 0
Then Cell C20 would be = 1 because C17 has a '1', '2' or '3' .
3rd example
Cell D17 = 6
Cell D18 = 12
Then Cell D20 would be = "" (Null - no value) because neither D17 nor D18 has a '1', '2' or '3' .
Note: I am looking just for the numbers '1', '2' or '3' not (!) numbers like 11, 12, 13, 21, 22, 23 etc...
View 4 Replies
View Related
May 17, 2007
Sheet 1, column A, has invoice numbers from 1 to whatever is needed for the month.
How can I get Sheeet 2 (the following month’s) to automatically start numbering from wherever Sheet 1 leaves off?
View 3 Replies
View Related
Aug 15, 2014
I'm typing the formula straight into the cell and funny thing happens: the cell displays the formula, but not the result...
SO now I can see =A2+B2 and no values.
View 5 Replies
View Related
Nov 20, 2008
Take the displayed date from a cell, in this case formatted as yyyymmdd, and simply display the date as plain text, not converted to the 1900 date system. For example, I have a date cell that reads 20080610, but everything I have tried returns 39609. But I want it to return 20080610 in plain text so that I can use RIGHT and LEFT functions to extract the year, month and day.
View 2 Replies
View Related
Jul 29, 2013
Is it possible to display only one character when using drop down menu? For example, if the drop down choices are A=...., B=...., etc., is it possible to only display the A or B in the cell after you've made your selection?
The purpose of this spreadsheet is to obtain data that will be entered into an application. So it would be very useful if it could be printed on one page - and the columns only show A, B, C, etc. Also, as it is now, the spreadsheet is difficult to work on because there is so much visible text.
View 1 Replies
View Related
Oct 29, 2007
his is of Jaafarian proportions. This is in relation to an earlier post on dragging and dropping. That is all worked out thanks to help from board members. For the sake of your own curiosity, this project will tile worksheet windows (actually specific ranges from other worksheets and other workbooks), borderless, within a single userform and allow dragging and dropping between ranges that reside in different workbooks. That is all worked out as well. The only roadblock I am running into right now is that I cannot edit directly in the cell when the worksheet is displayed in the userform. Probably has something to do with placing a worksheet in a userform to begin with.
CTRL-R to show the form or run maco, "ShowForm". If you double click a cell and attempt to go into edit mode, it will appear to be locked up. It's not, just hit enter to escape the cell. The problem is the userform is a child window of the application. Hence, focus can pass to the parent window or another child (the formula bar in particular) which is exactly the behaviour expected. How do I get around this?
View 9 Replies
View Related
Jan 28, 2008
How could I create a calendar?
I have the month displayed in cell A1.
Cells A2 - G2 display M T W T F S S
How could I have the cells below this display the correct date, on the correct day, depending on the month displayed in cell A1?
View 9 Replies
View Related
Mar 26, 2013
I am working with some fairly long formulas and I am looking for a way to highlight those cells AND work in the document. I know you can click in the cell and it will highlight them, but if you click off the cell the highlights go away. Is there a way to keep them highlighted?
View 1 Replies
View Related
Aug 9, 2007
I need some vba code that will enable the users of my spreadsheet to populate a range of active cells with their Windows Username,time and date.
Quite simply I have approx 30 people accessing one spreadsheet and each person needs to update some info on the page.. So what I want is a time stamp so i know at what time they finished their updates and will also confirm their usernames...
View 12 Replies
View Related
Aug 28, 2009
I have a bunch of images which I want to be able to display in different cells depending on certain values or conditions. Say for example you have a drop down box with a list of fruits. When you pick a fruit, it displays its picture. Is this possible? If all of the pictures exist somewhere on the sheet, can you reference the pictures to have them appear in a cell rather than having images always "floating" over the sheet?
View 3 Replies
View Related
Dec 1, 2009
Is there a way to reference a cell value instead of using a static value for col_index_num? For example - Instead of telling it to look in the 5th column of Sheet2, I would like it to look in the column were the heading (row 2) in Sheet2 is equal to the value of O2 in Sheet1.
Here's another example -
Normal formula: VLOOKUP(a2,Sheet2,5,FALSE)
What I'd like: VLOOKUP(a2,Sheet2,column where row 2 equals the value in 'Sheet1'!O2, FALSE)
View 7 Replies
View Related
Jul 9, 2014
As i am working on consolidating the Missing numbers manually, whether will it possible for making this automatic.
In Column "A" I have Multiple Duplicate Invoice Numbers and followed by the Different Transcation numbers in Column "B".
In Column "D" I have Each Invoice Numbers and in Column "E" Total Transaction Numbers i.e., no. of times each Invoice have Transactions.
In Column "F" No. of times we received the Transactions.
Here i need to manually need to update each Invoice's Missing Transaction number in Column "H" in single cell with comma separated to each Missing Transaction numbers.
Example:
Before : (Column "A" & "B")
Invoice NumbersTransaction NumbersInvoice NumbersTotal Transaction NumbersReceived Transaction Numbers
A2014000351501 A201400035150 3 2
A2014000351502 A201400035494 13 12
A2014000354941 A201400035881 12 11
A2014000354942 A201400035884 19 17
A2014000354943 A201400035888 14 13
A2014000354944 A201400037613 5 1
A2014000354945
[Code]...
Instead of doing this manually can we have the VBA to auto Update these missing numbers.
Here by i am attaching sample file.
View 1 Replies
View Related
Jan 7, 2013
I am trying to find a way to write a Macro that will auto color multiple cells based on what data is displayed in one cell. The cell I want to reference is a vlookup cell.
Basically this is a part label. And depending what part is selected from the list my vlookup will display its position on a vehicle(i.e.. FR, FL, RR, RL, Etc..). So if vlookup comes back with FR I want the various cells on the label to be orange, etc..
ALSO: if there is a way to embed it so it does this automatically (rather than run the macro each time).
View 7 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
Feb 25, 2007
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 9 Replies
View Related
Jan 28, 2013
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.
View 3 Replies
View Related
Dec 30, 2012
I have % figures in the following cells, E20, G20, I20, K20, L20, F24, H24, J24, G28, I28, H32, F16, J16, G12, I12, H8.
These figures are the result of a formula of other cells, with constantly changing values, therefore the % figures are constantly changing as well.
What I would like to do is highlight the cell with highest % figure, ideally to 'flash', either cell colour or flashing text.
View 7 Replies
View Related
May 4, 2006
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 Related
Aug 4, 2007
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 4 Replies
View Related
Dec 22, 2005
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 10 Replies
View Related
Mar 2, 2012
pictorial representation find highest in the cell
data & output
View 1 Replies
View Related
