Results 1 to 3 of 3

Thread: finding variations in the data base

  1. #1

    finding variations in the data base



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hey. can someone help me with a macro something , I have a file with more varinte of those variants want to know who were often together.

    I have some formulas in the file , but I am looking to take a lot of time manually , CF- CM cells are options that I 'm looking for them , the NC is a formula that shows how many times it is found , as well as the CD .

    how can I seek them , a macro something to look each numbers of cells CF- CM and look in her right whenever found

    mod.xlsx

  2. #2

  3. #3
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    901
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by adryan View Post
    formula that shows how many times it is found
    I can help you only if I give you a link to an example. This example is not in English, but you have the possibility of downloading a file. There you can see the formula for counting the numbers that appear in specific range
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

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