For the best help attach a sample workbook to your post
New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

Search:

Tag: arrays

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Issues with creating an array of hyperlinks

Started by paul_cranberry‎, 03-13-2025 11:27 AM
- 3
- 395
Last Post By:

Last Post: 03-14-2025 02:00 PM

by windknife

Forum:
Excel General
[SOLVED] Excel efficiency - arrays instead of formulas - how to HSTACK text?

Started by seh0872‎, 02-09-2025 01:29 PM
- 4
- 266
Last Post By:

Last Post: 02-11-2025 02:37 PM

by TMS

Forum:
Excel Formulas & Functions
[SOLVED] Getting around XLOOKUP "if not found" starting at top when built into array

Started by seh0872‎, 02-08-2025 09:22 PM
- 6
- 377
Last Post By:

Last Post: 02-11-2025 02:25 PM

by seh0872

Forum:
Excel Formulas & Functions
[SOLVED] Using INDEX to create a Dynamic Drop Down List

Started by waytoskinny‎, 07-10-2024 03:45 PM
- 17
- 591
Last Post By:

Last Post: 07-12-2024 09:04 AM

by TMS

Forum:
Excel Formulas & Functions
[SOLVED] Excel countif with an array

Started by cturner62‎, 05-16-2024 04:25 PM
- 9
- 337
Last Post By:

Last Post: 05-17-2024 12:04 PM

by AliGW

Forum:
Excel Formulas & Functions
[SOLVED] Creation of multiple rows to split a month into days and modifying column values

Started by ravindranj‎, 06-07-2023 07:29 PM
- 2
- 305
Last Post By:

Last Post: 06-08-2023 08:37 AM

by ravindranj

Forum:
Excel Programming / VBA / Macros
[SOLVED] Array returning only first item

Started by the tax man‎, 05-06-2023 12:10 PM
- 11
- 645
Last Post By:

Last Post: 05-07-2023 09:58 AM

by Sintek

Forum:
Excel Programming / VBA / Macros
Can someone please help me speed up my macro?

Started by AmatuerNoob‎, 03-29-2023 07:43 AM
- 3
- 412
Last Post By:

Last Post: 03-31-2023 12:46 PM

by johnnyL

Forum:
Excel Programming / VBA / Macros
Matching the values of two tables

Started by aliara‎, 12-09-2022 06:13 AM
- 4
- 434
Last Post By:

Last Post: 12-09-2022 02:13 PM

by TMS

Forum:
Excel Programming / VBA / Macros
Spill range with COUNTIFS of unique rows

Started by Marbleking‎, 09-13-2022 11:27 AM
- 7
- 2,724
Last Post By:

Last Post: 09-15-2022 02:48 AM

by Marbleking

Forum:
Excel Formulas & Functions
Compare Headers in Array - Display Missing Header - Ask and Rename

Started by Kehfera‎, 09-09-2022 07:34 PM
- 10
- 596
Last Post By:

Last Post: 09-13-2022 04:42 PM

by Kehfera

Forum:
Excel Programming / VBA / Macros
[SOLVED] Match and Countif within Array

Started by SyracuseWolvrine‎, 05-16-2022 02:48 PM
- 17
- 854
Last Post By:

Last Post: 06-07-2022 02:46 PM

by SyracuseWolvrine

Forum:
Excel Programming / VBA / Macros
[SOLVED] Load a string or array using vba by looping through multiple Sheets

Started by Kelly mort‎, 05-25-2021 03:05 PM
- 27
- 1,094
Last Post By:

Last Post: 07-23-2021 02:20 PM

by Kelly mort

Forum:
Excel Programming / VBA / Macros
Index Match To Return Transposed Array Values

Started by larryg003‎, 05-17-2021 09:57 AM
- 6
- 656
Last Post By:

Last Post: 05-17-2021 03:07 PM

by Bo_Ry

Forum:
Excel Formulas & Functions
Using variable in Application.Index

Started by Mayday Mayday‎, 04-29-2021 02:19 PM
- 3
- 431
Last Post By:

Last Post: 04-29-2021 02:58 PM

by Fluff13

Forum:
Excel Programming / VBA / Macros
[SOLVED] How to create a new array with rows that have same values in different arrays

Started by JOAO12‎, 04-23-2021 10:34 PM
- 45
- 1,761
Last Post By:

Last Post: 05-04-2021 09:06 PM

by JOAO12

Forum:
Excel Programming / VBA / Macros
use an array or vector for my graph data series in vb

Started by peterhw‎, 04-16-2021 09:21 AM
- 0
- 403
Last Post By:

Last Post: 04-16-2021 09:21 AM

by peterhw

Forum:
Excel Programming / VBA / Macros
Multiply array element values from 2 separate arrays

Started by olsonkyle12‎, 01-20-2021 05:02 PM
- 1
- 507
Last Post By:

Last Post: 01-20-2021 05:05 PM

by AliGW

Forum:
Excel Programming / VBA / Macros
[SOLVED] 2 ways array with multiple returns

Started by Vibov‎, 11-24-2020 07:38 AM
- 1
- 514
Last Post By:

Last Post: 11-24-2020 09:34 AM

by Pepe Le Mokko

Forum:
Excel General
Trying to save rows to an array to fill a listbox

