# formulas

1. ### Can we make charts dynamic using formulas (INDEX MATCH and MAX) in Google Sheets

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...
2. ### Split and search for values in cell

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...
3. ### Create totals using drag down

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...
4. ### Calculate Number of Work, Annual Leave and Sick Hours from Budgeted Hours

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...
5. ### Count ifs formula

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...
6. ### Returning ALL Records in a List

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...
7. ### Formula gets count of unique values not <> to a status - return those values...

Formula gets count of unique values not <> to a status - return those values in a list to see what the text is for the not in X status.
8. ### Filter Data?

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...
9. ### VBA for New Table Data Calculations

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)...
10. ### Formula for Copying Specific Data to a New Sheet

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...
11. ### Formula returning incorrect results

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, "")...
12. ### Complicated SUMIFS/COUNTIFS Formulas Required

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...
13. ### i want to distribute a value based on 2 values

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...
14. ### IF Formula

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
15. ### VBA Macro to apply formulas to all worksheets in a workbook

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...
16. ### Combining cells with the same data but keeping some data separate

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...
17. ### Formula Help For Skins Game Golf

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...
18. ### Calculate 15 working day SLA

Hi all, I need to create a spreadsheet, which has an integrated 15 working day SLA. The SLA clock starts 1 day after the 'Claim Lodged Date' (Column A). The SLA clock then stops when a barrier is raised (on the day of the 'Barrier Raised Date') and then restarts when a barrier is closed (on the...
19. ### Power Pivot Table - Outside calculations

Hello, I have a power pivot table I am using to summarize some data. I am using it as a daily report and outside the pivot table I pull out and summarize specific data related to individual departments. Two of the Lines I want to combine the total units produced. Which works fine, when both...
20. ### Filling in blanks in Column B with Duplicates in Column A

Hello Excel Masters. I am trying to write a formula that will fill in the blank cells for Column B with "Contact 1", "Contact 2", or "Contact 3". Depending on how many duplicates are in Column A. EX: 174653 Contact 1 174653 Contact 2 175277 Contact 1 175277 Contact 2 178484 Contact 1...

### We've detected that you are using an adblocker.

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.

### Which adblocker are you using?

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

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.
Go back