Search:

Tag: index & if

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Need to create a matrix that sums the number of paired observations.

    Started by Venturer‎, 09-04-2023 06:15 PM
    excel & if, index & count, index & if 4 Attachment(s)
    • 282
    Last Post: 09-05-2023 05:37 PM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [SOLVED] Formula for INDEX and MATCH salary ranges within Job Catalog

    Started by Sorridere‎, 06-08-2022 10:29 AM
    index & if, index & match, match 1 Attachment(s)
    • 348
    Last Post: 06-08-2022 11:08 AM
    by Sorridere  Go to last post

    Forum:
    Excel Formulas & Functions

  3. Data clean up

    Started by aminsajid‎, 05-30-2022 07:58 AM
    cleanup, filter and copy, formula, index & if 4 Attachment(s)
    • 424
    Last Post: 06-10-2022 11:40 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Find a duplicate, match and equal to different columns

    Started by gotmort‎, 04-27-2022 08:00 AM
    index & if, match 2 Attachment(s)
    • 290
    Last Post: 04-27-2022 09:53 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] Index of terms based on overlapping dates

    Started by lilybickel‎, 05-17-2021 05:46 AM
    chronological, index, index & aggregate, index & if, overlapping dates 4 Attachment(s)
    • 627
    Last Post: 06-29-2021 09:59 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  6. Formula returned value & displayed value are different

    Started by shir02‎, 12-20-2020 07:03 AM
    index, index & if, row 7 Attachment(s)
    • 1,638
    Last Post: 12-23-2020 10:27 PM
    by JeteMc  Go to last post

    Forum:
    Excel General

  7. [SOLVED] Nested function or VBA to create heat map of prices

    Started by Luu4466‎, 11-07-2020 06:25 AM
    absolute value, heat map, index, index & if, nested function 3 Attachment(s)
    • 615
    Last Post: 11-11-2020 09:13 AM
    by Luu4466  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  8. Summing With IF/INDEX/MATCH

    Started by JPSIMMON‎, 10-27-2020 03:46 PM
    index & if, index & match, index and sum, match, sum
    • 447
    Last Post: 10-27-2020 05:22 PM
    by hrlngrv  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] IF, VLOOKUP combination

    Started by LinaVa‎, 07-23-2020 03:53 AM
    index & if, match, vlookup, vlookup & if 2 Attachment(s)
    • 376
    Last Post: 07-23-2020 07:14 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  10. Formula to Match Cells in the Datasheet

    Started by geraldccole‎, 01-18-2020 09:13 AM
    index & if, v lookup
    • 424
    Last Post: 01-20-2020 11:19 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  11. formula for selecting data and then moving on to next appropriate selection

    Started by ginazurmendi‎, 08-12-2017 04:18 AM
    if statement, index & if, loops
    • 511
    Last Post: 08-12-2017 09:37 AM
    by oeldere  Go to last post

    Forum:
    Excel Formulas & Functions

  12. Lookup only Month and Year in full date

    Started by cschulz349‎, 05-04-2017 12:24 PM
    formula, index & if, vlookup 1 Attachment(s)
    • 1,330
    Last Post: 05-04-2017 12:38 PM
    by tim201110  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Match, Index, If function all in one?

    Started by mitch5591‎, 04-25-2017 05:12 PM
    function, index & if, match & indirect
    • 367
    Last Post: 04-25-2017 05:14 PM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Excel Formula Help

    Started by harvw‎, 04-16-2017 12:15 PM
    excel formula help, ifstatements, index & if, index & match, vlookup - match - formula
    • 582
    Last Post: 04-16-2017 01:04 PM
    by harvw  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Counting if a unique identifier corresponds to another unique identifier more than once

    Started by alekos7‎, 02-16-2017 07:12 PM
    count and if, countif and sumif, countifs, index & if
    • 535
    Last Post: 02-16-2017 07:53 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  16. [SOLVED] I need to lookup info on 1 spreadsheet and if criteria is met paste on another spreadsheet

    Started by shina67‎, 01-13-2016 09:18 AM
    index & if, index and match, lookup and, string array 2 Attachment(s)
    • 617
    Last Post: 01-13-2016 04:13 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  17. Excel Index Match Large If

    Started by covanpatten2‎, 01-12-2016 04:01 PM
    countif, index & if, index & match, large 1 Attachment(s)
    • 1,751
    Last Post: 01-12-2016 05:43 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  18. One trafficlight index is depending on 2 cells

    Started by Moenchen‎, 12-29-2015 08:39 AM
    if formula, index & if, kpi 1 Attachment(s)
    • 556
    Last Post: 12-29-2015 10:23 AM
    by Beamernsw  Go to last post

    Forum:
    Excel Formulas & Functions

  19. Mirroring Specific Data on Different Tab

    Started by JPSIMMON‎, 07-29-2015 11:20 PM
    index, index & if, index & match, match and index 1 Attachment(s)
    • 576
    Last Post: 07-30-2015 12:40 AM
    by JPSIMMON  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] INDEX MATCH & LARGE Functions, Multiple Criteria

    Started by skyhawk3485‎, 06-12-2015 09:52 PM
    index & if, index & match, match 2 1 Attachment(s)
    • 26,166
    Last Post: 12-19-2018 09:55 AM
    by DasPXL  Go to last post

    Forum:
    Excel Formulas & Functions

  21. returning table data based on 3 criteria using INDEX and nested IF

    Started by j.mcavoy‎, 06-10-2015 10:44 AM
    index & if 1 Attachment(s)
    • 746
    Last Post: 06-11-2015 06:51 AM
    by Jacc  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] Index and Match to make negative numbers zero

    Started by JPSIMMON‎, 05-12-2015 02:14 PM
    formula and if statement, index & if, index & match, negative numbers
    • 959
    Last Post: 05-12-2015 02:16 PM
    by shg  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Array Match and Return value upon multiple array match criteria

    Started by VegetaOSX‎, 03-04-2015 05:32 PM
    array formulas, index & if, match, multiple array match, multiple ifs criteria 2 Attachment(s)
    • 1,125
    Last Post: 03-05-2015 05:50 AM
    by VegetaOSX  Go to last post

    Forum:
    Excel Formulas & Functions

  24. [SOLVED] Formula to Index if adjacent cell is greater than zero

    Started by ladylissa21‎, 02-19-2015 04:12 PM
    index & if
    • 654
    Last Post: 02-19-2015 06:01 PM
    by Jonmo1  Go to last post

    Forum:
    Excel Formulas & Functions

  25. If formula not working fine

    Started by vjharry‎, 12-10-2014 05:24 AM
    if formulas, index, index & if 3 Attachment(s)
    • 709
    Last Post: 12-10-2014 08:36 AM
    by vjharry  Go to last post

    Forum:
    Excel Formulas & Functions

  26. Index and Match with based on IF then condition?

    Started by aglander‎, 09-08-2014 12:24 PM
    index & if, match 3 Attachment(s)
    • 660
    Last Post: 09-08-2014 05:59 PM
    by aglander  Go to last post

    Forum:
    Excel Formulas & Functions

  27. Pulling Custom Data from Single Source into Multiple Tabs

    Started by cscowmax‎, 07-21-2014 02:07 PM
    index, index & if, macro, macro - reference, vlookup & concatenate 1 Attachment(s)
    • 465
    Last Post: 07-21-2014 02:08 PM
    by arlu1201  Go to last post

    Forum:
    Hello..Introduce yourself

  28. [SOLVED] Importing selected rows from one datasheet to another using conditions

    Started by PJR‎, 04-22-2014 10:14 AM
    condition formula results, condition if, index & if, index and match 3 Attachment(s)
    • 1,468
    Last Post: 04-23-2014 01:49 PM
    by PJR  Go to last post

    Forum:
    Excel General

  29. Conditional INDEX MATCH

    Started by PJR‎, 04-10-2014 11:53 AM
    condional counting, condition, index & if, index and match 2 Attachment(s)
    • 776
    Last Post: 04-10-2014 03:20 PM
    by AlKey  Go to last post

    Forum:
    Excel Formulas & Functions

  30. [SOLVED] INDEX with conditions

    Started by PJR‎, 04-07-2014 01:55 PM
    index & if, index and small, index formula 1 Attachment(s)
    • 725
    Last Post: 04-08-2014 07:33 AM
    by PJR  Go to last post

    Forum:
    Excel Formulas & Functions

  31. [SOLVED] Creating Lists based on values in a table.

    Started by V1gilante‎, 02-16-2014 07:45 PM
    array formula, hlookup, index & if, match, vlookup 1 Attachment(s)
    • 1,056
    Last Post: 02-17-2014 01:30 AM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Using VLOOKUP to Produce an account list

    Started by espmartini‎, 01-18-2014 10:08 PM
    index & if, vlookup 7 Attachment(s)
    • 1,243
    Last Post: 03-05-2014 10:14 AM
    by newdoverman  Go to last post

    Forum:
    Excel Formulas & Functions

  33. How to use INDEX formula to output a cross section of data

    Started by Pope_003‎, 01-08-2014 03:12 AM
    formula, index, index & if 1 Attachment(s)
    • 2,793
    Last Post: 01-09-2014 12:02 AM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] VLookup within a 5 minute timeframe

    Started by beadletd‎, 10-24-2013 04:58 AM
    greater than and equal to, index & if, vlookup and if, vlookup time 1 Attachment(s)
    • 1,801
    Last Post: 10-25-2013 09:04 AM
    by arlu1201  Go to last post

    Forum:
    Excel Formulas & Functions

  35. [SOLVED] Dependent Dropdown List Using Index and Small Won't Return Multiple Values

    Started by ebevis‎, 10-09-2013 09:48 PM
    dependent drop down list, index & if, small 2 Attachment(s)
    • 1,578
    Last Post: 10-23-2013 02:28 AM
    by hemesh  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 44
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1