formula

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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