+ Reply to Thread
Results 1 to 3 of 3

VBA check row 8 value in column A1:A5 if match show xys and count xyz in second row

  1. #1
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    241

    VBA check row 8 value in column A1:A5 if match show xys and count xyz in second row

    Hi All,

    thanks for your support and help

    we have attached a sheet, there is two formula

    one is match, it will check the cell value to five fixed value and if find the match, show the result
    second will count the number of continue result and single result

    we want a vba, programme, macro who can check, match and after that show the number of time and single, as per attached sheet
    Attached Files Attached Files
    Last edited by Ajay45822; 11-12-2019 at 06:09 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Match and count - VBA / formula / Macro / Programming

    Title much more descriptive. Thx
    Last edited by Pepe Le Mokko; 11-12-2019 at 11:55 AM.

  3. #3
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    241

    Re: Match and count - VBA / formula / Macro / Programming

    Thanks for your attention on my post Pepe Le Mokko,

    We have edited, hope now its ok as per forum rule #1

+ 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] Pivot Table average in stead of Grand Total
    By Willem87 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-01-2019, 07:43 PM
  2. Modding search engine with row in stead of cell
    By Jacobs.ya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2016, 03:05 AM
  3. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  4. [SOLVED] Use the first 3 decimals in stead of rounding
    By Hein in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-17-2014, 09:07 AM
  5. VBA formula in stead of Countif & OR/AND to get quick and light file
    By congthanh6868 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-04-2014, 04:34 PM
  6. Display expanded formula in cell in stead of cell references
    By vnr2583 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-24-2013, 10:06 PM
  7. [SOLVED] Excel showing a row of ##### in stead of dollars, but when
    By Jammie in forum Excel General
    Replies: 2
    Last Post: 04-03-2006, 02:30 PM

Tags for this Thread

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