index - Search Results - Excel Help Forum

Pivot columns and Extract without PowerQuery

Started by bob112233‎, 04-08-2024 12:10 AM

12

121

Last Post By:: Last Post: 04-08-2024 02:07 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Trying to SPILL a large multi-step formula

Started by CVDom‎, 04-07-2024 06:39 PM

3

107

Last Post By:: Last Post: 04-08-2024 10:46 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] INDEX and MATCH - return value even though not all criteria are met

Started by varbergt‎, 03-25-2024 05:50 AM

5

165

Last Post By:: Last Post: 03-26-2024 03:43 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] INDEX MATCH formula not working as expected

Started by kdestef‎, 03-06-2024 04:03 PM

11

198

Last Post By:: Last Post: 03-11-2024 08:31 PM; by TMS

Forum:
Excel Formulas & Functions

[SOLVED] Need all cell values from a given row based on their column header

Started by mcmcspam‎, 02-23-2024 05:13 PM

index, match, multiple criteria, vlookup

5

292

Last Post By:: Last Post: 02-26-2024 05:02 PM; by mcmcspam

Forum:
Excel Formulas & Functions

[SOLVED] Trying to reference an array within a formula to output corresponding value

Started by CVDom‎, 02-10-2024 04:27 PM

14

307

Last Post By:: Last Post: 02-16-2024 11:05 AM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] Return a date if on that date a value in a column becomes greater than the next column

Started by larsvane‎, 02-08-2024 05:06 AM

5

203

Last Post By:: Last Post: 02-08-2024 08:31 AM; by AliGW

Forum:
Excel Formulas & Functions

Putting Array in Order from largest to smallest and matching names

Started by Hwitt01‎, 02-02-2024 11:22 AM

7

205

Last Post By:: Last Post: 02-05-2024 12:37 PM; by Estevaoba

Forum:
Excel Programming / VBA / Macros

Need Help with Table functions

Started by Siddps‎, 01-24-2024 01:25 PM

charting, frequencies, index, occurrences, table array

4

195

Last Post By:: Last Post: 01-25-2024 06:35 AM; by alansidman

Forum:
Excel Formulas & Functions

[SOLVED] Fill cells based on occurrence of first match vertically, multiple columns

Started by onni‎, 01-14-2024 09:54 AM

2

145

Last Post By:: Last Post: 01-14-2024 10:05 AM; by onni

Forum:
Excel Formulas & Functions

Combine Multiple Arrays/Matrices (Get the SUM) into a one big Array (Matrix)

Started by alte.ianp‎, 01-13-2024 12:14 PM

4

216

Last Post By:: Last Post: 01-15-2024 07:28 AM; by kvsrinivasamurthy

Forum:
Excel Formulas & Functions

[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

10

183

Last Post By:: Last Post: 01-14-2024 02:36 PM; by DJunqueira

Forum:
Excel Formulas & Functions

Power Query Add index number to existing column

Started by Dicken‎, 01-09-2024 10:30 AM

5

432

Last Post By:: Last Post: 01-10-2024 09:31 AM; by Dicken

Forum:
Office 365

[SOLVED] Matching Leave Requests to a Rota

Started by cmarchant97‎, 12-22-2023 03:57 PM

1

151

Last Post By:: Last Post: 12-22-2023 07:30 PM; by Pete_UK

Forum:
Excel Formulas & Functions

[SOLVED] Index and Match with multiple criteria and wild card?

Started by jbaich‎, 12-21-2023 07:15 PM

index, match, multiple criteria, or condition

2

338

Last Post By:: Last Post: 12-22-2023 11:19 AM; by TMS

Forum:
Excel Formulas & Functions

Rota - Return data based on 3 criteria from table

Started by Klaise‎, 12-21-2023 06:35 PM

1

125

Last Post By:: Last Post: 12-21-2023 11:39 PM; by protonLeah

Forum:
Excel Formulas & Functions

Dynamic named range and indirect function

Started by m4rkybob‎, 12-21-2023 01:50 PM

1

170

Last Post By:: Last Post: 12-21-2023 02:19 PM; by deadlyduck

Forum:
Excel General

INDEX and MATCH not returning proper values

Started by sndameron‎, 12-20-2023 02:16 PM

11

474

Last Post By:: Last Post: 12-20-2023 08:31 PM; by TMS

Forum:
Excel Formulas & Functions

INDEX MATCH with multiple criteria NOT working for me in any circumstance

Started by tylerm259‎, 11-30-2023 11:50 AM

1

272

Last Post By:: Last Post: 11-30-2023 11:50 AM; by AliGW

Forum:
Excel Formulas & Functions

Index Match error

Started by YY1708‎, 10-11-2023 03:45 AM

7

226

Last Post By:: Last Post: 10-11-2023 05:17 AM; by AliGW

Forum:
Excel Formulas & Functions

Help with Formula for COUNTIIFS INDEX MATCH Multiple Criteria Same Column [PART2]

Started by artiststevens‎, 10-09-2023 05:31 AM

2

190

Last Post By:: Last Post: 10-09-2023 05:40 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Additional layer to Index formula

Started by Sorridere‎, 09-24-2023 09:22 AM

index, index and match, index and match and if

8

250

Last Post By:: Last Post: 09-25-2023 04:36 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Help with Formula for COUNTIIFS INDEX MATCH Multiple Criteria Same Column

Started by artiststevens‎, 09-18-2023 05:05 PM

14

584

Last Post By:: Last Post: 10-17-2023 12:15 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] attendance problem and working across multiple worksheets

