formula

I attached below some rows I have which you can clearly tell have some weird characters in the text. Is there a formula to find which rows have any of these characters, and which don't. I think that these aren't all of the special characters in the texts, meaning there might be other that I...

Hi, I am trying to divide the result of one sumifs() statement by the result of another sumifs() statement, but the sum range and criteria ranges referenced in the second statement are not working.The ranges are valid but they are not highlighted in the sheet and the formula returns an error...

Hi, i am working on a new employee performance evaluation form. Managers will fill the form for each of their employees semi-annually (attached). Each employee should have a minimum of 5 objectives and a maximum of 10 per each 6-month period. In the old evaluation form, each objective had a...

Hi All. ok i have, just an eg. of 5 selections out of which only 3 combinations interest me. how many combinations would there be leaving out 2 totally different selections. List: Thee Pluto Iruma **** Elite. with regards

How can I create an Excel formula that, in the 'Arbeidstasjoner' sheet, uses the machine name in cell B3 and the date in cell E2 to check if any lines in the 'SQ1' sheet match both the B3 machine name and E2 date? If matches are found, the formula should return the sum of values in column 7 for...

Hello, This one has the potential to be quite complicated, as UK holiday law is governed under the Working Time Directive. I have been trying to make a calculator on Excel which calculates holiday entitlement and can also take into account if someone starts employment part-way through the...

Hi all, I think I am overthinking this one and need some help please. I am writing a conditional formatting formula so that cell B2 will highlight "purple" if cell i2 is blank and cell j2 7 days has passed since the date shown I have input the below formula and it works if cell I2 is...

Hello, Been looking for a way to populate corresponding time blocks for classes based on time ranges in another sheet. If anyone can help with either formula or VBA to get sheet 3 to populate how I need the data it is greatly appreciated. Sheet 1 contains blocks of times in 5 minute intervals...

i need to use Vlookup/Xlookup to pull data from one spreadsheet to another using the address to match address it is this format "7 example close, Example, BB4 9BB"

Below is the table for late attendance deductions: This is monthly attendance data and for example: How do you calculate late attendance deductions with the above data based on minutes? In the example above, an employee with the name Nara Susilowati has a salary of 10,000/month. This month...

Hi there. I am trying to write a formula to copy across in the highlighted neon yellow cells that checks to see if 10 different members' info matches the filter criteria at the top of the sheet. Should I add a ghost column underneath with same number of rows, and have each cell check each...

Hi all MrExcelians! I have 2 columns with different words. I would like to identify those different words with same letters. Any non-Array formula would do to use on my smartphone. thanks n regards Patrick

Hi there. Can anyone help me with an indirect with nested index match formula that's dynamic enough to allow me to get values from other sheets which change depending on the Factory and Metric I need them for? My hope is to have one formula that's dynamic to copy it across and down as the file...

Hi there. Could someone kindly assist me with an XLOOKUP formula I'm using to pull in data from a master tab to another sheet? I want to pull in data onto "Store 1" sheet based on: Store Number month year line item name (revenue, COGS, etc.) =+XLOOKUP(1,('Data Master'!$B$7:$FZ$7='Store...

Hello Using the basic salary column on FY 22-23 as an example, I need a formula to sum this column into basic salary on the stats sheet, if possible using the sheet name in column A as a reference to the sheet to sum from. All columns across all FY sheets are set out the same. Stats sheet...

I am looking to count the first instance of data in a column, however when a new row gets inserted the countif needs to be reapplied. Is there a way to make this spill? AB1DATAFirst instance2a13b14c15inserted row6a07c08d19e110f1B2:B4,B6:B10B2=(COUNTIF($A$2:$A2,$A2)=1)+0 I have considered using...

trying to think of a formula i was playing around with vlookup and ifs but cant figure out how to do this wanting to automate a way to state if a user took a class or did not take a class on transcripts

Hi all, I want to search within range A1:B16 the CODE for each NUM in D1 to D8 with one condition. There are some CODEs that are of the form XXXXZZ and XXXX24 that belongs to the same "group". The CODE that ends with 2 numbers is the "MAIN" CODE within than group. The "MAIN" CODES begins...

Greetings Excel Community, I have a set of data and i am wondering if there is code or formula that can be created to parse these values into comma delimited dates. The dates are combined together to make it look as a long string, however i am attempting to create the end result under the...

I have the table below, looking to create a spill formula which will simply tell me if a numeric value is in any of the three columns B,C,D. However with the spill formula currently in use as soon as one row is true then all become true. Is this a limitation to spill formulas or is there a...