max

I have a table (pasted below) showing COMPANY, BRAND, VALUE. I am trying to put a fomula in E2 that looks at the company name in E1, then looks in the table and picks the brand AND the value for ONLY the MAX for the company in E2. So, E2 should come up with BRAND3: 30 F2 should come up with...

Hi All, How to show MAX in row that contain #N/A value ? this is the formula =IF(C3=MAX($C$3:$C$9),C3," ") but the problem is if there are #N/A i can't show MAX. Any help is appreciated.

Hi, I am trying to calculate the maximum sum of values within an hour in column. Because the number of values within an hour isn't constant (see my example below) I'm having a lot of trouble trying to get this to work. As you can see in the sheet below, the times are in column A and the value...

Hello, This is my first time posting in such a forum. I'm not very good with excel but I understand the basics. I've tried looking around the internet for a fitting formula to my problem and couldn't find something specific. I need a formula that will take 2 numbers from Workbook 1 Columns A &...

Hello everyone, Kindly let me know how to integrate the VLOOKUP function with MAX in order to format data of Table 1 for the given query ids as in Table 2. Moreover, I would appreciate it if you could help with the formula to populate the Max identity value in the neighboring cell: MS Office...

I am sure something like this has been answered numerous times but I cannot seem to find something similar. Basically, I need excel to record the max value in Column A in Column B as it goes down Column A. I have attached an image showing what I need from a sample set by manually solving my...

I'm looking for a formula (for Power Pivot) that aggregates within certain groups and across other groups to determine the maximum. Here's my data table: State Customer Fruit Qty NY A Apple 5 NY A Orange 1 NY A Pear 5 NY B Apple 1 NY B Orange 6 NY C Apple 2 NY C Orange 2 NY C...

Dear All, I am looking for a simple formula, which will display the number of days in a year. Kindly help me. Name DOJ EOS 2013 2014 2015 Employee 1 01-01-13 08-08-15 364 364 220 Employee 2 05-04-14 31-05-16 270 364 Employee 3 15-02-14 16-04-15 319 106

I have a table with employees down column A and dates going across (3/20/20 - 4/4/21). Each date is tracked with that person's daily status. I already have a section that counts the totals of each status type, but am now looking to find the min, max, and avg of consecutive dates with the...

Hi everyone, I am trying to build a formula, but no luck. In the yellow cell (N5) I have a drop-down list of months that I can choose from. Currently, month "feb" is chosen. Now, I would like to get max value from the table below, from row coresponding to month "feb", so in this case from...

Hello, I have inlcuded an example chart that I use regularly for work below (assuming it starts in cell A1 - so data range would be B2:AH34). Is there a way to find the max value of this chart, or even the top 5 max values (would be ideal but will settle for just one max figure for now if it's...

Hi, I have a table of sport team, which shows, how many goals (with assissts) 2 players scored together (so if player 5 scored a goal and player 16 assisted on this goal they will have one common goal). There is an example of the table, players numbers are in the first column and row, common...

Hi, I'm making a stock investment tracker where all you have to do is enter in the transaction and it gives you all the your positions, whether they are open or closed etc. I was finally able to figure out a way to find my average cost per share after buying/selling/rebuying. I have a column...

Hi all So I have a table of data - here is an example: A B C 1 Code Stage Final Stage 2 455 Stage 1 3 455 Stage 2 4 522 Stage 1 5 522 Stage 1 6 616 Stage 1 7 616 Stage 2 8 616 Stage 3 9 616 Stage 4 What I'm wanting in column 3 is a formula to return the...

Hi all, I am stuck on a problem. I have need to insert a vba macro into a sheet for my admin team. I want to find the highest value from a range in one sheet and return the value to another sheet if the adjacent column matches. I also want it to return it to the next blank cell in that row...

Hi All, I have a real problem which I just cannot resolve, struggling to even know where to start to be honest! So.... I have a workbook called "Subcontractor Order Record". Within that work book are 2 worksheets, once called "Order Record", as follows: and one called "Payment Record", as...

Hi, I have a workbook with data showing number of visitors at every hour for different dates. I have created another sheet which only shows the total number for each date. At first i used the following formula OFFSET('Sheet1'!$E$2,(ROW('Sheet1'!E1)*16-1),0) to copy the value in the 16th row...

I am a Field Sales rep and I have an excel report of what hospitals I went to on what days. I'm trying to make a heat map using conditional formatting to visualize time passage regarding who I haven't visited recently. I'm using the below formula to pull up the visit date minus today's date...

I have a spreadsheet that for each item calculates the number of days that fall within the financial year and then the cost that would relate to it. The formula is: =I10*((MAX(MIN($Q$1,H10)-MAX($P$1,G10)+1,0))/365) Where:- P1: first date in the current financial year being reported -...

Hey guys I am working on this code and my plan is to go into a worksheet, get the max of column A. And if the max is found then go to the next row over and get the name associated with it. I wrote this code and the value of the name is coming up blank and I don’t what I am doing wrong. Dim...