criteria based

  1. J

    Formula will not automatically adjust when adding/removing rows?

    I could use some help with this formula...
  2. 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...
  3. 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...
  4. 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...
  5. 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)...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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 -...
  12. 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...
  13. 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...
  14. 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 =...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. C

    Excel Lookup function

    Hello, I am looking to derive a value based on a variable data set. I want take the date that is chosen and find that value in Column C then look to Column E's # that is chosen and give me the value from Column C that is that # (in this case 1) day prior to the Date I entered. Another kicker is...
  20. K

    Copy rows from one workbook to another workbook if certain criteria is met

    My setup: (2 Workbooks) Workbook 1 "Line Audit Workbook", Workbook 2 "Data" Workbook 1 has 2 worksheets - "1st Shift" and "2nd Shift" Workbook 2 has 1 worksheet - "Data". In workbook 1, both worksheets are set up identically with 13 columns. Each shift (1st Shift and 2nd Shift) gets information...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top