Search:

Tag: array formula

Page 1 of 8 1 2 3 4

Search: Replies Views Search took 0.01 seconds.

  1. [SOLVED] How can I extract unique months from one column to an another column?

    Started by B.W.B.‎, 01-11-2024 09:24 AM
    array formula, countif, index, match, unique records 4 Attachment(s)
    • 187
    Last Post: 01-14-2024 02:36 PM
    by DJunqueira  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Populate are offseted range with array formula

    Started by egoosen3‎, 09-28-2023 06:51 AM
    array formula, range offset 1 Attachment(s)
    • 240
    Last Post: 09-28-2023 07:02 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  3. Xlookup array formula problem

    Started by egoosen3‎, 07-14-2023 06:27 AM
    array formula, xlookup 1 Attachment(s)
    • 408
    Last Post: 07-14-2023 08:48 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  4. Advanced array formula help

    Started by Adativs‎, 04-17-2023 03:10 PM
    array formula, lookup 2 Attachment(s)
    • 382
    Last Post: 04-19-2023 06:15 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] Need help solving Excel challenge with related vlaues

    Started by kakaNit‎, 12-21-2022 12:05 PM
    array formula, challenge, lookup, related items 1 Attachment(s)
    • 358
    Last Post: 12-22-2022 03:36 AM
    by sandy666  Go to last post

    Forum:
    Excel Formulas & Functions

  6. Iterate Through an Array of Values to Determine SUMPRODUCT?

    Started by takoyaki‎, 11-15-2022 01:21 PM
    array formula, sumproduct
    • 393
    Last Post: 11-15-2022 03:12 PM
    by takoyaki  Go to last post

    Forum:
    Excel Formulas & Functions

  7. [SOLVED] Array Formula that Looks Up and Returns Values from a Table

    Started by takoyaki‎, 08-29-2022 12:13 PM
    array formula, filter, sequence 1 Attachment(s)
    • 332
    Last Post: 08-29-2022 01:53 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] Using SEQUENCE Array Formulas - Varying Repeating Sequence

    Started by takoyaki‎, 08-28-2022 04:24 PM
    array formula, sequence
    • 886
    Last Post: 08-29-2022 06:43 AM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  9. Faster way of writing two formulas?

    Started by Barking_Mad‎, 08-19-2022 05:00 AM
    array formula, faster, max, slow
    • 294
    Last Post: 08-24-2022 08:40 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] Fast array formula for running sum of a column for consecutive identical values in another

    Started by zadig_44‎, 07-12-2022 12:37 PM
    array formula, performance
    • 432
    Last Post: 07-22-2022 07:38 AM
    by zadig_44  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] Google Sheets: How to combine CountIfs and an array formula

    Started by e-ads‎, 05-17-2022 12:13 PM
    array formula, countifs, google sheet formula 1 Attachment(s)
    • 1,009
    Last Post: 02-24-2023 05:59 AM
    by e-ads  Go to last post

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

  12. Formulas become array when file downloaded

    Started by rallatt‎, 11-10-2021 12:14 PM
    array formula
    • 359
    Last Post: 11-10-2021 02:35 PM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Frequency Function Issue

    Started by Shallabee‎, 11-04-2021 05:59 AM
    array formula, dynamic range, frequency, structured reference
    • 347
    Last Post: 11-04-2021 06:06 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Array Formula Help

    Started by Niproman‎, 08-13-2021 05:43 PM
    array formula 3 Attachment(s)
    • 360
    Last Post: 08-14-2021 02:16 AM
    by etaf  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] References that are absolute within a group but that change from one group to another

    Started by ancog‎, 07-07-2021 11:21 AM
    absolute cell reference, array formula, group, table 2 Attachment(s)
    • 514
    Last Post: 07-09-2021 04:28 PM
    by ancog  Go to last post

    Forum:
    Excel Formulas & Functions

  16. Run Time Error 1004- Long Array Formula in VBA (How to split the VBA code)

    Started by Shamis12‎, 06-27-2021 03:33 AM
    array formula, index and match, vba & excel
    • 595
    Last Post: 06-27-2021 12:13 PM
    by Vraag en antwoord  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  17. Combining two formulas

    Started by RSNGGG‎, 06-21-2021 02:49 AM
    array formula, countifs, index, match
    • 386
    Last Post: 06-21-2021 03:56 AM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  18. Array In Vertically Merged Cells

    Started by Apokolipse‎, 06-01-2021 02:42 PM
    array formula, merged cells 1 Attachment(s)
    • 404
    Last Post: 06-01-2021 04:29 PM
    by 6StringJazzer  Go to last post

    Forum:
    Excel General

  19. [SOLVED] Find cumulative totals in column B between two NA values given in column A.

    Started by sabha‎, 05-30-2021 11:43 AM
    array formula, excel, excel & formula, formula 2 Attachment(s)
    • 422
    Last Post: 05-30-2021 12:24 PM
    by sabha  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Automatically update formula when a new row of data is added

    Started by hersh.patel86@gmail.‎, 04-19-2021 12:50 PM
    array formula, google sheets, google sheets links 1 Attachment(s)
    • 527
    Last Post: 04-20-2021 07:41 AM
    by hersh.patel86@gmail.  Go to last post

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

  21. [SOLVED] Auto populate values from raw data using multiple criteria

    Started by sabha‎, 03-26-2021 02:52 PM
    array, array formula, excel, excel 2007, excel formula 8 Attachment(s)
    • 810
    Last Post: 03-30-2021 01:28 PM
    by sabha  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] Comparison of array for Matching and non matching values

    Started by chandramouliarun‎, 03-25-2021 04:04 AM
    array, array conditional, array formula 4 Attachment(s)
    • 506
    Last Post: 03-25-2021 06:48 AM
    by chandramouliarun  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Array formula that return City with two condition and have no Sales

    Started by ieumts‎, 02-05-2021 04:02 PM
    array formula 4 Attachment(s)
    • 394
    Last Post: 02-07-2021 10:45 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  24. Formula for conditional distinct count on very large ranges

    Started by William_M‎, 11-22-2020 08:20 AM
    array formula, distinct count 2 Attachment(s)
    • 421
    Last Post: 11-22-2020 08:58 AM
    by BMV  Go to last post

    Forum:
    Excel General

  25. Using Wildcards with SUMIFS and an ARRAY

    Started by zlati17‎, 11-18-2020 10:57 AM
    array formula, sumifs, wildcards
    • 699
    Last Post: 11-18-2020 11:15 AM
    by rorya  Go to last post

    Forum:
    Excel General

  26. [SOLVED] Array Function - multiple criteria

    Started by boyspalm‎, 11-11-2020 05:07 PM
    array - multiple strings, array formula 1 Attachment(s)
    • 454
    Last Post: 11-12-2020 01:57 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  27. Inventory log: Add or Subtract values from another sheet

    Started by LennyG‎, 09-14-2020 12:31 PM
    array - multiple strings, array formula, vba, vba & excel 1 Attachment(s)
    • 501
    Last Post: 09-21-2020 09:56 AM
    by LennyG  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  28. [SOLVED] Array Formula with Conditions Not Working

    Started by Merf‎, 07-30-2020 10:34 PM
    array formula
    • 647
    Last Post: 07-31-2020 10:10 AM
    by XLent  Go to last post

    Forum:
    Excel Formulas & Functions

  29. AVERAGEIF Array for multiple variables

    Started by Csterne‎, 07-29-2020 07:39 AM
    array formula, average formula 1 Attachment(s)
    • 429
    Last Post: 07-29-2020 09:01 AM
    by ChemistB  Go to last post

    Forum:
    Excel Formulas & Functions

  30. IFNA - Array formula

    Started by scubadiver007‎, 07-20-2020 04:04 AM
    array formula, ifna()
    • 416
    Last Post: 07-20-2020 06:02 AM
    by scubadiver007  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Excel 2019 HYPERLINK function in array formula fails if both parameters are arrays

    Started by RichHolton‎, 07-07-2020 11:03 AM
    array formula, excel 2019, hyperlink formula, office 365 1 Attachment(s)
    • 772
    Last Post: 07-07-2020 12:26 PM
    by RichHolton  Go to last post

    Forum:
    Excel Formulas & Functions

  32. [SOLVED] Array formula to match value to row and pull row header (multiple occurrences of value)

    Started by lbdavis‎, 06-18-2020 10:55 AM
    array formula 2 Attachment(s)
    • 465
    Last Post: 06-18-2020 01:34 PM
    by CK76  Go to last post

    Forum:
    Excel Formulas & Functions

  33. Problem with ISODD and other function when used in array formulas.

    Started by pfigueiredo‎, 06-17-2020 07:30 AM
    array formula, array formula error 3 Attachment(s)
    • 940
    Last Post: 06-18-2020 02:36 AM
    by pfigueiredo  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Array formula data limits

    Started by Eelman‎, 06-07-2020 07:26 PM
    array, array formula, sumproduct array
    • 444
    Last Post: 06-07-2020 09:13 PM
    by bebo021999  Go to last post

    Forum:
    Excel Formulas & Functions

  35. Array formula with multiple match criteria to count exact phrase within a string of text

    Started by LDHall‎, 04-21-2020 05:23 AM
    array formula, formala, match arrays 3 Attachment(s)
    • 473
    Last Post: 04-21-2020 07:32 AM
    by LDHall  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 263
Page 1 of 8 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1