formula

I have a input table like this A1:C21. I'm trying to show (in 4 columns array) the "Letters" that meet the condition in J2 and K2. In this example I'm getting the letters for which Col_A = 1 and Col_B = "MM". Below I'm showing the current output using a formula in E2 (borrowed from here), but...

Hi all, I have the input table from A1:G28. My goal is get to get the unique rows based on 3 columns (A, C and G). The output would be like the table in M1:O14. I was able to get this table manually joining the 3 columns I need, then Data/Remove duplicates for values in column I. I got unique...

Hi all, I have the below text in column A that has data with pairs of parameter,value in stacked way and separated with " = ". For this I'm trying to have a formula to tabulate it in order to extract some parameters of each block and put them in each line. In B2 I have this formula so far...

I was given these mortgage rate factors from a friend in a pdf (he did not write the formulas to calculate the factors) and have been googling the formula so I can replicate it and can't find a way to do it. Basically, I need to know the factor for any given mortgage interest rate. Rate is typed...

Hi, I'm struggling to find a way to make some textjoin alike formula with IF condition and also "unique" too in order to combine results that share same value. I have something as per below example: ID Type Name1 Type1 Name1 Type2 Name2 Type2 Name3 Type1 Name4 Type1 Name4 Type1...

Afternoon, I have a rather lengthy formula that stops working about half way through. Values 1 Tablet - 27 Tablets work, 1, 2 and 0 boxes work. But 29 - 55 Tablets don't work and I can't understand why! So if I pop any of the corresponding values in AF, for example 1.9642857142857100, it should...

Hello, I have a budget spreadsheet that I purchased off of Etsy. I receive Social Security Disability, but it's not on a specific date. It's always on the 3rd Wednesday of the month. The spreadsheet I have has a drop down list of different values. I need to be able to select the 3rd Wednesday...

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