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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top