Hello,
Each week, my whole company attends a meeting. Before each meeting, an email is sent out with a Microsoft Forms link which the whole company must complete to state they've acknowledged and understand the briefing. This is because some employees who work nights can't attend a daytime...
I have a sheet with several formulas that need to be updated.
The old and new formulas are all the same, but with different reference cells in each.
Can I update them all at once?
Here are the first 3 examples, there are a lot more, which is why I don't want to do them individually.
Old...
Hola, tengo una tabla donde tengo las 52 semanas del año en curso de la columna de la columna I para la primer semana hasta la columna BH para la semana 52, quiero contar los datos por meses, se que puedo usar COUNTIFS para contar cada columna pero quiero que automaticamente me cambie...
This question is for Google Sheets. I'm asking two questions in one post, both are related to the same thing.
Is there a way we can use formulas like in the picture below, to achieve the results, instead of hardcoding the ranges in the charts setup?
It is also crossposted here, no answers so...
Good Morning
I wondering if its possible to create a formula that would split a cell by a comma and keep only the values that start with "TV -".
Keep only unique values
Take the data and insert a line feed between each grouped value before saving it to the column as shown in the...
Good Afternoon
Could a formula be created to count occurrences of values in ranges and list the occurrences at the conclusion of values in column a.
example - looking for a total count of Crits would find 2 values that fall in the Ranges value of 900-1000 [the ones showing 1000]
Next looking...
I am trying to figure out how to determine the number of Work, Annual and Sick hours an employee would be assigned based on their allocated budget.
Once an employee works 500 hours they are entitled to one hour of annual leave per every 15 hours worked and 1 hour of sick leave for every 20...
hi - First post in a very long time - I'm wondering if someone could help please?
I am trying to work out how we can establish our stock levels
Each row would identify either a customer order - using columns for customer name and product code or an item in stock using the term "stock" and...
Hello,
I do not know how to return multiple records for a single item which occurs multiple times in another list. What formula do I use to return multiple records?
List #1 List #2
Item A...
Hello,
I track the whole company's absence on a single excel tracker (excerpt below). At the end of each week, I am required to provide an individual absence report to managers in each location. There are currently 62 in the business across 8 locations and this is hours of work on a Friday.
We...
Good Afternoon Everyone,
I'm starting to dial back in on creating macros and I'm wondering if there's a way to either capture all of my left column formulas and drag them over to the right while also capturing the changes between each formula.
For example (left)...
Hello world,
I would like to create a formula that copies all the data from rows which contain "00" in the last two digits of column L, to a new sheet (such as the cells highlighted in yellow). I know I could sort column L by "00" in the last two digits and then copy/paste, but I am trying to...
Hello,
Apologies but my work won't allow XL2BB for security reasons.
The formula in column G is: =IFERROR(SUM(F9-C9)/F9, "")
This returns a percentage increase or decrease between the figures in columns F and C.
However, the exact same formula in column J: =IFERROR(SUM(I9-F9)/I9, "")...
Hello,
I have two sheets, named:
1. Master Data - This sheet will be updated daily by pasting a system report over the existing data
2. 2022 - I want to calculate some stats from the master data sheet on this sheet
The gist of this is, I need to report on people who leave between 0 and 5...
i create daily stock distribution order and want to distribute a value (warehouse stock) based on 2 different values(pharmacy stock & pharmacy sales).
For example, my stock in warehouse is 20 units and in a pharmacy the stock for same item is 10 units but the sales of that item in that pharmacy...
Hi
I have a formula that works perfectly but instead of returning FALSE and would like to be blank. Can anyone please help
=IF(F7=0,MAX(INDEX((Append1[Compliance_Officer]=Sheet1!C7)*Append1[Date_Assessed],)))
Many thanks
Hi All,
Kind of new to VBA, and have been studying previous posts
I have 100s of worksheets with different ranges, but all need the same formulas applied to column A and B (if blank, preferably so that i can add and update the worksheets later).
I can only get A2 to populate, any chance...
Good afternoon all.
Have a tricky goal to try and combine two rows with the same data, so merge it into one row of data. I will need a formula that can combine them as ill have lots of this data coming in.
As you can see below - A, B and C all share the same data and i need them merged into...
Is there a way to show skins for each hole? I have provided what I have done so far, but the final step to this sheet and will save me a whole lot of time is if it could calculate the skins for me. There are two options I wouldn't mind using that I have shown as a little bit of an example...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.