In excel how can find the largest value in a column?

Question

In Excel I have two columns one for days (A1=M, A2=T, A3=W) and another for hours (B1=3, B2=5, B3=5). What formula can I use to first identify the first cell with the largest value- 5 and then identify the first day that had the 5 hours? When finished I would like to have a cell showing 5 and an ajacent cell showing the first day it occurred T.

Answer 1

u can do it by sorting, filtering i know , other participants already gave u that so i'm including this one

for largest value
=MAX(B1:B3)

note the reference value of this cell in the left top

for corresponding day
=LOOKUP(cell reference value of max,B1:B3,A1:A3)

i think it's the best answer

Answer 2

Here are two ways to do it -

Method 1 -
1. Add headers to A & B (call them Day & Time)
2. Highlight Row1 & click on Data > Filter > Autofilter
3. On the B column, use filter > Custom > select "Is Greater Than or Equal to" then enter "5" on the right side
4. Click OK, now you should see all the Days that have a 5 or more hours

Method 2 -
1. In column C, cell C1 enter the following formula:
=If(B1>=5,"Yes","")
2. Copy this formula all the way down in C column
3. Now you should see a "Yes" showing up in C column whenever the hours are 5 or more

Answer 3

John, short answer is: definite you're able to try this! I particularly have performed very lots an analogous earlier. right this is how: a million) Create a itemizing in another portion of the sheet. The record could comprise the textual content textile labels "Very Low" and so on. and adjoining to the record (to the terrific) may be the numerical value of that textual content textile. multiple lists, one for each scoring classification is appropriate with the aid of validation step 2 under. type each and each record alphabetically ascending order by making use of textual get right of entry to, no longer by making use of variety! 2) in the columns the place you enter the textual score, use documents validation to cut back entries. spotlight the get right of entry to cells, click on documents, then validation, go with "record" and choose the cells with the record of valid textual entries. hint: could be in comparable sheet yet you may continually conceal the columns. Now the cool section: 3) In formulae used for scoring, in basic terms use the examine function to get the numerical score adjoining to the textual score out of your itemizing. that's that straightforward! you additionally can positioned the numerical score into column beside the textual score immediately on each occasion an get right of entry to is made. which could be a great factor to apply IF function at the same time with examine function. Plus you may conceal that column besides. i'm hoping you detect this effectual. If a greater unique occasion is needed then please deliver your pattern to my e mail QwertyKPH @ Yahoo and that i will supply a working occasion. variety Regards, QwertyKPH @ Yahoo!

Answer 4

If you use the autofilter feature, you can see all the days that something occured, or you can sort very easily.

Select the row that your column headings are in and then click Data menu>Filter>Autofilter. Your headings should have a triangle beside them. Click the triangle and scroll down to 5 and select it. Your data will be filtered to only show the 5 in your column. You can see all your data again by either selecting the data menu>Filter>Show All, or you can select All under the column that is filtered.

Answer 5

sorting won't work?