Started by bob112233‎, 09-14-2023 05:53 AM

attendance data, filter, index, match & index

3

280

Last Post By:: Last Post: 09-14-2023 08:14 AM; by windknife

Forum:
Excel Formulas & Functions

How to get mutilple search results using index and match formulas

Started by slatad‎, 09-06-2023 07:14 AM

drop down list, excel, index, lookup, match

6

364

Last Post By:: Last Post: 09-12-2023 05:49 PM; by JeteMc

Forum:
Excel General

INDEX MATCH Returning Duplicate Results

Started by Freekindasheets‎, 08-25-2023 12:28 PM

11

373

Last Post By:: Last Post: 08-26-2023 08:26 AM; by HansDouwe

Forum:
Excel Formulas & Functions

INDEX/MATCH/SEARCH formula doesn't recognize substrings when searching named range

Started by c_mueller‎, 08-24-2023 01:45 PM

4

325

Last Post By:: Last Post: 08-24-2023 03:35 PM; by c_mueller

Forum:
Excel Formulas & Functions

Return different matches that contains part of the searched text

Started by ngorg‎, 08-11-2023 01:40 PM

6

353

Last Post By:: Last Post: 08-13-2023 02:56 AM; by kvsrinivasamurthy

Forum:
Excel Formulas & Functions

[SOLVED] Find the latest PO number from the same item with INDEX-MATCH & helper column.

Started by Addvocado9‎, 07-26-2023 02:10 AM

5

402

Last Post By:: Last Post: 07-26-2023 04:18 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Power Query , can't use index as positional indicator in grouped data

Started by Dicken‎, 07-20-2023 11:33 AM

index, positional indicator, power query

2

393

Last Post By:: Last Post: 07-21-2023 05:08 AM; by Dicken

Forum:
Office 365

[SOLVED] Find Data from specific range by multiple conditions

Started by rif‎, 07-18-2023 08:26 AM

4

258

Last Post By:: Last Post: 07-18-2023 07:43 PM; by rif

Forum:
Excel Formulas & Functions

Index-Small (Failed to Replicate Example)

Started by DisciplinedBeast‎, 07-03-2023 12:04 PM

9

551

Last Post By:: Last Post: 07-23-2023 06:20 AM; by DisciplinedBeast

Forum:
Excel General

[SOLVED] finding the closest location with inventory

Started by tkoziol‎, 06-27-2023 12:44 AM

distance, index, inventory, match, xlookup

15

411

Last Post By:: Last Post: 06-27-2023 11:31 PM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Mutile criterai accross multiple ranges to return a sum of matching values

Started by 77highland‎, 06-15-2023 07:43 AM

6

273

Last Post By:: Last Post: 06-15-2023 09:37 AM; by AliGW

Forum:
Excel Formulas & Functions

Trouble with INDEX/XLOOKUP

Started by Chavis339‎, 06-14-2023 01:39 PM

formula assistance, help a dummy, index, troubleshooting, xlookup

6

334

Last Post By:: Last Post: 06-21-2023 12:48 PM; by HansDouwe

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.02 seconds.

Pivot columns and Extract without PowerQuery

[SOLVED] Trying to SPILL a large multi-step formula

[SOLVED] INDEX and MATCH - return value even though not all criteria are met

[SOLVED] INDEX MATCH formula not working as expected

[SOLVED] Need all cell values from a given row based on their column header

[SOLVED] Trying to reference an array within a formula to output corresponding value

[SOLVED] Return a date if on that date a value in a column becomes greater than the next column

Putting Array in Order from largest to smallest and matching names

Need Help with Table functions

[SOLVED] Fill cells based on occurrence of first match vertically, multiple columns

Combine Multiple Arrays/Matrices (Get the SUM) into a one big Array (Matrix)

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

Power Query Add index number to existing column

[SOLVED] Matching Leave Requests to a Rota

[SOLVED] Index and Match with multiple criteria and wild card?

Rota - Return data based on 3 criteria from table

Dynamic named range and indirect function

INDEX and MATCH not returning proper values

INDEX MATCH with multiple criteria NOT working for me in any circumstance

Index Match error

Help with Formula for COUNTIIFS INDEX MATCH Multiple Criteria Same Column [PART2]

[SOLVED] Additional layer to Index formula

[SOLVED] Help with Formula for COUNTIIFS INDEX MATCH Multiple Criteria Same Column

[SOLVED] attendance problem and working across multiple worksheets

How to get mutilple search results using index and match formulas

INDEX MATCH Returning Duplicate Results

INDEX/MATCH/SEARCH formula doesn't recognize substrings when searching named range

Return different matches that contains part of the searched text

[SOLVED] Find the latest PO number from the same item with INDEX-MATCH & helper column.

[SOLVED] Power Query , can't use index as positional indicator in grouped data

[SOLVED] Find Data from specific range by multiple conditions

Index-Small (Failed to Replicate Example)

[SOLVED] finding the closest location with inventory

[SOLVED] Mutile criterai accross multiple ranges to return a sum of matching values

Trouble with INDEX/XLOOKUP