+ Reply to Thread
Results 1 to 2 of 2

Search to see if text exists in a column, if it does then count the row

  1. #1
    Registered User
    Join Date
    02-15-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    13

    Search to see if text exists in a column, if it does then count the row

    I have 2 worksheets in Excel:

    Plot

    Please Login or Register  to view this content.
    Waypoint

    HbjM7.png

    How would I search column D in the Waypoint table to count where the plot+region (i.e. MK1, MK2...) matches the postcode and where the sequence is equal to 1.

    This is the formula I have so far:

    =SEARCH(CONCATENATE(B:B,"",A:A),Waypoint!D:D,"0")

    but it keeps returning #VALUE in the Plot table.

    I want it to concatenate whatever is in plot and region, then check column D in Waypoint to see if there are any matches, if there is a match is the value in sequence = 1, if so then count it... (sorry if this pseudocode is not clear enough)

    e.g. in the example above

    For plot 1, there are 2 matches so jobCount = 2
    For plot 2, there is 1 match so jobCount = 1
    For plot 4 there are 1 matches so jobCount = 1

    I hope it makes sense, I've tried very hard to be clear!

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Search to see if text exists in a column, if it does then count the row

    are you familiar with
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Search a column for a value and if it exists copy text from corresponding cell in column A
    By badlydrunkboy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2014, 06:13 AM
  2. IF(count(search) Function not working when search from text from a cell
    By joshnathan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-09-2013, 05:13 AM
  3. Search For Word in One Column, If Exists Put Text In Another Column
    By biohazard35 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-20-2012, 05:33 PM
  4. lookup text in a column and say if it exists
    By dandenson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2008, 01:57 PM
  5. Replies: 1
    Last Post: 04-12-2006, 10:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1