alex

  1. A

    Macro to Summarize Address Data

    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...
  2. S

    IF with multiple conditions

    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...
  3. J

    Vlookup between 2 dates ?

    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...
  4. I

    calculation help

    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...
  5. I

    help with adding max date

    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...
  6. I

    count ifs with date range from date time field

    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...
  7. I

    Count ifs with date range

    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...
  8. A

    Formula for auto entry based on last cell with value

    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...
  9. H

    Sequential numbering based on change in another column

    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...
  10. W

    Add more conditions to IF formula

    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
  11. M

    Saving file name with the last business day in YYYYMMDD format

    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...
  12. X

    Sumproduct combined with a condition of subject to maximum

    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...
  13. S

    Can you put a hyperlink in a Vlookup formula?

    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...
  14. A

    Using Index, Small, Row, Rows in Array... Stops working..

    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...
  15. K

    Macros to filter for each Unique Value

    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...
  16. Y

    COUNTIFS with different array range

    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...
  17. A

    Merge Multiple column from different sheet and highlight the row with unique value.

    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...
  18. T

    Cross referencing cells based on text?

    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...
  19. D

    Formula to find multiple results from 1 table source

    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...
  20. G

    Display Digits

    Hi, Does anyone know if its possible for excel to do the following? EG: 9.9+0.1=10.0 Id like a cell to show the 0.0 instead of the 10.0. Cheers, Alex

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top