Results 1 to 19 of 19

how many cell in a row that contain certain combination from a larger combination

Threaded View

system how many cell in a row that... 11-13-2012, 02:53 PM
e.isayev Re: how many cell in a row... 11-13-2012, 03:01 PM
alansidman Re: how many cell in a row... 11-13-2012, 03:02 PM
system Re: how many cell in a row... 11-13-2012, 11:50 PM
alansidman Re: how many cell in a row... 11-14-2012, 07:47 AM
e.isayev Re: how many cell in a row... 11-14-2012, 08:04 AM
system Re: how many cell in a row... 11-14-2012, 11:58 AM
system Re: how many cell in a row... 11-15-2012, 02:24 PM
e.isayev Re: how many cell in a row... 11-15-2012, 02:40 PM
system Re: how many cell in a row... 11-15-2012, 03:17 PM
e.isayev Re: how many cell in a row... 11-15-2012, 03:20 PM
system Re: how many cell in a row... 11-15-2012, 03:18 PM
system Re: how many cell in a row... 11-16-2012, 02:01 PM
Ace_XL Re: how many cell in a row... 11-16-2012, 03:57 PM
e.isayev Re: how many cell in a row... 11-17-2012, 06:54 AM
system Re: how many cell in a row... 11-17-2012, 02:17 PM
e.isayev Re: how many cell in a row... 11-17-2012, 03:04 PM
  1. #6
    Registered User
    Join Date
    10-02-2012
    Location
    Baku
    MS-Off Ver
    Excel 2010
    Posts
    273

    Re: how many cell in a row that contain certain combination from a larger combination

    Hi.
    I came up with that solutions. I use helper columns to identify wether cell includes required set of numbers which all of them in one cell. then sum those 1"s to get total number

    =IF(COUNT(FIND(ISNUMBER(MID($E$1,ROW(INDIRECT("1:"&LEN($E$1))),1)*1)*MID($E$1,ROW(INDIRECT("1:"&LEN($E$1))),1),A1,1))=COUNT(MID($E$1,ROW(INDIRECT("1:"&LEN($E$1))),1)*1),1,0)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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