I am using excel 2016 and trying to create ta formula that will return a certain value based on multiple criteria. I have set out the logic below but everything I try doesn’t work :mad:
Using VBA macro, Is there a way to copy the value in a cell from one workbook that has, ex, value is "X" in cell A2 workbook1 sheet 1 and paste that value into another workbook, but the pasted value is a Yes/No in cell A2 in workbook2 sheet1 if that cell is the value X?
Example shown below...
This is what I am trying to do. I have 4 core sheets that I input information into and it automatically calculates in the "monthly" and "quarterly" sheets. Right now, I place a tally mark in everyday the volunteer firefighter went to a call. Somedays they have one and some days they have five. I...
Unfortunately I can't get my XL2BB to run so apologies in advance for the screenshot.
I'm trying to calculate reducing balance depreciation in column M. I have split it out by month in columns O onwards, and I'm happy with how that works.
Ideally, I'd like to be able to calculate for...
Hello! I have an issue writing a formula that I hope has an easy response.
I have a dataset with people who have multiple rows of data relating to them. If a certain number of rows meet criteria (eg, are within a certain time period of each other), I would like Value Y on that row to be blank...
I am currently trying to use a formula range to automatically move along a column every month based on values up until the current month.
When a new month begins the formula should extend its range to the next new month and extend the sum. Each month ranges up to 4 years worth.
the error seems...
I've been given a task at work and am having a little bit of trouble with copying a countif formula.
The formula starts off as =COUNTIF($D$2:$D$885,"31/03/2017")
When I copy the formula I want the date associated with the formula to increase by one day each time. So the next...
I have a large inventory file I am working with. The data looks like this:
=IF(ROWS($A$28:A28)>COUNTIF(Utilisation!C62:C68,"Paid Breaks"),"",INDEX(Utilisation!A62:A68,SMALL(IF(Utilisation!C62:C68="Paid Breaks",ROW(Utilisation!C62:C68)-ROW(Utilisation!C62)+2),ROWS($A$28:A28))))
Is there any way to amend this formula so that it searches all of column "C" for the word...
I run a report that has a list of numbers, and only need the numbers below the 0's returned in a column or sheet. Here's what the final product should be:
Array forumla = =SUM(IF('Order Sheet'!$C$7:$C$19358>=Summary!B3,IF('Order Sheet'!$C$7:$C$19358<=Summary!C3,'Order Sheet'!$F$7:$F$19358)))
SUMIFs = =SUMIFS('Order Sheet'!F7:F19358,'Order Sheet'!C7:C19358, ">=B3",'Order Sheet'!C7:C19358, ">=C3")
I have two formula's one array, one a sumif. B3 &...
I've got a dataset with the following columns:
UniqueID | Date | Action
[Ex: U123 | 12/1/16 | purchased widget]
I need a formula to put in each row that will tell me what step it is for that unique id. I the example above, if "purchase widget" was the 5th thing U123 did, the formula would...
Hope someone can assist - I have the following formula which works perfectly to average the last 5 results of data in column D. Column D is a productivity rate and just a regular number
However, column C has one of 4...
I'm not overly sure how to explain this. I am creating a spreadsheet which has multiple sheets which has a summary sheet at the front which gathers data from all the different tabs. What is becoming a pain is having to rename the formulas to point to a particular tab, so, my question is...
I apologize for the long title. Here is what I am try to do.
Prior Activity Date
Okay all the big brains, I have what is probably a simple formula that has been stumping me for two days now. I did not find a specifically related thread so I'm adding this one.
I want a cell to give a value based on two separate cells.
The first is a standard number cell.
Have a formula I think should work but it doesn't seem to be.
I basically am trying to sort some top scorers by position. I have a rank sumproduct forumla that works for the ranking, but I then want to display top scorers for each position in another sheet.