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.
This is my first time using excel's IF AND statements. Can anyone tell me what is wrong with this formula without looking at the actual data?