+ Reply to Thread
Results 1 to 6 of 6

modify formula Aggregate on columns

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    modify formula Aggregate on columns

    As you can see from the attached file in the sheet2
    I inserted a formula that should bring me back all the numbers that are found mel sheet "Conteggio" in yellow that have a letter "D" in column C.G, ...
    But it does not work properly
    How to modify it?
    Thank you
    Attached Files Attached Files
    Last edited by Berna11; 01-04-2019 at 04:57 PM.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: mpdify formula Aggregate on columns

    see attached file.
    Typical formula used:

    HTML Code: 
    Array Formula [enter with ctrl+shft_ent.
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Re: mpdify formula Aggregate on columns

    Thanks but, dragging to the right leaves 4 empty columns you have to delete them or change the reference on each column.

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: modify formula Aggregate on columns

    Ciao,

    Per Excel 2010:

    =IFERROR(INDEX(INDEX(Conteggio!$A:$S,,4*(COLUMNS($A1:A1)-1)+1),AGGREGATE(15,6,ROW(Conteggio!A$3:A$27)/(INDEX(Conteggio!$A$3:$S$27,,4*COLUMNS($A1:A1)-1)="D"),ROWS(A$1:A1))),"")

    =SE.ERRORE(INDICE(INDICE(Conteggio!$A:$S;;4*(COLONNE($A1:A1)-1)+1);AGGREGA(15;6;RIF.RIGA(Conteggio!A$3:A$27)/(INDICE(Conteggio!$A$3:$S$27;;4*COLONNE($A1:A1)-1)="D");RIGHE(A$1:A1)));"")

    Saluti.
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  5. #5
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Re: modify formula Aggregate on columns

    Grazie XOR LX
    PERFETTA funziona bravo!!!
    rispondo in italiano
    Ciao grazie ancora

  6. #6
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742
    Di niente!

    Ciao

+ 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] Aggregate Rows of Data if Condition is met (if 2 Columns contains dup values)
    By popcorn7 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-28-2018, 10:27 AM
  2. [SOLVED] Aggregate values in columns based on a cell identifier
    By bjarmeister in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-30-2015, 03:33 AM
  3. [SOLVED] Function to aggregate columns from different sheets and workbooks
    By Boo123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2015, 02:52 PM
  4. Aggregate totals for columns by category vs budget
    By FuzzyFrog in forum Excel General
    Replies: 4
    Last Post: 04-23-2014, 10:31 AM
  5. Aggregate data / remove empty columns
    By patapsco59 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2014, 11:25 AM
  6. Aggregate data in a range of columns to remove blank cells
    By arbgd1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2013, 04:11 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