min

I am trying to use the MIN formula to return the oldest date from column C if the two IF statements are true. Example of data below. I have tried the following formulas in Excel 2010 but they didn't return the correct information. Any help is greatly appreciated. =MIN(IF(D:D="Yes",AND(E:E="<=...

Is it possibel to put a small Picture in several Cell's like this way after nothing have happen in any cell for few minuts like "screen saver.." first cell show picture after 5 min then fadeout and show up in another cell and so on just a Funny idea…..

Hope someone can help me, I'm trying to identify the earliest date in the month (of January) from a range ($J$13:$J$320). =MIN(IF(1=MONTH($J$13:$J$320),$J$13:$J$320,"")) (Ctr+Shift+Enter). It works like a charm, as long as the range doesn't contain a blank cell, which it does...

Good Morning The code below highlights the Minimum value in Columns 1 to 4, Rows = Array. Currently working with only one issue. If there is an identical Min value in the specific range the first min value will be the only value highlighted. Stumped on how to highlight both or all identical min...

Hi all - have been trying to write an IF with VLOOKUP nested statement. I would like to look at the first table where the PICK column is negative (TABLE 1) and vlookup the next table to see if stock is available.(TABLE 2). Then reverse the process later from table 2 to table 1. I have over...

Hi all So I have a table of data, with the columns being the months of the year. Each row has a range of data, with some or all months having values entered. <tbody> A B C D E F G H I J K L M N O Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sum first 2 Months 1 5 6 8 6...

Hello. I'm looking for some help with the following: I need to find the mode of an array that changes based on the day of the month and which shift im looking at. Ex: <tbody> Day 1 1 1 2 2 2 3 3 3 Shift 1 2 3 1 2 3 1 2 3 Level Empty Min Min Max Min Max Empty Max Max </tbody> If I...

Hello Everyone - I'm looking for the VBA code that I can use to automatically adjust the min and max on both the primary and secondary axis on each graph within my spreadsheet. I have found the code to adjust all min and max on each graph, but that same code doesn't work when I have a graph...

I am aware that the MIN function in Excel returns the min value in a defined range. What I’m trying to do is to return the min value of a rolling time period. Let me explain. I have two columns: date and withdrawals (in dollars). The date starts 10 years ago. Let’s just say the date range is...

I have multiple "Tickers", but with different dates. I want to find the oldest date, based upon each ticker (Column C is the end result I am looking to get). Note that sometimes, there is only one Ticker, while other times, there are 2, 3, or more. I cannot figure out what to do. Office Excel...

Please help me look for a formula to get the maximum and minimum value based on certain criteria. Thanks. <tbody> Client Campaign Sent Unique Opens Opens rate Product1 Campaign1 20 14 70.00% Product1 Campaign2 18 11 61.11% Product1 Campaign3 10 8 80.00% Product1 Campaign4 9 6 66.67%...

Hello, I tried some vba examples but couldn't quite get the following to work. I have about 50 charts per sheet on a worksheet. Is it possible to change the y axis for the 50 sheets on a sheet with vba, without affecting the other sheets? Right now for example, I have MIN: 0 MAX: 50 MAJOR...

As the title says, I want to subtract n from min value first and then the remainder of n from the max value. I thought I had it cracked until one of the values exceeds n. My formula is =IF(C4=D4,C4-(B/2),IF(C4<D4,MIN(SUM(C4:D4)-B4,0),MAX(SUM(C4:D4)-B4,0))) for bot AA and BB...

Hi all, Struggling a bit with retrieveing a the MIN date for a value that has multiple dates. I have a list of values on one tab and on another, i have a further list of values with dates attached. I need my formula to look for the value from tab 1 on tab 2 and then, return the MIN date from...

Hi Excel Champs, Please help me getting this calculated I have data like this <tbody> Date Emp Code Emp Name Productivity AHT 15-02-2018 726462 ABC 254 10 Min 15-02-2018 734840 DEF 123 12 Min 15-02-2018 746569 GHI 656 3 Min 15-02-2018 726462 ABC 153 20 Min 15-02-2018 734840 DEF 345...

I have 2 worksheets. The first work sheet has my raw data. The second worksheet has a list that I am trying to find the max and min values of the raw data and the sum. My data is not sorted. Worksheet 1 <tbody> A B C D g 1 4 10 e 2 3 12 g 1 2 14 g 4 4 16 e 3 5 14 f 2 6 13 e 4...

Greetings All, My Question today is how do I set a min and max for a Spin Button within my VBA Code below. The code I am using currently to increment .1 changes. This is working fine but now it will be necessary to limit the amount a person can change with the SpinButton. Thank you in advance...

I have a data showing 4 variables that i would like to plot on a single graph. Time: X axis (in 5 second intervals) Temperature: Y axis. I would like to plot Target Min Max Peak The first 3 data sets look like this. <colgroup><col><col><col></colgroup><tbody> TYPE TimeString...

Hello, I want to get highlighted Min & max Value in the range C4:C19, this range contain error value #N/A is there any formula that can be used for conditional formatting in this case Like this...

Hello all, I am looking for some advice on how to set up a formula to allow me enter student marks for answering parts of a question The question 3 parts (each part of the question has 5 marks each) and a student may answer any two parts. their marks are capped 10 marks so the maximum that can...