Results 1 to 8 of 8

Filter matrix based on a non-exact match

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-31-2008
    Location
    Brazil
    MS-Off Ver
    Office 365
    Posts
    108

    Question Filter matrix based on a non-exact match

    I would like to make an average of the numbers in column B that matches a criteria on column A. The problem is that is not an exact match.

    The names below are on column A:

    VW Gol 10/11 - AADDD
    FIAT Strada 09/10 - HHH3456
    FORD Fox 08/09 - ZZZ3333
    VW Gol 13/13 - FRT4444
    FORD Fox 02/02 - RRR4444

    Column B contains numbers.

    I want an average of numbers that match VW Gol and FORD Fox etc. All of them. Which means excel need to ignore what comes later and gather all the numbers and make an average. The problem is that what comes later is not in a defined number of characters. Is it possible?
    Last edited by douglascaixeta; 03-31-2013 at 04:41 PM.

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