Search:

Tag: index function

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Row-based lookup for zip codes forces reset at change of county name

    Started by Rex411‎, 08-05-2022 11:27 AM
    index function, one to many lookup, small function, zip code 1 Attachment(s)
    • 319
    Last Post: 08-05-2022 01:14 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Calculate the Date of an Item Based on the Date of a Similar Item in the Previous Month

    Started by Tegglet‎, 02-27-2021 12:19 PM
    eomonth function, index function, match function, text function 5 Attachment(s)
    • 1,416
    Last Post: 10-02-2021 10:23 AM
    by 6StringJazzer  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  3. [SOLVED] Using vlookup sort one column into multiple columns

    Started by ElectriKexBlue‎, 11-02-2018 09:16 AM
    if function, index function, match function, noob, vlookup function 2 Attachment(s)
    • 676
    Last Post: 11-02-2018 05:32 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  4. Trying to find column value for a table given row and table value

    Started by Master Chief‎, 02-02-2018 12:15 AM
    hlookup function, if functions, index function, match function 7 Attachment(s)
    • 910
    Last Post: 02-03-2018 01:26 AM
    by TFiske  Go to last post

    Forum:
    Excel Formulas & Functions

  5. Grabbing data from table

    Started by EmilyJoell‎, 11-18-2017 07:33 AM
    excel, index function, premier league, scores 2 Attachment(s)
    • 712
    Last Post: 11-18-2017 10:02 AM
    by sandy666  Go to last post

    Forum:
    Excel General

  6. Index Match Large & Duplicates

    Started by lucky.vjn‎, 11-14-2017 06:14 PM
    duplicates in column, index function, large function, match function
    • 7,597
    Last Post: 05-30-2018 05:30 AM
    by mrsak87  Go to last post

    Forum:
    Excel Formulas & Functions

  7. INDEX() doesn't work with MID() and CELL() to list names of sheets

    Started by Vitalite‎, 06-23-2017 06:31 AM
    index function, mid function 1 Attachment(s)
    • 805
    Last Post: 06-26-2017 04:00 AM
    by Vitalite  Go to last post

    Forum:
    Excel Formulas & Functions

  8. Distinct List & Matching

    Started by TRUCKING123‎, 11-11-2016 01:37 PM
    distinct list, formula and functions, formula assistance, index function, match cell values 3 Attachment(s)
    • 681
    Last Post: 11-11-2016 02:23 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  9. Transpose column and skip two rows

    Started by jrmichal‎, 07-11-2016 08:38 PM
    excel formulas, index function, indirect function 2 Attachment(s)
    • 772
    Last Post: 07-11-2016 09:25 PM
    by jrmichal  Go to last post

    Forum:
    Excel Formulas & Functions

  10. How to display a most frequent word, based on certain criteria

    Started by JoeyPeeps‎, 01-05-2016 01:40 PM
    criteria ranges, if function excel 2010, index function, mode function 2 Attachment(s)
    • 711
    Last Post: 01-05-2016 02:24 PM
    by zbor  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] Extracting data dynamically from one sheet to another

    Started by EC3‎, 08-25-2014 04:14 AM
    index function, row function 2 Attachment(s)
    • 930
    Last Post: 08-25-2014 04:43 PM
    by EC3  Go to last post

    Forum:
    Excel General

  12. [SOLVED] Copy consecutive cells to non-consecutive cells

    Started by EC3‎, 08-11-2014 05:31 PM
    index function, offset function, row calcualtion 1 Attachment(s)
    • 1,753
    Last Post: 08-11-2014 07:49 PM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Look up date & rank the corresponding value

    Started by VBAhelp3456‎, 03-30-2014 10:22 PM
    excel function, index function, match function 1 Attachment(s)
    • 664
    Last Post: 03-31-2014 05:05 AM
    by ratcat  Go to last post

    Forum:
    Excel Formulas & Functions

  14. I have a sales log that tracks vehicle type (cars, trucks) and inventory type (new,used).

    Started by rnhutsko‎, 07-06-2013 12:59 PM
    dynamic, incrementing cell, index function
    • 768
    Last Post: 07-06-2013 12:59 PM
    by rnhutsko  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] Vlookup and match functions

    Started by rmachbitz‎, 06-20-2013 09:49 PM
    counters, index function, match function, vlookup function 3 Attachment(s)
    • 1,532
    Last Post: 06-22-2013 05:12 AM
    by dilipandey  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  16. [SOLVED] Need help: My function results in #VALUE error when "Left" funtion is used.

    Started by kdearing24‎, 03-05-2013 05:31 PM
    #value, index function, left function, match function, vba function
    • 679
    Last Post: 03-05-2013 05:52 PM
    by kdearing24  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  17. Return Unique Values in List Using INDIRECT, MATCH and INDEX?

    Started by chrisucla12‎, 02-02-2013 04:49 PM
    dependent list, index function, indirect, match 1 Attachment(s)
    • 2,917
    Last Post: 02-02-2013 05:24 PM
    by chrisucla12  Go to last post

    Forum:
    Excel General

  18. [SOLVED] Match multiple columns TODAY()+1 problem

    Started by nivoe‎, 10-11-2012 09:18 AM
    cells, conditional formatting, index function, match function, multiple columns
    • 659
    Last Post: 10-11-2012 10:10 AM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

  19. [SOLVED] Formula for taking Info from same row dif Columns to make a list

    Started by marcoantonio4311‎, 09-28-2012 11:49 AM
    formula building, index function 1 Attachment(s)
    • 705
    Last Post: 09-29-2012 03:41 PM
    by marcoantonio4311  Go to last post

    Forum:
    Excel General

  20. Formula to Calculate Number of Appointments remaining within a period of time!?!?!

    Started by WaylettChris‎, 09-06-2012 01:19 PM
    appointments, calculator, index function, nested if and functions 10 Attachment(s)
    • 9,172
    Last Post: 11-14-2012 09:39 AM
    by WaylettChris  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] lookup date within date range grid to return fiscal month value

    Started by tigerseye001‎, 08-30-2012 01:24 PM
    index formula, index function, vlookup all, vlookup excel 10 1 Attachment(s)
    • 1,838
    Last Post: 09-10-2012 02:27 PM
    by Tom Collins  Go to last post

    Forum:
    Excel Formulas & Functions

  22. Need to modify macro to split into separate spreadsheets and to update formula at top

    Started by DLSmith‎, 07-13-2012 06:18 PM
    index function, macro, split 1 Attachment(s)
    • 681
    Last Post: 07-13-2012 06:18 PM
    by DLSmith  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  23. [SOLVED] Index, Large, Match functions

    Started by Toddmike‎, 07-04-2012 01:26 PM
    index function, large function, match function 1 Attachment(s)
    • 1,196
    Last Post: 07-04-2012 04:46 PM
    by dilipandey  Go to last post

    Forum:
    Excel General

  24. [SOLVED] Excel 2007 : Index Function problem

    Started by kalles‎, 05-29-2012 02:36 AM
    index function 1 Attachment(s)
    • 2,121
    Last Post: 05-29-2012 11:21 AM
    by Cutter  Go to last post

    Forum:
    Excel General

  25. index and match help! how to set values so that excel knows it's less than/more than?

    Started by Heerah‎, 05-26-2012 12:16 AM
    function, index function, less than, match, number limit
    • 1,076
    Last Post: 05-26-2012 02:38 AM
    by dilipandey  Go to last post

    Forum:
    Excel Programming / VBA / Macros

Results 1 to 25 of 25

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1