“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I'm trying to configure a timesheet calculator for California overtime and I need to get the regular hours to be max 8 hours or the total hours that they worked in the day without summing over 40, once the regular hours get to 40, it needs to stop counting them. Please help!

Solved by K. H. in 13 mins

I am looking for formulas that will display the actual numbers based from smallest to largest from a column of numbers (for example, if A1=1, B1=4, C1=2, D1=1, and E1=3 (each of these values can actually be anything from empty to 7)
I would like G1=1, G2=2,and G3=4.
G1 is easy. use the formula "=if(sum(a1:e1)=0,"",min(a1,e1))"
G3 is also as easy, using the formula "=if(sum(a1:e1)=0,"",max(a1,e1))"
I can not figure out how to get G2 to show the number in the middle (or in the event of 4 different numbers, how to find and show the middle 2 numbers respectively)

Solved by M. S. in 19 mins

I want to highligth MAX if it is >0 from cells that are not in range.
The cells are in the same row, but at different columns. For example, the cells of interest are C2, E2, G2, I2, M2, O2 and Q2. Each mentioned cell contain a positive or negative number.

Solved by O. L. in 14 mins

Hello, I am looking for an inventory formula where one column states my max then next states how many I have available and the last is how many I need to order. I would like for the "available" column automatically transfer the amount I need in the reorder column. For example, if I say I need a max of 10 in stock but I only have 4 available I would like for the reorder column to automatically change to 6.

Solved by G. Q. in 28 mins

In the attached script, the sheet ''Huvudark'' is off importance. In this sheet, please have a look at cell: R19. This Cell is the sum of the column R3:R18. The rule for this column is that it can never be over 32 dB, but should be as close to it as possible. Now here is the issue I need help with: I need a formula for Column O3:O18, it needs to change with the In-data that you can find in Column B11:31. Everytime that data changes I need column O3:O18 to adjust accordingly so that the condition for cell R19 is upfilled (max 32 dB).

Solved by S. E. in 18 mins

I need a formula to tell me if a product is standard, medium or large if i input length, width and height data worked with the following restrictions
Standard is:
Max dimension <= 52cm, next Max <= 33cm and Min <= 30cm Medium is:
Max dimension <= 120cm, next Max <= 80cm and Min <= 80cm Large is:
Max dimension > 120cm, or next Max > 80cm

Solved by B. L. in 18 mins

hi i want to compare two columns in excel from one cell with data from column A:A and if a second cell AB9 can be found in the second sheet in column Q:Q i need it to look up the maximal value from the 10th column - if the second value AB9 can not be found it should just show me the max value from column 10 without the second variable AB9
=MAX(IF('SAP - DATA'!A:A=I4,IF('SAP - DATA'!Q:Q=AB4,VLOOKUP(I4,'SAP - DATA'!A:L,10,FALSE),""),VLOOKUP(I4,'SAP - DATA'!A:L,10,FALSE)))

Solved by Z. L. in 30 mins

I have a range of data where I am trying to create a Chart that is very versatile. I have roughly 50 columns with a potential of 1250 rows. All the data falls within the same time range, but the frequency of the data varies (some data points are every day, others are weekly and others are bi-monthly). That means that each row does not necessarily correspond to data from the same date.
What I would like this chart to have is dates on the X axis and on the Y axis use multiple secondary axes (max 4 or 5). I only want to display certain variables on the Y axis at a time, but be able to choose those variables from a ticking box. thanks!

Solved by D. S. in 13 mins

I need a formula for 5 cells, each to have a max percentage of 100, for max value calculator which max value is 100 also.

Solved by I. S. in 14 mins

Out: Max 522.63 kbps, Avg 28.45 kbps, Last 3.33 kbps
Out: Max 94.02 bps, Avg 80.61 bps, Last 94.02 bps
Out: Max 2.26 Mbps, Avg 260.99 kbps, Last 1.67 Mbps
Out: Max 0.00 bps, Avg 0.00 bps, Last 0.00 bps
Out: Max 223.12 kbps, Avg 6.21 kbps, Last 2.83 kbps
Out: Max 21.49 kbps, Avg 6.37 kbps, Last 4.24 kbps
Out: Max 3.16 kbps, Avg 2.32 kbps, Last 1.85 kbps
can i quick select the words and numbers between Avg (numbers) kbps?

Solved by D. L. in 21 mins