rows matching criteria

  1. Ed_Filipino

    Auto copy rows w/ specific value from sheet to another sheet

    hi good day may you can help me to make a code regarding the table I need. I have a table w/ 5 columns (please see below) that I am running for now. <tbody> CODE DATE RUNNING HOURS REPAIR DONE MECHANIC FE25 29-Jan-18 5,000 CHANGE BATTERY RED FE26 30-Jan-18 4,560 CHANGE RIMS...
  2. E

    Extracting a List of Values Filtered by Criteria with Sub-Arrays

    Hi guys, This is my first post on this forum so sorry if it's not clear but I'm hoping for some help with a formula. I'm trying to design a formula that will present people with a list of holiday destinations based upon when they'd like to go. On the sheet 'Countries' there's data with each...
  3. S

    excel as a search engine

    Hello, I'm trying to develop a vba code to use excel as a search engine. I have created a cell which bears the input(in sheet(2)). I want excel to search for the input(which lies in the first column of Sheet(1)) , once it's found, take every column corresponding to the result and search for it...
  4. J

    Hiding range of rows

    Hello - I am having trouble with finding a value in cells in "A" (= "ethnic balance") and hiding rows in a certain range around the found value. Here is what I have started but cant get to work: Sub HideRows() Application.ScreenUpdating = False Dim i As Long Dim Lastrow As Long Dim hRow, uRow...
  5. T

    Nth Result, Skipping rows

    Hi everyone, I have a spreadsheet tracking monthly insurance payments. I want to create a list at the bottom of my spreadsheet that will populate with the individuals names that have not paid for each month. Each person spans across 4 rows. When someone loses coverage, I merge the 4 rows for...
  6. P

    Using Structured References and index,row functions

    Hi There I have a formula that is doing exactly what I want when on a set table on the same sheet where I can manually define the arrays... see below Sample Original Data: Table3 <tbody> A43 B C D E F G H I J K L M 44 45 Month Type Candidate Client TOTAL...
  7. J

    Lining up rows of data

    I have a very long list of data. Is there a way to quickly line up two rows?</SPAN> example:</SPAN> I import data into Excel 2007 and get this results:</SPAN> <COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> <TBODY> A</SPAN></SPAN> B</SPAN></SPAN> C</SPAN></SPAN>...
  8. A

    Find row number based on criteria

    I'm trying to create a "find" feature for a workbook. Lets say I have a spreadsheet with 10 columns. I am looking for the word "apple" in any of the cells in those 10 columns. It may appear in the 2nd column or the 8th column, or any other column. It also most likely will not be the first...
  9. B

    Clear Content in Row - Based on value in column

    Hello...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I need a little bit help... I think it should be easy code.. Looking to clear content in a row based on a value in a column. I am trying to clear all contents in a row based on the value of "Yes" in...
  10. K

    Macro to Copy & Paste only rows with data

    I have the following issue: Rows are populated with data based on date listed (Rows 6-20). The formula puts a " " if the date cell is blank since the range of data is not the same each time the data pull is imported. What I need is a macro that only copies and then pastes to another sheet...
  11. P

    Comparing rows of data with the same key field...

    HI, I am trying to compare rows of data that have the same key field identifying them. For example - EMPLID Compensation 1234 10000 1234 10000 1234 10000 1234 10000 1245 15000 1245 15000 1245 15000 For every row...
  12. C

    Count number of rows matching criteria

    So I've started to play around with Excel a bit and stumbled on a problem which I haven't managed to find a solution for. It's a lottery game I'm making statistics of. In this lottery they draw 20 numbers out of 70 possible. I have gathered into a spreadsheet some of the winning numbers (that is...

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