formula

  1. A

    How to get a total add up number from total number in another row??

    Hi , apologize if this question sound more difficult than it should be I would like to create a formula that is able to properly capture a certain amount of number and distribute as evenly as possible from total number in cell C16. The total delivery is 725. Im trying to figure out a...
  2. N

    Searching and pasting column text

    Hello, I am new to Excel and my brain is fried from trying to search the forum for similar questions/answers. I am trying to populate a column with data based on information from 2 other columns. In the attached worksheet, I want to populate column E with the names of the clients based on...
  3. S

    Yearly Interest Calculation

    Hello, Can anyone help me make an automated Excel spreadsheet to calculate the interest on every month's contributions? The compound interest is calculated once at the end of the financial year by taking the monthly contributions. Here the only input value is Basic (I column) and the Interest...
  4. F

    Sumifs for week of month

    I want to sumifs based on weeks of the month, the results should be for the month that is on top of "First week", displayed for "First week, Second week, Third week and Fourth week". Note: Column A is in text form, while Date is mm/dd/yyyy Number Date Amount January 2024 January 2024...
  5. A

    Formula Range Changes When Deleting Rows.

    I have a file for tracking where certain loans are while I maintain them. I use sum() and count() formulas to help me make sure I have everything. But what happens is after some time of deleting rows the range in the formulas no longer captures all the data and they need to be readjusted...
  6. A

    Edit Formula to Auto-Populate Down Table

    Good Morning, I am looking for help on editing the formula seen in the first attached image. The formula itself is working, however, I am trying to edit it so that the formula auto-populates down the entire table. As of right now the only way to get the formula into the cells below is by...
  7. E

    Formula not working

    Hello, could anyone help to find out why the formulas to show the "No Data" numbers not working? These are the cells: AD11-AO11, AD26-AP26, AD37-AP37 It was working fine, but when I have added some columns it stopped. I tried everything but coudn't figure it out. In the sheet I need to know...
  8. T

    Pull data from multiple sheets that match varying criteria

    In excel, I am using this formula: =IFERROR(INDEX(Master!$G:$G,AGGREGATE(15,6,ROW(Master!$G$3:$G$98)/(Master!$H$3:$H$98=$A$13)/(Master!$I$3:$I$98=$B$6)/(Master!$J$3:$J$98=$A$4)/(ISNA(MATCH(Master!$G$3:$G$98,B$12:B12,0))),1)),"") The formula checks Master sheet and returns a value from column G...
  9. A

    Formula Help Needed for Looking at 2 Columns of Data

    Good Morning, I am looking for some assistance with coming up with a formula. Using my attached image you will see in column G there are Hold Reasons and in Column H there are Root Causes. I need a formula that can be used in a new column that shows a count of the different combinations...
  10. T

    Adding additional text to a value pulled from another sheet

    Hi, I am using the following formula to pull names from another sheet that meet a certain criteria. It will only pull a name once, before moving onto the next match. However, for each name pulled, I want to add the word " Replacement" at the end of it. Is that possible? The formula I am using...
  11. D

    Want to use VLOOKUP and IF for a code from another workbook

    So I have 2 workbooks, the first workbook contains a unique ID in a column as well as columns with name, age, skill level, skill name, expiry date in accordance to the unique ID. **NOTE: 1 Unique IDs may have 1 or more skill levels and skill names, different skill level = different row, same...
  12. S

    Organization Chart Formula

    I have simple spreadsheet with 3 columns needing to calculate a forth column. It represents an organization from the CEO to Mailroom Clerk. The organization could be more up to 3000 staff members (or more). The organization can have 30+ or more reporting levels deep, say from the CEO to Mailroom...
  13. D

    Find a cell in a table, and return the value above

    So I'm trying to return a cell value from a table, relating to a text based cell as the searching tool. It's actually part of a larger formula, but the rest is straight forward. I am trying to return a result where if the day of the week changes in A2, it changes what cell I use in a formula in...
  14. R

    Formula calculating time between 2 date/times

    I am having a bit of issue calculating time between 2 dates. hoping to do this in formula as the sheet is pretty long here is an example
  15. brendalpzm

    Gallery not filtering properly

    I am creating a week view calendar with a vertical gallery, This gallery is linked to a SharePoint list where I have the date slots until july 20, 2024. I applied a filter to the gallery to show only the 7 days according to the month showing. The issue is that when I change to the next...
  16. C

    formula to generate multilevel list numbering

    Hi all, I have a dataset that consists of multiple unique "Activities", that are grouped within a multilevel list like this: Focus area (Column A) Action (Column B) Deliverable (Column C) Activity (Column D) 1 1.1 1.1.1 1.1.1.1 1 1.2...
  17. T

    Smooth monthly trend to achieve assumed average YoY growth

    I am trying to create a formula that will populate 2024 values and show a smooth trend that ends up with the 2024 average being 3% higher than the 2023 average. When I average all of the months for 2024, it needs to come out to $71.71.The 3% assumption would be an input cell. Is there a way to...
  18. A

    Formula for calculating between 2 dates

    Good morning ! I am in need of assistance with coming up with a formula that’ll provide me with an 2 month and 5 month evaluation dates for work without counting a summer period. (05/31/24-08/11/24) So let’s say a Hire Date is 01/01/24 2 month would be 03/01/24 5 month would be 05/01/24 But if...
  19. D

    Multiple conditions

    I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work. 1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...
  20. V

    Sort Unique value

    we have the following data which we want to sort with serial 1. Samsung1. Samsung2. Sony2. Sony2. Sony4. Dell4. Dell4. Dell10. TVVS10. TVVS20. JBBL20. JBBL20. JBBL20. JBBL result sheet 1. Samsung2. Sony4. Dell10. TVVS20. JBBL help with formula please

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