help excel formula please

Hi Everybody. I'm in a bit of a pickle and i'm hoping someone can help me. The current situation: Our stock dispatcher in the past has been using a spreadsheet that only he understands and even then, the convoluted ways he goes about tracking stock quantities and locations means he doesn't...

Hello All, I am fairly new to an administrative roll and am currently trying to finish an attendance track I have have started and I am stumped right now (excel novice). So basically our the two attendance rules at work are as follows; 1. You have 6 Sick occurrences to spend in a rolling...

Hi, So I am new here, and also interested in learning how to code formulas in excel. I am using excel 2016. Would you be so kind to share a formula for "Finding the third Thursday date of every month for the year 2017" Example: A1: Formula A2: input Year A3: 1/19/2017 A4: 2/16/2017 ...

<tbody> A B C D E 1 LOCATION AMOUNT Mr. A Mr. B 2 LAS Mr. A $0 3 LAS Mr. B $10,000 4 LAS Total $10,000 5 LAS TV $2,000 $2,000 (manual input) 6 LAS Radio $8,000 $8,000 (manual input) 7 SFB Mr. A $2,500 =C7/C9 =C8/C9 8 SFB Mr. B $2,350 9 SFB Total $4,850 10 SFB TV...

Good Day, I'm trying to figure out how to pull data from my raw data page (Screenshot 1) and transfer certain data to the second spreadsheet (Screenshot 2). I'm having troubles with getting my formula to populate the correct run number. I'm trying to use Index match function. If I select...

I'm trying to create a formula that produces a certain value based on a list of options. Essentially, I want to know whether a someone associated with a city should be placed in "Zone 1", "Zone 2", or "Zone 3". "Zone 1" and "Zone 2" have a set of values associated with them, and then "Zone 3"...

I have a data set with home listings, and I'm trying to answer the question, "For homes in inventory at the end of a given month, how many days have they been on the market on average?" Data specifics: Column A:Location Column W:List Date Column X: Close Date Column I need to average the days...

I am going to start with saying that I really have minimal experience with Excel. What I am trying to blindly accomplish at this time is for the "IF's" in 2 cells to have one answer. Basically, if Cell L5 is > 365 AND cell N5 is < 1, then the answer is true, if both are not true, then I need...

Dear all, How the workbook looks like: Each sheet in the workbook represents one month of the year. In an additional sheet I would make a table with all the companies and 12 months of the year. I would like to put x in those months for company ABC in which that company has a contract (i.e...

im so I have a box that is 15.1 inches and I have a self that is 15 ins high . if I change it to 15 it will fit but if the change is no over 3% change it when then revert back to 15.1 what is the excel formula for this can anyone help me the info would be cell a2 the 15 for the self height and...

Hi I am new to the forum and even though i have used excel for years what function to use has got me stumped. I have a spread sheet that every time we get a sales inquiry, the job gets allocated to a member of staff. From a drop down menu you select the staff members name, on the same row it...

Hi, I tried searching for this even though it seems pretty easy, but it is quite tricky to describe and couldn't find anything.. I need to create a formatted excel from 2 sheets, one with data (DataSheet) and second with settings (SettingsSheet). The Macro needs to loop per row into the...

Here is what I wrote but it is not functioning quite right =IF((AND((F3=NOW()-1),C3>=F3)), "1", "0") What I want to happen is if C3's date is equal to or after the value of F3's date I get a value of 1 Examples: If C3 = "Monday, August 01, 2016" and F3 = "Tuesday, August 02,2015" then...

Hi, The company I work for is having me create an interactive excel sheet. I know that this is probably going to be using an if statement but I cant figure out how to make this work. Basically what this is supposed to do, is if you type in the number of participants in one cell, the fee will...

Hi, I have a problem where I need to add an extra function to a formula. I currently have the following table on a worksheet:- <tbody> A B C D E F 18 Log Cabin Quantity Size Notes Twin Skin Insulate Floor 19 Cowbeech 1 3x3 1 1 20 Brightling 21...

I am trying to count how many Saturdays and how many Sundays are in a particular month. I do not have a start date or end date but I used the following formula =NETWORKDAYS(B296-DAY(B296)+1,EOMONTH(B296,0), $U$2:$U$22) to calculate the work days in the particular month. Is there a formula like...

Hi, I have two worksheets in the same workbook that I want to be able to transfer data from one to the other. The first worksheet is a ‘quote’ form. Which will have, quantity, type of material and size. I would like the information from a range of cells to filter from the ‘quote’ to a ‘job...

Hi, HELP PLEASE! I am having trouble using a combination of IF and VLOOKUP functions. I have a quote form that I want to filter through to workshop sheet in the same workbook. I want to be able to search a range of cells on the quote form for an item, say MDF, and then return the quantity in...

Hi all - I'm new here and really hoping that someone can help me before I pull all my hair out! This is a sample of the data I have. I have over 24k rows that look just like this. <tbody> Group ID Merge Key Master Record Exclude Record Record ID Key Indicator Constituent Import ID G-1...

Hello Excelians, I have to calculate a 24hr SLA between date/ time Received in the following format of 0/0/00 0:00:00AM and date time Sent in the same format. ( Column A Received and Column B Sent) and Column D will display the time in between in the 37:00 hr format. A simple subtraction...