I have dates in w24 (start date) and w26 (end date) with the resulting math taking place in w28. Easy enough.
The issue is I need to not calculate the weekends. I tried the workday function, but that isn't what I am looking for... Any ideas?
My formula =LARGE(AE$2:AE$999999,AK2) works great
BUT if it locates a duplicate value, it reports the first of the two twice. Is there a way to correct this?
Thanks in advance!
Hello,
I am trouble creating a formula to go into Cells B2:I2, Im trying to have Excel say Find the Text "Scheduled Date" match the date below with a date in Row 1 and provide the information in Column M for Test 1 , Only Information from the Text "Scheduled Date to Subtotal" Belongs to Test 1...
Hello,
I have a data set of ~2500 rows, the data im concerned with is the description. The description has large variations within the data set, i am looking to consolidate the descriptions to a common description.
For example ...
I am attempting to find the average, median and 75th percentile in a list of data that I have, but I would like to exclude zeros from the calculations. Column D has various years (2012,2013,2014) and Column E has salaries. Essentially, I am trying to develop formulas that do these three things...
Hi everybody. I'm having issues with setting up multiple drop-down boxes to auto-complete with a set list of data values. I've got two tabs that have multiple drop-down boxes utilizing the same data values from a third tab. Because some of the drop-downs have multiple selections (Country for...
https://imgur.com/a/PiUe6Lz
I want the macro to be relative because the actual data is in adjacent 2 lists so it just keeps going down.
All the VBA I know just overwrites the cell or Takes the first row's formula copied as a quote and applies that to every output rather than whats inside the...
Hi Everyone,
I maintain a contracts database and need to automate the total qty column. Having a really tough time getting it to automatically show those numbers.
Summary: This data represents one contract (internally it is contract #18, externally, it is contract #21). It is broken down into...
Hi all,
I am trying to copy an example from a textbook so that i can edit it for my own use and i have typed out the Macro they apparently used. i Have checked a few time and can't see the error but i keep getting a 'invalid control variable reference' error and can't get any further. I would...
Can anyone tell me how to use the below code for different workbooks where the Sheet Names are going to change in each workbook? I am a novice at writing code (as I am sure you can tell). We have a program set up that provides us with a daily workbook. I have a macro that creates a STATS...