Results 1 to 9 of 9

find which row best matches the criteria

Threaded View

smky_j find which row best matches... 09-03-2010, 04:04 AM
zbor Re: find which row best... 09-03-2010, 04:07 AM
smky_j Re: find which row best... 09-04-2010, 08:36 PM
zbor Re: find which row best... 09-05-2010, 03:51 AM
zbor Re: find which row best... 09-05-2010, 02:46 PM
DonkeyOte Re: find which row best... 09-06-2010, 02:38 AM
zbor Re: find which row best... 09-06-2010, 03:40 AM
smky_j Re: find which row best... 09-06-2010, 06:44 PM
DonkeyOte Re: find which row best... 09-06-2010, 06:48 PM
  1. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,006

    Re: find which row best matches the criteria

    You can add this into next column (row 2,3,4 etc): =SUMPRODUCT(--(B$2:E$2=B3:E3)) and pull down...

    You can also by index match pull out row that matching criteria or you can higlight them as in eample.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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