+ Reply to Thread
Results 1 to 2 of 2

Matrix Tekst

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2013
    Posts
    5

    Matrix Tekst

    Hi,

    I just discoverd the power of matrix formula's and I wanna try how far this platform goes with it.
    I am able to make a sum under conditions with use of the following formula:

    {=SUM(((Table1[Weldtype]=$AU50)+(Table1[Weldtype]=$AU49)+(Table1[Weldtype]=$AU48))*Table1[Weldlength])}
    AND
    (ctr+shift+enter)

    This formula (above) allows to give me (in ONE CELL) a sum of all the weldlengths were Weldtype is PP and FW.

    See pic below for excel DATA.

    Knipsel.PNG

    My next goal is trying to generate IN ONE CELL a list of welders under the condition that Weldtype is PP AND FW.
    So the formule must generate me:

    "AB, GH, IJ, MN, OP, QR, UV, YZ, AZ, DW"

    Does anyone has an idea if this is possible?
    Attached Images Attached Images

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Matrix Tekst

    You would need a VBA function to do that.

    Are you open to that solution?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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] Convert tekst to data for calculation
    By lentebriesje in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-29-2013, 01:44 AM
  2. Changing tekst mm:ss to decimal time
    By DeBossman in forum Excel General
    Replies: 2
    Last Post: 05-07-2012, 09:12 AM
  3. Load tekst with combobox
    By vds in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-06-2010, 06:57 AM
  4. [SOLVED] Tekst in een tekstfile wijzigen met VBA Excel
    By pieros in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2005, 04:58 AM
  5. import tekst >65536 rows
    By Reniek in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2005, 06: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