+ Reply to Thread
Results 1 to 2 of 2

Macro edit help.Count and list occurences of 1 line below the marked blue lines jumps

  1. #1
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Macro edit help.Count and list occurences of 1 line below the marked blue lines jumps

    I have a macro to check 3 cells that work flawlessly to match L7 M7 N7 on a range of 87 000 lines.It will jump to each occurrence and mark it blue.See macro Matching I am only looking for an amendment to check the cells underneath(1 line only) and list and count 3 numbers appeared the most after the numbers been found in L7 M7 N7.So the macro must count the occurrences -see the code below. .....I have already another macro with code but that will check all the columns and list data.My aim is to only list and count the data with the line and only count the 1 line after the highlighted blue line and not all the data -(Only red line marked in example attached.In my sample here attached The line that must be counted is marked red.....only as per example.So only all the red lines must be counted. If someone can only amend the macro that it will only checked the line after the blue marked line and count the red lines data only.Rep given for any help and correct amendment to achieve the above thank you

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Macro edit help.Count and list occurences of 1 line below the marked blue lines jumps

    bump bump bump

+ 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. Create Macro to copy X marked lines in 39 other Sheets to the First Sheet by order
    By Awaklin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2014, 06:32 PM
  2. Count number of cells that contain red, blue or red and blue
    By kjshearon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2013, 11:26 AM
  3. Replies: 2
    Last Post: 04-14-2011, 06:37 AM
  4. Vertical scroll bar jumps scrolls line 1 to line 2705?
    By GiGi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-28-2006, 12:40 AM
  5. [SOLVED] List Unique Occurences and Count
    By Alan Beban in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] List Unique Occurences and Count
    By PGiessler in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. List Unique Occurences and Count
    By PGiessler in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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