criteria based

  1. V

    Unique ID between two date ranges

    Hello, Would like assistance to run a query in Access for the table below, where the ID is a text format. Date ID Value 4/15/2020 ABA 2.00 4/15/2020 NHB 1.00 4/19/2020 BBB 0.222 4/20/2020 RRRf 1.55 5/1/2020 NNN 9.55 5/2/2020 JUY 2.22 5/2/2020 YYY 2.22...
  2. A

    Hyperlink with Criteria

    Hi guys. Is there a way to edit the below formula so that the worksheet name is referenced to a cell?? - "2020" is a cell. =HYPERLINK("#"&ADDRESS(MATCH(A4,'2020'!A:A,0),8,1,1,"2020"),"Link")
  3. J

    Formula will not automatically adjust when adding/removing rows?

    I could use some help with this formula...
  4. J

    Update column in worksheet based on criteria with data from another worksheet

    Hi there, I'd like help creating a macro that allows me to essentially copy and paste information from one worksheet to another based on criteria that will save a great amount of time were it done manually. In the main worksheet I have a column labelled 'Reference' and a column labelled...
  5. H

    Distinct Count based on given criteria

    Hello, I am looking some help in getting distinct count by criteria. For example if you refer the below table I brought the distrinct count by using formala {=Sum(1/Countif(A:A,A2))} however, in additon to this need another conditional criteria. If given % different for no then it should...
  6. S

    Copy data from one sheet to another based on criteria

    On sheet one I have event dates in column C starting on row 7 and ending on row 105, event names in column D starting on row 7 and ending on row 105, and event type drop down in column F starting in row 7 and ending on row 105 with a color coded fill that changes with event type in column E...
  7. P

    A More Complex List of Unique Distinct Values Based on a Criteria

    Hi! Here's my problem. Basically, I need the data that is on the table on the left to look the one on the right. Order IDs listed on B, the item/s ordered on C, and the status is on D. I need the pending orders listed on the table on the right so that: a) Only the pending orders are shown b)...
  8. U

    VBA Search and Copy Data to Another Sheet

    Hi Guys, I have these data below and I was thinking of VBA codes where it will create 3 sheets based on Subject. The 3 Sheets name is based on Subject as well: Sheet 1 = Math Sheet 2 = Science Sheet 3 = History Each tab has the same header as the raw data. If the subject is math then it will...
  9. C

    VBA code to automatically insert a row below based on criteria

    Good day, I need VBA code to automatically insert a row below or inbetween rows based on criteria. In the example below, I need code to run row by row to check if the "OVER" column >0, if that case is true, it will check 3 conditions: 1) Check the "HOURS" column for the max hours such as 10.5...
  10. U

    VBA: Exclude Data Based on Date

    Hi Guys, Can you possibly help me of how to code for this scenario: Basically, I need to exclude the data not older than 4 years. However for the computation, the start date is not based from the current date but I want to set the date so a message box will pop asking me what is the starting...
  11. L

    A good starting point? Setting variables and applying formulas based on criteria met

    Hi Guys, I’m looking for a starting point to tackle a problem Iunderstand, but not in enough detail to be really specific… Basically, I need to simply retrieve or apply calculationsto customer agreement numbers, some of which will have 1 single line of data,simple as I can then just take the...
  12. U

    VBA - Copy Row Data Based on Criteria

    Hello Excel Gurus, I was thinking of creating a macro based on below criteria: 5 Tabs will be created in running the macro: 1. New - New accounts that doesn't have any previous data (Copy Whole row) 2. Zero - Accounts that doesn't have any score currently but previously existing (Copy Whole...
  13. U

    Filter and Copying of Data on Another Sheet

    Hello Guys, So I have below data on Sheet1 with a range A4:BC. What if I want to Filter all those that returned as "FALSE" (in T/F Check Column) and copy those related columns namely "Inital Check", "Check', & "T/F Check" on another tab sheet named "Check" in range E1:G1. <tbody> A1 -...
  14. S

    Conditional / Drop Down List Multiple Filter

    Hi everyone, Background: <tbody> A B C D Policy Issue Service Benefits Application Service Request Analysis underwriting Policy Accounts Payout Payment Admin </tbody> <tbody> </tbody> The Blue text in Column A is level 1 data; the red text in B,C and D column is Level 2 data...
  15. D

    Looping from bottom to cut/paste varying length sections of column to next available column

    Hey Guys, I've been trying to figure this out but could really use some help. I have an output file from a machine that comes in a long list in column A. I'm trying to write a vba macro that goes through the list and moves a varying length section (based on header) to the next available row...
  16. N

    VBA - Transferring certain columns of data to another sheet that meet a criteria

    I am using code to transfer data that don't have a blank cell in column A from "Data" to "ForIndustry". While the code works, I would like to only transfer columns A:P rather than the whole row. Any guidance would be much appreciated. Sub transfer() Set i = Sheets("Data") Set e =...
  17. G

    VBA to Highlight row if match criteria in another workbook

    Hello, I'm learning Excel VBA and I would appreciate help. I'm trying to highlight a row of data in one workbook (Table 1) if criteria in column A matches criteria in column A of another workbook. I need help referencing the other workbook without naming it explicitly, the...
  18. H

    Can a string of data be returned when you match 2 criteria?

    Just curious if a string of data can be returned if a set of criteria is met: Here is where I am going with this. <tbody> A B C D 1 123 Main Street Las Vegas, NV 88888 Criteria 456 My Avenue Miami, Florida 55555 2 456 My Avenue Miami, Florida 55555 Avenue 3 789 Their Boulevard...
  19. E

    Excel VBA. Highlight cells based on criterion

    Hi! I’m trying to find a simple solution for my Excel VBA script. Sorry for my bad English in advance..:) There is an excerpt from my code. Sub TEST() Range("E2").Value = Application.WorksheetFunction.CountIfs(Range("G4:G1000"), 100, Range("J4:J1000"), ">0") End Sub It puts (in E2 cell) an...
  20. G

    Easy Solution to SUMIFS with variable criteria???

    Hello All, I am looking for an easy solution to a rather tedious formula. Here's the situation... I have a list of data that I would like to SUMIFS. From that SUMIFS, I would like to subtract out values that meet certain criteria in another, separate range. Lets use an example to help better...

Some videos you may like

This Week's Hot Topics

Top