formula

not sure if this has been asked before but running into a slight issue- I have a data set this data set does connect to a live report. i need to be able to sort on different things such as date of inquirty or ttracking number or date sent or other things- when i sort by tracking number or...

Hi! I am trying to write a formula that will allow me to extract multiple strings of numbers from one cell to another, while filtering out all other irrelevant text from the source cell. For example (see attached photo), I want to be able to extract multiple 8-digit numbers, separated into the...

Hi All - New here so please bare with me. I would like to count the number of times a cell containing "PB" would appear for a set individual between two dates. For example in Image attached: 1. Count cells containing "PB" in the Row labelled "J D" between the dates 2/1/24 (DD/MM/YY) and...

Hello, so I'm using Microsoft Excel on Office 365 and I'm using the VLOOKUP function and having some issues. Here is the current state of my formula I'm trying to troubleshoot: =VLOOKUP(C3&"*",A:B,2,FALSE) Column A is filled with identification keys composed of letters and numbers while column...

Hi , I Am currently creating an Audit Tool for Excel. I have create a VBA where the function will calculate the total number based on each name and its respective class from a raw data in Tab "Raw Data" and populate them into Table Below .However , To do the audit , i would ask the auditor to...

Hiyall, I've been trying to create a custom search bar and this video explaining it rather well. However, when it comes to the partial research, it appears that my version of Excel doesn't understand the [FIRST] variable (it's a Pro version 2021 - I thought it was enough, but maybe it needs...

Hi again, Looking to sum all previous numbers based on criteria. Need output to be a horizontal spilled range.. Example below. I have a formula but it uses the "OFFSET" function and I need to do this without volatile functions in Excel. Thanks in advance! Ex 2024-11-18 2024-05-12...

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