Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. How to Match data side by side and auto numbering in Microsoft Excel 1

      • cliffe
    2. Replies
      1
      Views
      364
      1
    3. AliGW

    1. vLookup not working. 2

      • Clayhead22
    2. Replies
      2
      Views
      525
      2
    3. JDmacromanZ

    1. Map text to numeric rankings 2

      • clariinc
    2. Replies
      2
      Views
      694
      2
    3. clariinc

    1. Blank cells replace zeros 30

      • CJamesUK
    2. Replies
      30
      Views
      2.7k
      30
    3. royUK

    1. Orders created in rolling 7 days period 9

      • cire_d
    2. Replies
      9
      Views
      1.1k
      9
    3. royUK

    1. No idea how to get this done, probably with an INDEX function 2

      • cintha
    2. Replies
      2
      Views
      257
      2
    3. cintha

    1. Sum numbers in a single cell 7

      • chxjett
    2. Replies
      7
      Views
      2.2k
      7
    3. XOR LX

    1. adding dynamic range to get rid of blanks 1

      • chubbychub
    2. Replies
      1
      Views
      1k
      1
    3. pike

    1. Dynamic Print Area for a Form in Excel 1

      • chrisp1974
    2. Replies
      1
      Views
      414
      1
    3. Carim

    1. VLOOKUP and reference another cell for the LookupTable"NAME" 5

      • chrismoore989
    2. Replies
      5
      Views
      685
      5
    3. NBVC

    1. Overlap by employee and date

      • chrisjdb
    2. Replies
      0
      Views
      154
    1. Remove Rows Based on Partial Duplicates For Email Marketing Like Mail Chimp 2

      • ChrisGator
    2. Replies
      2
      Views
      634
      2
    3. ChrisGator

    1. OFFSET combined with COUNTA 3

      • Chrischris
    2. Replies
      3
      Views
      834
      3
    3. bosco_yip

    1. Need help with  VLOOKUP by WEEKNUM 11

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

    1. Dropdown List Issues 1

      • chimelle69
    2. Replies
      1
      Views
      446
      1
    3. chimelle69

    1. Reverse Lookup Function 1

      • Chetu1980
    2. Replies
      1
      Views
      260
      1
    3. AliGW

    1. Search bar using FILTER formula 1

      • chester1993
    2. Replies
      1
      Views
      455
      1
    3. Fluff13

    1. Returning Data if Two matches are made 1

      • chelly
    2. Replies
      1
      Views
      291
      1
    3. chelly

    1. Petty Cash Template - Keep cell blank until data entered 3

      • Chaffrin
    2. Replies
      3
      Views
      2.1k
      3
    3. royUK

    1. Returning the last row of text in a cell, minus the first few words 4

      • chad71
    2. Replies
      4
      Views
      516
      4
    3. Carim

Display Options