Search:

Tag: matrix

Page 1 of 5 1 2 3 4

Search: Replies Views Search took 0.01 seconds.

  1. How can I convert data from vertical format to a matrix in excel using VBA?

    Started by Gerardo.Cantu‎, 03-06-2024 03:13 PM
    matrix, transposing data, vba 4 Attachment(s)
    • 210
    Last Post: 03-08-2024 08:45 AM
    by jindon  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  2. Flatten a Random Matrix

    Started by andy521‎, 02-07-2024 08:34 PM
    matrix, tocol, unique 4 Attachment(s)
    • 314
    Last Post: 02-08-2024 05:50 PM
    by DJunqueira  Go to last post

    Forum:
    Excel General

  3. How to set cell color based on several factors - help appreciated

    Started by nossucram‎, 12-27-2023 12:38 PM
    conditional formatting, matrix, several inputs 2 Attachment(s)
    • 176
    Last Post: 12-28-2023 04:43 AM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  4. How to covert a Matrix to a List in Columns?

    Started by JPWRana‎, 09-15-2023 01:03 PM
    columns list, list, matrix, matrix conversion 4 Attachment(s)
    • 514
    Last Post: 09-18-2023 04:43 PM
    by alansidman  Go to last post

    Forum:
    Excel General

  5. [SOLVED] Summarise a matrix

    Started by Pixandco‎, 05-07-2023 10:05 AM
    matrix, sumifs, summary 4 Attachment(s)
    • 417
    Last Post: 05-07-2023 10:56 AM
    by CARACALLA  Go to last post

    Forum:
    Excel Formulas & Functions

  6. Calculate Matrix automated and based on input values

    Started by Pip1405‎, 11-10-2022 10:46 AM
    auto adjust, excel & formula, formula assistance, matrix
    • 366
    Last Post: 11-10-2022 10:48 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  7. [SOLVED] Read prices from matrix and write them in rows

    Started by morrisgump‎, 11-04-2022 06:01 AM
    matrix 5 Attachment(s)
    • 394
    Last Post: 11-04-2022 06:41 AM
    by AliGW  Go to last post

    Forum:
    Excel General

  8. [SOLVED] Reverse Lookup

    Started by blak9‎, 07-07-2022 08:46 AM
    matrix, reverse lookup 3 Attachment(s)
    • 317
    Last Post: 07-07-2022 10:28 AM
    by blak9  Go to last post

    Forum:
    Excel Formulas & Functions

  9. Aggregations of a matrix

    Started by emeria‎, 06-17-2022 11:27 AM
    aggregation, excel, matrix, skills matrix, top 10 list 2 Attachment(s)
    • 537
    Last Post: 06-22-2022 09:32 PM
    by emeria  Go to last post

    Forum:
    Excel General

  10. [SOLVED] Replace diagonal value in a sequence

    Started by ohnewbie‎, 03-20-2022 10:21 AM
    diagonal, matrix, vba 6 Attachment(s)
    • 511
    Last Post: 12-24-2022 01:12 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  11. Grouping points on scatter matrix

    Started by JamesWM‎, 02-10-2022 01:59 PM
    coordinate, grouping, matrix, scatter plot, slopes 2 Attachment(s)
    • 312
    Last Post: 02-10-2022 02:18 PM
    by MrShorty  Go to last post

    Forum:
    Excel Formulas & Functions

  12. how to divide columns into new rows

    Started by ankitaaq‎, 08-19-2021 06:06 AM
    matrix 1 Attachment(s)
    • 403
    Last Post: 08-21-2021 06:52 PM
    by JeteMc  Go to last post

    Forum:
    Excel General

  13. Post code calculator- any help would be hugley appreciated

    Started by chris.birlea‎, 08-11-2021 06:02 AM
    calculator, excel, formula, matrix, postcode 1 Attachment(s)
    • 331
    Last Post: 08-11-2021 06:33 AM
    by AliGW  Go to last post

    Forum:
    Excel General

  14. [SOLVED] Average based on value if ref. exist in matrix

    Started by RobinHen‎, 06-26-2021 01:10 AM
    average, matrix, reference 2 Attachment(s)
    • 540
    Last Post: 06-26-2021 03:24 AM
    by wk9128  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Converting a matrix into 3 normalised tables

    Started by AndyRob1973‎, 05-14-2021 09:52 AM
    matrix, normalise 3 Attachment(s)
    • 875
    Last Post: 05-19-2021 04:24 AM
    by AndyRob1973  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  16. [SOLVED] Compare the value to Matrix and provide out as count

    Started by shankicool‎, 02-18-2021 08:12 AM
    count, lookup, matrix 3 Attachment(s)
    • 528
    Last Post: 02-18-2021 09:40 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  17. Lookup formula to return multiple hits on multiple rows and values from multiple columns

    Started by Mattr13‎, 02-08-2021 11:45 AM
    columns, lookup, matrix, multiple, rows 1 Attachment(s)
    • 690
    Last Post: 02-12-2021 07:21 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  18. Google Sheets: Trying to make a matrix with 1 and 0 based on 3 different tabs in the sheet

    Started by RobbertDG‎, 01-30-2021 05:44 AM
    formula and functions, google sheets, matrix 1 Attachment(s)
    • 767
    Last Post: 01-30-2021 06:30 AM
    by AliGW  Go to last post

    Forum:
    For Other Platforms(Mac, Google Docs, Mobile OS etc)

  19. [SOLVED] Transform data to matrix (with repeated headings)

    Started by pinebush‎, 01-11-2021 12:48 PM
    matrix, pivottabe, power bi, transform, vba 2 Attachment(s)
    • 1,115
    Last Post: 01-13-2021 08:09 PM
    by pinebush  Go to last post

    Forum:
    Excel General

  20. How to select one row from each group of columns under a condition

    Started by JOAO12‎, 12-28-2020 10:24 AM
    array, duplicates in column, matrix, vba 2 Attachment(s)
    • 711
    Last Post: 01-02-2021 11:50 PM
    by JOAO12  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  21. Transposing a large "ladder" shape matrix

    Started by s2031015‎, 12-08-2020 04:11 AM
    excel, ladder, matrix, transpose 7 Attachment(s)
    • 1,023
    Last Post: 12-09-2020 01:18 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

  22. [SOLVED] How to convert a Huge matrix to a column?

    Started by sushiant‎, 10-30-2020 02:09 AM
    huge data, matrix, single column
    • 446
    Last Post: 10-30-2020 03:11 AM
    by nankw83  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  23. [SOLVED] Getting a vertical array containing the maximum values from each row of a 2D matrix

    Started by Marbleking‎, 08-14-2020 02:41 PM
    array, matrix, maximum, subtotal 1 Attachment(s)
    • 577
    Last Post: 08-15-2020 12:19 PM
    by Bo_Ry  Go to last post

    Forum:
    Excel Formulas & Functions

  24. A cell value to matrix

    Started by pguhl‎, 04-27-2020 09:38 PM
    matrix 1 Attachment(s)
    • 611
    Last Post: 04-27-2020 10:31 PM
    by FDibbins  Go to last post

    Forum:
    Excel - New Users/Basics

  25. Formula in two cells different result and not working for another item

    Started by #läuftbeimir?!‎, 12-02-2019 04:53 PM
    array, different result, ifs, matrix, maxif 1 Attachment(s)
    • 420
    Last Post: 12-02-2019 06:25 PM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  26. VBA Create A matrix of data from tables

    Started by shelim481‎, 11-25-2019 09:54 AM
    data selection, matrix, vba 2 Attachment(s)
    • 657
    Last Post: 02-10-2020 10:30 PM
    by jindon  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  27. Most frequent text (not number) within a very large matrix not a single row or column

    Started by leehowardblair‎, 10-07-2019 01:53 PM
    common, frequent, matrix, range 3 Attachment(s)
    • 596
    Last Post: 10-11-2019 02:03 AM
    by menem  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Index, Match. Reporting from skills matrix

    Started by KristofferA‎, 10-02-2019 01:54 PM
    formula, index, match, matrix, reporting 1 Attachment(s)
    • 391
    Last Post: 10-02-2019 02:24 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  29. Return Upper Value from Matrix based on differing criteria

    Started by activeman‎, 09-08-2019 03:38 AM
    matrix 2 Attachment(s)
    • 349
    Last Post: 09-09-2019 01:55 AM
    by activeman  Go to last post

    Forum:
    Excel Formulas & Functions

  30. Search information in a db interval

    Started by dontafy‎, 06-18-2019 07:44 PM
    database, matrix, search a cell 1 Attachment(s)
    • 539
    Last Post: 06-18-2019 08:13 PM
    by MrShorty  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Searching a matrix to signal duplicate rows

    Started by R.Durbs‎, 06-04-2019 11:18 AM
    duplicate, matrix, search 2 Attachment(s)
    • 907
    Last Post: 06-05-2019 11:47 AM
    by 63falcondude  Go to last post

    Forum:
    Excel Formulas & Functions

  32. VBA Optimization using matrixes

    Started by whitetigerck‎, 05-21-2019 09:03 AM
    matrix, optimization, vba 1 Attachment(s)
    • 387
    Last Post: 05-21-2019 10:10 AM
    by whitetigerck  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  33. Function needed to execute a minor of 2*2 matrix

    Started by Nkrekor‎, 03-09-2019 02:34 AM
    array, excel, matrix, vba
    • 605
    Last Post: 03-09-2019 02:51 AM
    by AliGW  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  34. Calculate Inner Prod of a pair of 4*3 Matrices using vb w/o built-in functions.

    Started by Nkrekor‎, 03-08-2019 02:30 AM
    excel, inner product, matrices, matrix, vba
    • 512
    Last Post: 03-09-2019 02:53 AM
    by AliGW  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  35. Matrix Style Reading: Reading from one cell to cause change in another cell

    Started by snkhan‎, 01-22-2019 03:56 AM
    cells, drop dowm list, matrix 3 Attachment(s)
    • 527
    Last Post: 01-23-2019 01:52 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Programming / VBA / Macros

Results 1 to 35 of 147
Page 1 of 5 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1