arrary

Hello. Help needed: need a formula to compare the last input value in an array with the average of the previous ones. Example: | J | F | M | A | M | J | J | A | S | O | N | D | Formula column | | 2 | 3 | 4 | 1 | 5 | 4 | In this case the formula should let me know that in June the value was...

Hi, Id like to ask for your kind assistance on this, im trying to create an attendance tracker which would determine the employees schedule and the hours he covers, now will it be possible to automatically fill the the hours by using a formula just by putting the employee schedule under the...

I have 2 columns with Ip address information: <tbody> Column1 Column 2 Column 3 1.1.1 100 1.1.1 101 1.1.2 95 1.1.2 200 </tbody> I'd like to return for every grouping of column 1 the missing values from 1-254 in column 2 So for example, an output of the above data would show...

Good morning, everyone! :) I have a frequency/sum formula that looks at individuals who meet multiple criteria and then provides a unique number of those individuals. For example, 72 line items match my criteria but only 63 are unique users based off the member ID field. I am running in to a...

I have a userform that ask for Name, date, and other information. All of this information is outputed to another Sheet. I am wanting the user to be able to use relative dates like T for Today and have the output to convert the T to a date after I run the macro. My goal is start the code like...

Hi Thanks for taking a look at this and any suggestions given.. I have a create then search array function that work perfectly if i omit 3 lines of code but crashes if they are included, can anyone help with why? and how to resolve it please i could run it ok without but would prefer to have it...

I am trying to get my code to look at each workbook and if there is a value in the set range to copy data in various cells depending on where the value of data is. I need the Data to go to a summary sheet (already created), but I am getting stuck on how to tell VBA to look at column C in the row...

I have a number of defined arrays in a workbook and would like to refer to them depending on contents of a cell. e.g. I have 4 different arrays defined as Array1, Array2, Array3 and Array4. Cell A2 contains a formula that will return a value corresponding to the name of one of those arrays (ie...

Hello, I am trying to create a macro where it gives the bold value to all of the non bold cells beneath it. I also want to delete the bold rows but have not been successful Here is the code for the cell values which works. For Each cCell In Range("A" & "2" & ":A" & spot) If...

Hi, I want to fill Tab pairs, like: [0] = Eng, 2 [1] = De, 3 [2] = PL, 4 [3] = FR, 5 etc... I know how to only add first value. How to 1) add second value and 2) check if the first element is into Tab? (because value like Eng, De....need to be unique into Tab) Dim CostCatTab() As Variant...

I am trying to modify the below array to determine if a date and PO number have already been returned as a result for a date then skip to the next PO. see the attached screen capture which is returning the same PO number multiple times in the calendar. I'm using named ranges (CalList, PO_Number)...

Good morning, I created the following code to make calculations and then copy the results in the "Cash Flow" sheet. It takes 15 seconds but I'm sure that the code can be optimized. In step 1) formulas are applied to a range of cells in "PTF" sheet; step 2) change the date and the formula are...

I have a table that looks like this: Need Col D values that have ";" present to be parsed out to create and new worksheet with the results looking like the output below. I've looked & tried but is beyond my level at this time. Any & all help is greatly appreciated! :banghead: Excel...

Hi everyone - I have an array formula that was initially working but now shows the NA error in every cell where it is written. My formula is as follows: =MEDIAN(IF(Filled!Z:Z>4,IF(Filled!G:G=E3,IF(Filled!B:B>=E5,IF(Filled!B:B<=G5,IF(Filled!K:K<18,Filled!Z:Z)))))) E5 and G5 are cells with dates...

If I create a basic table like this using a circular reference as a timestamp Time Call Qual 27/08/2015 12:07 2 27/08/2015 12:07 3 27/08/2015 12:30 3 27/08/2015 12:37 4 27/08/2015 12:39 3 27/08/2015 12:41 3 27/08/2015 12:45 4 27/08/2015 12:47 3 27/08/2015 12:50 4 27/08/2015 12:55 4 28/08/2015...

Hi, I'm in a situation where I need to check if some sheets already exist in a workbook which I need to run a macro on. That macro is designed for selected sheets. If any of the sheet is not existing, it will fail. I want to put a control for VBA to check whether those sheets already exists or...

Hi guys, I'm having trouble with some VBA I've put together. It basically just hides and Unhides worksheets which all works perfectly. The problem I'm having is with the message box. "el" is always returning the next sheet in my mylist not the not the actual sheet which is not in my...

Hi, I'm attempting to find a solution to the overcome the problem of having multiple solutions when using an array function with index and match functions. To start, here is a data set example (A1:C7): <style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px...