Started by imaquila‎, 11-14-2020 02:24 PM
- 15
- 831
Last Post By:

Last Post: 11-19-2020 11:58 AM

by imaquila

Forum:
Excel Programming / VBA / Macros
[SOLVED] Organise sections into Table

Started by Un-Do Re-Do‎, 09-09-2020 05:32 AM
- 3
- 357
Last Post By:

Last Post: 09-09-2020 10:59 AM

by Un-Do Re-Do

Forum:
Excel Programming / VBA / Macros
Arrays in VBA errors

Started by RusGrad‎, 06-10-2020 03:23 PM
- 2
- 474
Last Post By:

Last Post: 06-10-2020 05:58 PM

by AliGW

Forum:
Excel Programming / VBA / Macros
[SOLVED] Querying Large Series of Arrays And Displaying Unique Values in Arrays [Hard Index Match?]

Started by larryg003‎, 05-28-2020 01:13 PM
- 3
- 717
Last Post By:

Last Post: 05-28-2020 04:52 PM

by AliGW

Forum:
Excel Formulas & Functions
Save lots of input data from Userform - Help with arrays *novice*

Started by Zacemon‎, 05-06-2020 12:37 PM
- 1
- 643
Last Post By:

Last Post: 05-06-2020 01:01 PM

by mehmetcik

Forum:
Excel Programming / VBA / Macros
Using MMult output in equation

Started by RME26‎, 03-05-2020 10:52 AM
- 4
- 452
Last Post By:

Last Post: 03-05-2020 02:26 PM

by RME26

Forum:
Excel Programming / VBA / Macros
Speeding up vba code using arrays

Started by david.irish‎, 02-24-2020 11:17 AM
- 1
- 416
Last Post By:

Last Post: 02-28-2020 02:27 AM

by david.irish

Forum:
Excel Programming / VBA / Macros
Transferring a range to a variant array

Started by William_Mejia‎, 07-03-2019 06:06 PM
- 4
- 569
Last Post By:

Last Post: 07-04-2019 10:10 AM

by alansidman

Forum:
Excel Programming / VBA / Macros
Match and Merge cell values

Started by likelife‎, 07-03-2019 03:13 AM
- 18
- 648
Last Post By:

Last Post: 07-03-2019 04:55 AM

by AliGW

Forum:
Excel Formulas & Functions
How to optimise counting in loops

Started by Geode7‎, 05-14-2019 03:39 AM
- 8
- 727
Last Post By:

Last Post: 05-15-2019 04:12 AM

by Geode7

Forum:
Excel Programming / VBA / Macros
Index match multiple arrays

Started by lukeareed‎, 04-26-2019 01:45 PM
- 1
- 2,931
Last Post By:

Last Post: 04-27-2019 07:25 AM

by José Augusto

Forum:
Excel General
Exclude Blank Cells from Mode Array

Started by MSWAL‎, 03-25-2019 03:22 PM
- 4
- 1,714
Last Post By:

Last Post: 03-25-2019 04:48 PM

by MSWAL

Forum:
Excel General
match / manipulate arrays then paste back onto sheet

Started by esbencito‎, 03-05-2019 01:11 AM
- 2
- 554
Last Post By:

Last Post: 03-08-2019 05:30 AM

by esbencito

Forum:
Excel Programming / VBA / Macros
Help with dynamic arrays with multiple criteria

Started by giv12346a‎, 02-11-2019 08:35 AM
- 1
- 449
Last Post By:

Last Post: 02-12-2019 05:11 AM

by giv12346a

Forum:
Excel Programming / VBA / Macros
[SOLVED] Excel 2013: Need solution using VLOOKUP combined with SUMIFS or INDIRECT/MATCH

Started by rarascon‎, 12-14-2018 12:26 PM
- 6
- 687
Last Post By:

Last Post: 12-14-2018 08:28 PM

by Pete_UK

Forum:
Excel Formulas & Functions
[SOLVED] Read data in one table, then distribute and sum it in another table

Started by PWM‎, 09-19-2018 05:23 PM
- 6
- 862
Last Post By:

Last Post: 10-01-2018 01:31 AM

by AliGW

Forum:
Excel General

Results 1 to 35 of 167

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Issues with creating an array of hyperlinks

[SOLVED] Excel efficiency - arrays instead of formulas - how to HSTACK text?

[SOLVED] Getting around XLOOKUP "if not found" starting at top when built into array

[SOLVED] Using INDEX to create a Dynamic Drop Down List

[SOLVED] Excel countif with an array

[SOLVED] Creation of multiple rows to split a month into days and modifying column values

[SOLVED] Array returning only first item

[SOLVED] Match and Countif within Array

[SOLVED] Load a string or array using vba by looping through multiple Sheets

[SOLVED] How to create a new array with rows that have same values in different arrays

[SOLVED] 2 ways array with multiple returns

[SOLVED] Organise sections into Table

[SOLVED] Querying Large Series of Arrays And Displaying Unique Values in Arrays [Hard Index Match?]

[SOLVED] Excel 2013: Need solution using VLOOKUP combined with SUMIFS or INDIRECT/MATCH

[SOLVED] Read data in one table, then distribute and sum it in another table