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

on the left, you'll find "tickets". those tickets, mon-fri, are the total hours worked for x number of people. each ticket has different "lines". the lines are the positions worked. There are multiple positions (lines) per "department".
On the right, you'll find the "report". The report needs all the names of the people who worked x week and it needs all their hours, separated by "line" (or position). There's an example of what I need on the report. I guess my main issue here is sorting.

Solved by V. L. in 28 mins

on the left, you'll find "tickets". those tickets, mon-fri, are the total hours worked for x number of people. each ticket has different "lines". the lines are the positions worked. There are multiple positions (lines) per "department". On the right, you'll find the "report". The report needs all the names of the people who worked x week and it needs all their hours, separated by "line" (or position). There's an example of what I need on the report. I guess my main issue here is sorting.

Solved by A. L. in 24 mins

Hello, i work for a doctor and we have an excel sheet with multiple patients (in their own rows) and in those rows there is a date. Please help me find a percentage formula in excel multiple cells. I need to find the percentage of patients before a certain date and the percentage of people after that said date.

Solved by V. Y. in 28 mins

I am trying to create a simulation on excel using various probabilities. I am trying to run simulations to find out the probability that a team will not lose in consecutive games in a season of 82 games if they have an 80% chance of winning every game. The team is projected to lose 16 games, so what is the chance that the team will lose in consecutive games if they lose 16 total games?

Solved by D. F. in 14 mins

hello, could you please show me how to set up my work sheet in the way that I can plot my data as; Day versus voltage (mV). My current chart has Date on x-axis, I tried to find a way to change that by created column F using datedif excel formula: DATEDIF($B$2,B116,"d")+1; this didn't work so well; and then i modified it to DATEDIF($B$2,$B$116,"d")+1 that didn't work either since as you see it gives me 1.00 for all. Is there any other way to do this? Please help. thank you

Solved by I. B. in 24 mins

I want to find a value in Sheet 1 - Column A to match with Sheet 2 - Column A.
If it is a match, I need to change the value in Sheet 1-Column C with the value in Sheet 2-Column B

Solved by A. J. in 13 mins

I want to find the date by adding the number of working hour as well as date using formula Workday or Workday.intl. Can you explain to me the workday definition?

Solved by K. Y. in 22 mins

Hello,
I'm looking for a formula for this:
to get an answer in cell G5, I need a formula for this
If F5 is Y, then multiply the Value in E5 (E5 is a previous formula) by 0.04 or if F5 is N then multiply by 0.02
basically I'm working out a bonus calculator and whether you get 4% or 2% depends on whether its a new customer or not. Please can you help me find the formula that needs to go into G5?

Solved by A. U. in 15 mins

need to find if a certain code repeats itself in a certain time period

Solved by K. L. in 16 mins

I've created a table of vertical unique recipe SKUs. In the columns next to those SKUs are the corresponding ingredients, set in their own cells. I'm trying to find out a function for the entire table that I can enter an ingredient and pull up a list of the SKUs that contain that ingredient. Also, is there a way to pull the SKUs for searching for multiple ingredients, i.e. containing chicken and rice? Lastly, is there a way to find the SKUs that DO NOT contain certain ingredients?

Solved by M. H. in 26 mins