formula

I’m trying to count employees per hour but the problem I have is that we have people clocking in and staying past 12AM. Current Formula: =sum(((A2>=$B$2:$B$32)*(A2<=$C$2:$C$32))) A2 is the time of day so 12am,A3 is 1am so on and so forth B column is the start times of the employee and C...

I have a Google Sheet where I can easily see which photographer is working on a specific day, at a specific time, hotel, and who the client is. However, the problem arises when a new lead comes in, as the data does not appear in the FG View that I have created. Can you help us solve this issue...

Hi all, I've only recently gotten this weird behavior out of Excel so I'm not sure what's going on. I press Ctrl+Shift+Plus and a row does not get inserted but all the formulas in the cells below the section I'm supposed to be inserting get stepped down by 1 cell. For example, if a cell below...

This is a simplified version of what I need to do; to summarize the situation: - I have a table with many columns (only 3 are relevant for now) - Some of the rows may contain identical data in these columns (ex. the duplicate Shirt-Red-A) - I need a single cell to contain the "Brands" that have...

Hi everyone, I'm working on a shift planner that will include cells with numbers and text. I want to sum the numbers of these cells that have numbers and text. My shift patterns will follow a strict criteria. Where X is a number: Example 1: X Standard Example 2: X Standard X Lower Example 3: X...

I'm trying to create data validation rule that will change cell color depenidng on percentage of the value from the cell above e.g. G7/G6>0.8 change cell color to green, G7/G6>0.5 red etc. How do I create a formule in data validation that will apply this rule to all selected cells without...

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