max fiunction

I have a couple of data sets that I need to determine the minimum and maximum values. I have tried (and failed) to configure a formula that essentially says, IF Column A (Keys) contains "P:", then give me the minimum/maximum value of the corresponding value in Column B (Partial). The data sets...

Hello guys, I have a question about selecting the max/min value of the table. Hope someone could help me! So I have a big table (Raw data), and I want to select some data from the big table to populate them into small table Time PQ1 PQ2 PQ3 PQ4 PQ5 PQ6 PQ7 PQ8 PQ9 Gold 2010 ? ? ? ? ? ? ...

Hi I am looking for some one help..my data is as below. <colgroup><col><col><col><col><col></colgroup><tbody> DATE Dept BRANCH Transaction Terminal ID 8-Oct-15 TT MCT IN 21666446 8-Oct-15 TT NIZ OUT 21666434 8-Oct-14 TT MCT OUT 21666446 26-Mar-11 TT MCT OUT 21666760 26-Mar-11 TT MCT...

Using column 'A' as a measure, how would I pick the highest value on Column 'B' - is there a way to do this without ARRAY formulas ? Say I have a layout something like so - if I wanted 'MAX' for the 16th of FEB, it should pick 321.00 <colgroup><col><col></colgroup><tbody> 16-Feb-14 321.00...

My source table in my Excel workbook is populated from a data connection which executes a stored procedure in SQL Server, and is refreshed every time the value in one of the cells that are the parameters for the data connection/stored procedure changes (columns delineated by semicolon): trans...

I'm pulling my hair out on what I thought would be simple. I have a spreadsheeet with 31 tabs for each day of the month starting with tab ONE and ending with THIRTYONE. I want to find the MAX number in all of the Cells D20 across all 31 tabs (no problem using the formula...

Hi everyone, Is there a way to combine the MAX function with multiple IF's?? I know I can do it with a single condition but now I'm trying to make an array formula as follows: {=MAX(IF(AND(A1:A7=1,C1:C7=D1),B1:B7))} Thank you!

sunny boy data. I have a macro to show maximum daily output but I am failing with the time of that max output. Here is the debugging dialogue: Sub maxtime() ' ' maxtime Macro ' Macro recorded 23/04/2012 by mcd ' ' Keyboard Shortcut: Ctrl+q ' Range("D154").Select ActiveCell.FormulaR1C1...