+ Reply to Thread
Results 1 to 4 of 4

Count Number of Image Occurances

  1. #1
    Registered User
    Join Date
    04-22-2015
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    2

    Count Number of Image Occurances

    I am trying to make a worksheet that lets me place images and lets me count the number of times the image appears.
    As per the image attached, I would like to have a cell that can count four doors and put the result in a cell.
    I'm not sure if this is formula or VBA solution, I've spent 2 days looking for an answer so far - any help would be most appreciated.
    example.JPG

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Count Number of Image Occurances

    probably...
    if you name the "image" in a certain manner you can get vba to count image occurrence
    however you will need to set this up when as you add new images as it doesnt "read" or "look" at what the image is
    so if you accidentally call something the wrong name this error will perpetuate
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Count Number of Image Occurances

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by humdingaling; 04-24-2015 at 09:39 AM.

  4. #4
    Registered User
    Join Date
    04-22-2015
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    2

    Re: Count Number of Image Occurances

    humdingaling, you are a champ!!

    That's exactly what I needed. Thank you so much.

+ 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. Count number of occurances in a column
    By migreatlakestate in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2014, 02:43 PM
  2. [SOLVED] want to count number of occurances on weekdays/weekends
    By phango13 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-14-2014, 08:07 PM
  3. [SOLVED] Count the number of occurances of a particular value
    By vignesh805 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 04:50 AM
  4. Count the number of occurances of a value in a range.
    By pi**edasanewt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2008, 07:08 AM
  5. [SOLVED] count number of occurances of a word in a range
    By John Davies in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2006, 09:50 AM

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