formulas

I have one workbook. I have a data entry sheet where users can enter data (A3:H866) - vertical orientation. I also have a summary sheet (AB6:AM90) - horizontal orientation where I have used an Index formula to bring in values from the data entry sheets. The expectation is that if there is a...

I have a list of time off requests that are listed as date ranges (ie. 6/7/21 - 6/10/21 ) and I need to make a count of how many days off are requested for each date, ideally without having to manually input each date between the date ranges. So i want to be able to input 6/7/21 - 6/10/21...

Hi, I have lot currency conversion data that needs to be transposed so we can load it to a DB. Due to security restrictions no macros are allowed so I will have to rely on formulas. The existing data is in this format: DateYearQuarterAUDCAD CurncyAUDCLP CurncyAUDCZK Curncy...

Good morning, Currently, I'm trying to compare a date with another cell that has a date in it but it's formatted in a way that conditional formatting isn't working. For example: A1 = 6/11/2021 O1 = 17May2021 MON I'm trying to figure out how to extract that 17May2021 into another cell as a...

This is How it's supposed to look in the end. I have no problem with columns T to Z changing colour based on their values, but I can't figure out how to change AB... I'm trying to make the checkmark and X symbols change automatic; if all cells in a row (T-Z) are green, a checkmark should be in...

Good morning all, I am trying to count a specific number of "No's" in a row, if there are more than 2 for example then I would like to mark that row as "Non-Compliant", can I use COUNTIF to do this?

Hi guys, I have a similar table: Column A contains the search data. Column C is for inserting a formula. A B C Car Big =CONCATENATE(A1;" ";B1) 'Result (Auto Big) Car Small =CONCATENATE(A2;" ";B2) 'Result (Auto Small) Bike Road =CONCATENATE(B3;" ";A3) 'Result (Big Bike) Bike Mountain...

i am creating a document for work to help things flow faster and easier. This is a shipment plan, it is mainly done but its just the last part which im struggling with and hoping someone will have an answer. I am trying to summarise 1 sheet with 2 tables (for printing purpose) on another sheet...

Hey all, I am trying to transfer data with this formula =IF(ROWS('Destination Sheet'!$B$5:B5)<=$A$1,INDEX('Reference Sheet'!$B$2:$B$23,AGGREGATE(15,3,('Reference Sheet'!$A$2:$A$23='Destination Sheet'!$I$1)/('Reference Sheet'!$A$2:$A$23='Destination Sheet'!$I$1)*(ROW('Reference...

Hello to all! I really need your help... I'm currently following an online course about Supply chain planning and here is the issue i'm having, i can't round the average number! I'm doing the exact same things as the teacher is showing and all i get as a result is error. First thing i do is...

HI to all, here another question: I have attached the Cotizaciones (sheet 1) , Retornos (sheet2) and Descriptiva (sheet3) . From data in Retornos (sheet 2), for each column (are dynamics) starting from B3, I have to compute calcolation of average and the volatility (until last row for each...

Procedures to perform are: * Populate a 1D range of general size n - done * Add two 1D ranges - I have the ranges but I can't get the sum of them (code below) Private Sub CommandButton1_Click() 'Clearing worksheet Range("A:Z").Clear 'Declarations Dim range1, range2 As...

Hi, I'm new here and was hoping you can help me deciding the best way to design a template in Excel. I need to track resources and spent by department and by project. The idea is that in this table I register every resource, when they start, when they finish, their salary and what project...

Name code Size in cm Weight in kg Age Gender M/f kg/cm size/age weight/age Persons Andrew Black P001 180 82 23 M 0.46 7.83 3.57 Sarah Jones P002 169 71 32 F 0.42 5.28 2.22 Tim Bradford P003 175 71 45 M 0.41 3.89 1.58 Julie Clark P004 172...

I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor Participation, T for Tardy, etc...) have them lose that number of points. I have each code and the number of points it deducts on another sheet in excel...

Hello all! Any help is appreciated as I am new and trying to figure out things in excel. I am trying to calculate the overall absenteeism rate for a particular month. (%) Given facts: Absenteeism rate = the amount of absences divided by the amount of total planned working days. Result is a...

NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you! Hello everybody, I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this: To briefly explain the sheet...

Is there anyone out there that has found a basic SQ FT calculating formula, Ive read into some forums and I've came across this formula, =LEFT(D19,FIND("'",D19)-1)*SUBSTITUTE(RIGHT(D19,LEN(D19)-FIND("x ",D19)-1),"'","") , Im currently having to go into the formula and changing the cell It will...

Hello - I'm trying to create a master Workbook that can take the average of the values of an individual cell across multiple workbooks, but given a certain condition is met. For example, I want to average all of the values of C3 (which is a number) across all worksheets, but only when cell A4...

The messy data looks like the list in columns A & B (see image), the finished list needs to be like columns D&E. I'm cleaning up some very messy data with formulas on the spreadsheet up to this point but the solution could be with VBA also, I'm open to either. So basically the purchase order...