max

I want to Conditional format ONLY THE ONE CELL that contains the lowest value, but only in there is a "1" in the SEL column. For some reason I'm not able to get the correct syntax for the Conditional Formatting formula. In this example I'm working within a table named "data". I want the cell...

Full disclaimer I have only been using VBA for very small projects and have never attempted working with multiple workbooks. I have a user form in 365 that enters data per the form's request. I am using 3 files, an entry file, a database file, and a read file. Between the database file and...

Hi, this is more a a theory question than practical; in the measure ; Tbetween:=CALCULATE([TotalUnits], FILTER(ALL(Table1[Units]), Table1[Units] <= MAX(Table3[Max]) && Table1[Units] >=...

Hi, thanks for help. 1. I am trying to find a max number in a vlookup but my formula is not working (see below) 101 101 3 96 78 So if im trying to find 101 in the table i would do =VLOOKUP,101,table,3,false) but it will bring up 78 but what i need it to...

I'm trying to see which day of the week had the most sales each month. Column A is # of Sales. I'm currently using this formula =VLOOKUP(MAX(A$44:A$50),A$44:B$50,2,FALSE) Because this formula can only return one value, it will return "Sunday" since it is the first in column B with highest...

Hi All, I'm currently doing scientific work and i can't find a way to find to match 2 table to find the closest date prior to the selection. I was wondering whether you experts can help me. As the data i'm working with is confidential i'm making a dummy table to show what i would need. What...

Hi When trying to find the maximum value with a filter condition is there any difference between these two methods and which if either is regarded as better; ; MAX( Table1[Units] ) Then, CALCULATE([MaxU],(FILTER(ALL(Table1[Item]) ,Table1[Item]= "A") ) or...

I have two tables - Parent table listing asset numbers, and another table with records of services for that asset. I would like to lookup the asset number, search the maximum (last date) it was serviced in the records table, and return the comment that is in another column eg: Thank you :)

Im really not sure how to explain this but here goes, Starting from the right, as u can see each item has specific range of KP (from column K and L). We start with item 1 for example, which range from 0.211 to 0.216. Now i would like to match these range to the ones in column A. Once that...

Hi, I have a table like the one below. User Current Stage Stage 1 Date Stage 2 Date Stage 3 Date A Stage 2 15/2/2022 16/4/2022 B Stage 1 10/1/2022 C Stage 3 22/5/2022 26/6/2022 28/6/2022 D Stage 1 14/4/2022 16/4/2022 E Stage 2 15/1/2022 16/2/2022 18/4/2022 I am trying...

I am trying to return the account number with the lowest and highest values. I tried to use this formula to return the lowest value. =MIN(AT3,BJ3,BZ3,CP3,DF3,DV3,EL3,FB3,FR3,GH3,GX3,HN3,ID3,IT3,JJ3) =MAX(AT3,BJ3,BZ3,CP3,DF3,DV3,EL3,FB3,FR3,GH3,GX3,HN3,ID3,IT3,JJ3) Account # Column 206-1...

I have a sheet which keeps a tally of profit, drawdown and the like and I am trying to do a simple calculation, but the answer seems way off. In column CU, drawdown % is calculated. At present there are only 59,200 rows and row 22 is the first row of data. This is the formula to work out the...

A B C D E F G H 1 week 1 week 1 week 2 week 2 week 3 week 3 2 W R W R W R WB RB 3 25 10 30 8 30 12 30 FIND THIS NUMBER I have a table of data that looks like above. I have used MAX function to find the highest occurring number in cells labelled with "W". In cell H3, I want to find...

This isn't a question - just wanted to share a solution I came up with. Others have probably come up with the same solution, but I was pleased with myself for figuring it out on my own. Plus, it was fun! If I want to constrain a formula output, say between +100% and -100%, one popular way to do...

Hi all, I would like to use functions like LARGE, SMALL, MAX, MIN and SUM in spilled arrays and get the values PER row instead of the total. For Example: x y =MAX(A2:B2) dragged down =MAX(A2:B5) 1 2 2 8 3 4 4 5 6 6 7 8 8 The only solution I...

Hello everyone, I am new to the board & thank you all in advance for the help. I have data for the time it takes each step in a manufacturing process & each step has a unique name that never repeats, as seen below, pasted in A1 corner. Steps time Start Point Sum of Steps Count 2800N1 5...

Hello, I have a workbook with 2 sheets, "ProgramMasterList" and "urslabs". I'm trying to lookup the latest Date in column M in sheet "urslabs" and match the values into sheet "ProgramMasterList" in column V using column A as the lookup value in both sheets. I'm using a vlookup to lookup the...

Hi wondering if anyone could help? I have a report on questionnaires I'm doing where I have to return the MAX and MIN values of the results. I first started using the =VLOOKUP(MAX(C4:C12),C4:D12,2,0) formula but it only returns the first MAX value to me but instead I want a formula that can...

Hi, thanks for reading this post! (1) I have a table with the data, like this: Client Salesperson Sales ($) Google Mike 1,000 Apple Jim 5,000 Apple George 4,000 Apple George 3,000 ... ... ... (2) On another sheet, I'm creating a report, like this: Client Frequent/Max...

Hello everyone I'm trying to use the formula =MAX(FREQUENCY(IF(T2:T11>1,COLUMN(T2:T11)),IF(T2:T11>=1,COLUMN(T2:T11)))) to find more than one maximum value before a zero from a range. Column T has this values 1 2 0 1 2 3 4 5 6 0 I want a formula/formulas that will...