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

So I am trying to create a Vacancy calendar that i can use to compile automatically and distribute the available vacancy week (max 3 employee in vacancy during the same week)
Here my idea:
B5,H5,O5 etc ... are the Week # the employee must choose.
for B6,H6,O6 etc... i used =COUNTIF and take the data from a table where each employee made their choice
On the table, the choice 1 is the one that shall be used if there are 3 or less employee that chose it,
If there is more than 3 people who chose it, the second choice will instead be used and the 1 choice should be eliminated.
I am struggling to find a solution on how the code can determine the priority of employee, cause the older employee will alway have priority over the newer employee.

Solved by E. J. in 30 mins

To do calculations Microsoft Excel follows a specific hierarchy of operators. Which of the following operators is carried out first, second etc.
- a. b. c. d. e. f.
Raise to the power ^
- a. b. c. d. e. f.
With operators of the same order from left to right
- a. b. c. d. e. f.
Innermost set of parentheses ()
- a. b. c. d. e. f.
Multiply or divide / *
- a. b. c. d. e. f.
Plus or minus + -
- a. b. c. d. e. f.
Functions such as Min(), Max(), tan() etc.
a.
fifth
b.
fourth
c.
Third
d.
second
e.
6th
f.
first

Solved by E. Q. in 24 mins

Hello,
Earlier today we had someone very helpful working on the following sheet.
After reviewing I have a couple of bug fixes.
1. In Cell CA70 they had a formula to grab the max times. This really needs to just be set to the start time of the current day. Currently I have added something here just to hack the example.
But as they grab the dates from the CB81 fields onwards then we really need the date to come from there.
This maybe easier if the original person that worked on it does? as they will understand it quickly.
2. We have looked to add the same for all the other runners but it is not quite working the same, eg the blank cells in the highlighted green areas. D70:74 and F70:74 etc.
Kind Regards,
Mat

Solved by E. E. in 30 mins

Please reconnect with last agent that we were just working with.
In regards to the Max Date etc.

Solved by A. Y. in 24 mins

I am trying to calculate our Per Diem rate. they get $100 a day max @$10 per hour.
I how would I write it so that the days that equal 10 hours =$100 and anything less than 10 calculates at the hours worked times $10.

Solved by B. B. in 29 mins

i need to use excel max value for a certain cell

Solved by K. L. in 13 mins

I am having issues with excel max If function array formula using Is number / Find to find data

Solved by D. C. in 23 mins

If Raw.InterestMethod = 10 or 11
then RAM = 1200
If Raw.AlternateMortgageFlag!=0 and Enriched.VariableRateFlag = "A"
then RAM = (max(1,Raw.Maturity - Valuationdate)/30.4368)
Else
max[RAM from the MG Amort Formula**, max[1,(Raw.Maturity - Valuationdate)/30.4368]]
**
Log(1-Enriched.Notional*Raw.CustomerRate/Derived.CurrentPayment)/Log(1/(1+Raw.CustomerRate))

Solved by M. W. in 21 mins

I am trying to automate results of survey results to show what kind of learner someone is. I have a file with the survey answers collated and have used countif formulae to find out which results were most popular for each question. I have also used max function to extract the highest total for each question. I can't figure out which formula to use to relate this number to another set value. Please help!

Solved by I. D. in 26 mins

I have two weeks data in one column in one-minute increments. I want to find the max value every one minute (60 cells), put that value in a separate column and continue every 60 cells. Please help.

Solved by K. L. in 29 mins