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

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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