alex

Hi All, Anyone can help to confirm below VBA code for above matter? Sub datasheet() Application.DisplayAlerts = False Worksheets(Array("FG_Pack_Bundle", "FG_Store_Bundle", "FG_Ship_Bundle", "FG_Pack_Bag", "FG_Store_Bag", "FG_Ship_Bag")).Delete Application.DisplayAlerts = True...

Hello, I'm looking for help in creating a macro to summarize a member database by Address. This is to get our mailing address list from our member database. Any help on how I can accomplish this would be greatly appreciated! Example Data (Sheet 1): <tbody> First Name Last Name Address City...

Hi there, Maybe someone can help me (is there any video/page I can watch?) as I am struggling to accomplish the following: I have a huge list with post codes: DN9 2BT IP28 8PQ DT6 4NG F94 TP9N LL20 8DD RH1 2NB YO22 5NH TA8 2NZ B48 7SQ LL58 8YL In the second column I want to insert a if...

Hi, Not sure if vlookup is the correct thing to use for this but i have data like below: <tbody> Name StartDate EndDate John 12/05/2019 15/05/2019 Luke 14/05/2019 14/05/2019 Anna 11/05/2019 16/05/2019 Alex 14/05/2019 16/05/2019 </tbody> Now for example if a have a sheet with dates if...

Hi Guys i have the table below with some results the score seems to be incorrect i am not sure if its my formula <tbody> a b c 1 Name Result 2 James 2% 3 Alex - score 20 </tbody> the formula i use to get the result are as follow for both james and Alex...

HI Guys i have a countifs statement that is doing the on the below set of data <tbody> Name Status date Alex Qualified 30/03/2019 Alex Qualified 30/05/2019 Alex Qualified 30/04/2019 Alex Not Qualified 29/04/2019 James Not Qualified 26/04/2019 James Qualified 26/04/2019 James...

HI Guys i am doing a count ifs statement on the example data below <colgroup><col><col><col></colgroup><tbody> <tbody> Name Stats date Alex Qualified 30/03/2019 01:18:01 Alex Qualified 01/04/2019 10:08:01 Alex Not Qualified 30/04/2019 02:01:01 Alex Qualified...

HI Guys i am trying to create a formula where it does a count if the date range condition is matched else bring back blank, below is the data <colgroup><col><col><col><col></colgroup><tbody> Name State Created On Alex Qualified 30/04/2019 Alex Qualified 01/05/2019 Alex Qualified...

Hello all, this is my first post, so please be patient with how I word, ask my question. I'll try to be clear here so you can see what I am trying to do. Application: I work for a construction company and am looking to set up tracking for a specific portion of work we do. This...

HELLO, I'M TRYING TO GET A FUNCTION FOR A NEW COLUMN (COL 'DP') TO ACHIEVE THE RESULT BELOW. i CANNOT FIND A WAY TO DO THIS. i AM TRYING 'COUNTIFS' BUT ITS NOT WORKING. i HAVE A LARGE FILE, AND EACH TIME THERE IS A CHANGE IN COL A, I NEED THE NUMBERS TO START AGAIN FROM '1' IN A NEW COLUMN. I...

I have the following equation: =IF(AND(S19="yes",$V$5>0),VLOOKUP(I5,Table27,5,0),VLOOKUP(I5,Table27,4,0)) I'm having trouble adding to this equation: if S19="no", return a value of 0. Hoping explained my self and someone can help. Thanks Alex

Hi, Struggling to save an excel file with the following file name: "20181018 ALEX - Data.xlsx". I have the below code but the application.workday function doesnt seem to be working. Any ideas how to get around this? File name should be yesterday's business date and then ALEX - Data...

Suppose I have the following data <tbody> Alex 01/07/18 10000 Mike 09/07/18 20000 Alex 13/07/18 35000 Jason 13/11/18 26000 </tbody> Now, I'd like to find the maximum commission earned by a person for a month subject to the condition that for each transaction max commission earned...

Hi, Is it possible in a VLOOKUP formula to make the table array a hyperlink to another sheet in a wookbook. This is my formula: =IF(D6="","",VLOOKUP($B6,DLF!$B$4:$F$20,5,FALSE)) <colgroup><col width="100"></colgroup><tbody> </tbody> As you can see, column C is the positions that the...

Hey again all!! As always you guys/gals are the greatest!! I found a neat formula in an array, Tested it as it was setup and works great. When i go to modify it I get 3 results and boom it stops dead well rather it returns a blank as instructed. Table: Group Header: Group Entries: Fox, Bear...

Hi, I am trying to create a macro to copy data from one excel workbook to another. I need to do this for each name listed. There may be multiple lines for each name so must filter for each name and copy all data. The list of names will differ each day that this macro is run so i cannot use the...

Is it possible to derive a countifs using two criteria with different array range - one horizontal and one vertical. Please see example below <tbody> a b c d e f g h i j 1 Name John George Alex Allicia 2 s1 1 1 0 0 3 s2 0 0 0 0 4 s3 1 0 1 0 5 s4 0 0 0 1 6...

Hi, I have multiple sheet in given workbook. Each sheet filled with Column A:E with same number of rows. I would like to combine all these sheets into one sheet and highlight the row for the column header named as "Order" with "Yes" option. Sheet1 <colgroup><col...

Hello, I am trying to build a schedule and I have names in Column A and their shift assignments populated in the rest of the columns. What I would like to do is have a row below that table that will tell me which employee will be working AM and which employee would be working PM on each day...

Hi, I have the following table; <tbody> A B 1 Alex 60 2 Brad 60 3 Chris 50 4 Dave 60 5 Elli 70 </tbody> I then rank 1 to 5 from highest to smallest. Using =LARGE(B:B,1), =LARGE(B:B,2) and so on down to =LARGE(B:B,5) According to the value of each ranked item in column...