Get instant live Excel expert help to learn how to find max and min in Excel?

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a min closure time on a range of data, I need to discount '0' and no data
Solved by B. B. in 28 mins
hello i need to solve some excel sheet logic please be good expert i met earlier was unable to solve it and was horrible in replying as well and took alot of time i need to do it within 5-8 min please help please dont connect to that earlier expert again
Solved by O. J. in 15 mins
I need the formula to find the unique values from the list of values in a column. Please do not connect to previous as I wasted 60 min on it without any solution and He/she was asking me to find the solution. So please dont do that if you cant solve it then please confess that. As it would help me not wasting my time with that expert!
Solved by M. S. in 20 mins
i need a formula to minus 30 min intervals per cell that is not empty from a base of 24 hours my array range is c5-c53 each cell represents 30 min from midnight to midnight.
Solved by C. S. in 19 mins
I am trying to make a graph that has a y-axis as "blood pressure" and x-axis as "time" (3 minutes, 6 minutes, 9 minutes, 12 min, etc.) however, I also need 4 other labels on the x-axis (systolic male, diastolic male, systolic female, diastolic females). I need the 4 labels with each time interval, so at 3 minutes I need all of those and then with 6minutes, etc. I don't know what to do. If you could help that would be great ! Thank you.
Solved by D. L. in 21 mins
Some items may already be on backorder so we do not wish to order these again. In column I write a formula to check if the item is below min stock level and NOT on back order, if both these criteria are met look up the quantity to be reordered for that unit type (per), otherwise just put 0 (not in quotes).
Solved by C. C. in 28 mins
i want to create the format of stock of material for eg: in excel we have 10000 pcs of paper stock and we have ordered 25000 pcs of paper in that 5000 pcs have dispatched balance has to dispatch min should be 20000 pcs if that cross the min it should highlet in bold and with big size
Solved by G. H. in 28 mins
i Need a formula to help calculate Redundancy payments. this is what is needed for full time people. it needs to calculate this. Full time annual salary/ 52.1429 weeks = weekly pay weekly pay x redundancy entitlements in weeks = redundancy pay example i have is =ID((D2A<2,"",IF(D18+D19)/52)) = weekly redundancy payment. the Min must be 509.... so if the figure turnd out to be 345. i need the command string to put 509 in instead as there can not be value of less then 509 in the outcome section.
Solved by B. J. in 27 mins
I am using excel solver to choose three out of 14 potential facility locations, based solely on transportation costs from 10 existing warehouses. My constraints are a limit on the number of monthly trips to two of the locations and I also have a couple sites that can't be serviced by certain warehouses. I am having trouble coming up with the min if formula to use.
Solved by O. L. in 16 mins
I am in need of a formula to calculate a number in the time format but into a percentage. Here is an example. If I have someone who worked 41.57 this week, I want it to separate the 1.57 into a separate column, and then convert the .57 into a percentage number, which would be .95 of a 60 min period.
Solved by B. D. in 24 mins