+ Reply to Thread
Results 1 to 28 of 28

COUNTIF/SUMPRODUCT(?) to create a matrix from data

Hybrid View

diamond chap COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 12:37 PM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 12:42 PM
AliGW Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 12:43 PM
diamond chap Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 01:10 PM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 02:17 PM
diamond chap Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 02:39 PM
AliGW Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 02:20 PM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 02:21 PM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 02:44 PM
diamond chap Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 03:09 PM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-23-2019, 03:13 PM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 05:34 AM
diamond chap Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 07:36 AM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 07:37 AM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 08:35 AM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 08:36 AM
Sadath31 Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 09:26 AM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 09:28 AM
diamond chap Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 11:38 AM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 11:45 AM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 12:07 PM
diamond chap Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 12:25 PM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-24-2019, 12:28 PM
diamond chap Re: COUNTIF/SUMPRODUCT(?) to... 11-25-2019, 04:15 AM
Sadath31 Re: COUNTIF/SUMPRODUCT(?) to... 11-25-2019, 01:12 AM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-25-2019, 07:23 AM
diamond chap Re: COUNTIF/SUMPRODUCT(?) to... 11-25-2019, 10:48 AM
Glenn Kennedy Re: COUNTIF/SUMPRODUCT(?) to... 11-25-2019, 10:52 AM
  1. 11-23-2019, 01:10 PM #1
    diamond chap is offline
    Registered User
    Join Date
    11-23-2019
    Location
    Edinburgh, Scotland
    MS-Off Ver
    365
    Posts
    19

    Re: COUNTIF/SUMPRODUCT(?) to create a matrix from data

    Apolgies. The data is approx. 130 rows by 61 columns. Extract from the data attached, with the output sheet showing an example of one cell of what I'm trying to achieve.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct multiple criteria query
    By Millixcel in forum Excel General
    Replies: 3
    Last Post: 05-03-2018, 07:24 AM
  2. Create a new table (or matrix) from an exported set of data from a website.
    By dherrero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2014, 11:19 AM
  3. VBA code/loop that copies and pastes data from a matrix to create historical time series
    By cog38 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-18-2013, 11:28 PM
  4. Trying to create an output grid/matrix with custom data.
    By JoeTheBro in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2013, 10:47 AM
  5. Data Validation with wildcards and countif/sumproduct to prevent multiple entries
    By Muffin83 in forum Excel General
    Replies: 3
    Last Post: 10-18-2010, 11:09 AM
  6. Create a matrix from data in three column
    By sa02000 in forum Excel General
    Replies: 3
    Last Post: 06-27-2006, 09:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1