Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Copy data from selected blocks of cells dependent of the month in a cell 12

      • DezB
    2. Replies
      12
      Views
      897
      12
    3. DezB

    1. Match relevant data again 12

      • bob22
    2. Replies
      12
      Views
      1.2k
      12
    3. bob22

    1. INDEX MATCH with multiple lookup_arrays/references 12

      • B.W.B.
    2. Replies
      12
      Views
      2k
      12
    3. B.W.B.

    1. Last 5 games scoring average 11

      • showtimesaints
    2. Replies
      11
      Views
      500
      11
    3. royUK

    1. Last non-empty cell in the column based on three header rows that are criteria 11

      • rehan kazi
    2. Replies
      11
      Views
      414
      11
    3. rehan kazi

    1. Average Data Between Certain Months 11

      • palchy
    2. Replies
      11
      Views
      450
      11
    3. palchy

    1. Need any formula or solution if 3 numbers match in a single cell 11

      • khuramdon
    2. Replies
      11
      Views
      605
      11
    3. Carim

    1. Cell Value Fill Based on Color 11

      • dan_jordan84
    2. Replies
      11
      Views
      815
      11
    3. Carim

    1. VBA Code Modification 11

      • Excel&VBA
    2. Replies
      11
      Views
      752
      11
    3. royUK

    1. Use last value in a column, increment it by 1 and start a new column with this value. If value>x, then start the count in this column, from 1 11

      • leema
    2. Replies
      11
      Views
      1.1k
      11
    3. Fluff13

    1. formula - if cell contain specific text then return all values in the list 11

      • Gemma86
    2. Replies
      11
      Views
      961
      11
    3. Fluff13

    1. Need HELP with ARRAY Formula 11

      • cs566
    2. Replies
      11
      Views
      1.2k
      11
    3. cs566

    1. YTD using dynamic spilled array 11

      • MatthewHart
    2. Replies
      11
      Views
      1.6k
      11
    3. AliGW

    1. Need help with  VLOOKUP by WEEKNUM 11

      • chobart46
    2. Replies
      11
      Views
      1.4k
      11
    3. Carim

    1. Needing help with matching data in excel 11

      • Roger104
    2. Replies
      11
      Views
      760
      11
    3. Carim

    1. Match Header & a row value to get corresponding value 11

      • kumarsatish
    2. Replies
      11
      Views
      869
      11
    3. Carim

    1. DELETE substring of text between text 11

      • DannyGIS
    2. Replies
      11
      Views
      868
      11
    3. DannyGIS

    1. Need help with a formula/VLook up to pull data from a feed sheet 11

      • t0mrogers
    2. Replies
      11
      Views
      758
      11
    3. t0mrogers

    1. Help From KJBox for formula 11

      • Paulbxx
    2. Replies
      11
      Views
      705
      11
    3. Paulbxx

    1. Index Match based on Year and Month of data 11

      • HestiA
    2. Replies
      11
      Views
      666
      11
    3. Carim

Display Options