-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
largest values
-
V
Forcing Moving down the Array
<tbody> Meal 1 Meal 2 Meal 3 Meal 4 Meal 5 Meal 6 Meal 7 Tot Meal Cals 710 479 710 479 710 231 231 Protein 142 311 284 311 497 185 115 Carbs 355 168 284 120 0 0 115 Fat 106 0 106 48 106 0 0 Fruits/Vegs 106 0 35 0 106 46 0 array...- vincecodegreeen
- Thread
- array largest values
- Replies: 9
- Forum: Excel Questions
-
C
Absolute with Large function
I have a column of numbers both positive and negative. I want to get a table of the 4 largest absolute values WITHOUT having to create another column of those numbers as absolute values. I tried LARGE(abs(A1:A34),1) - then 2,3,4 - but it came back #NUM. Any thoughts?- corinnejacobson
- Thread
- absolute values formula combining largest values
- Replies: 6
- Forum: Excel Questions
-
A
Excel Lookup and choose to return the largest value of a each month
I used the formula below to get the last monthly price of an item ={LOOKUP(9.9999999E+307,CHOOSE({1,2},0,LOOKUP(2,1/((Market!$I$2:$I$9998<>"")*(TEXT(Market!$A$2:$A$9998,"mmm-yyyy")=B11&"-"&A11)),Market!$I$2:$I$9998)))} In fact, I have 2 separate columns for year and month (referenced by B11 and...- AlGuy
- Thread
- choose function largest values lookup
- Replies: 8
- Forum: Excel Questions
-
C
Conditional Format of top 80%
I could really use some help on a "custom" conditional format that would highlight the cell values in a column that would cumulatively total to 80% of the column total. For example in the following list of numbers, with blank cells in the column, highlight each of the largest numbers that...- cycle_simon
- Thread
- conditional formatting largest values
- Replies: 5
- Forum: Excel Questions
