+ Reply to Thread
Results 1 to 5 of 5

repeating nr

  1. #1
    Registered User
    Join Date
    09-10-2020
    Location
    worcester
    MS-Off Ver
    2016
    Posts
    43

    repeating nr

    Hi All,
    So i need a little help with some codes
    So i have an array with numbers from 1 to 60
    and some numbers in a rnage of cell(A2:F10)
    I need to see each number from array how many times
    it is(repeating) in that range
    this is waht i done but i dont know how to do the rest of code
    Please Login or Register  to view this content.
    Thank you.
    Untitled.png

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: repeating nr

    Example
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-10-2020
    Location
    worcester
    MS-Off Ver
    2016
    Posts
    43

    Re: repeating nr

    Thank you very much
    like everytime you answer it is ok
    works
    BUT sorry for that i dont understand exactly how you done
    there is an easyest example for my issue?
    But thank you again

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: repeating nr

    Simple example
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-10-2020
    Location
    worcester
    MS-Off Ver
    2016
    Posts
    43

    Re: repeating nr

    Thank you very 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. [SOLVED] Move Repeating and Non-Repeating Names into separated columns
    By aaaaa34 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-23-2019, 03:02 PM
  2. [SOLVED] How to find non-repeating values in Column B for repeating values in Column A
    By jdegeorge in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-16-2017, 01:43 PM
  3. [SOLVED] Repeating IF?
    By sherlock1241 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-18-2016, 11:45 AM
  4. creating a repeating formula that doesn't show repeating values
    By cybershot in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-09-2010, 06:12 PM
  5. Repeating a seven row sum
    By TheLazyUpstart in forum Excel General
    Replies: 4
    Last Post: 08-11-2009, 06:17 AM
  6. [SOLVED] non-repeating bg
    By stewart08 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-02-2008, 06:20 AM
  7. [SOLVED] Repeating
    By Lynn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2005, 01:06 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