Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Finding close text matches from a list of values 1

      • Mowgli
    3. Replies
      1
      Views
      511
      1

    4. bosco_yip

    2. Return true if a cell contains any three or more consecutive letters 1

      • jpsaini
    3. Replies
      1
      Views
      415
      1

    4. rory

    2. Excel 365 Xlookup Duplicate values 1

      • BoetieBenz
    3. Replies
      1
      Views
      238
      1

    4. royUK

    2. Conditional Formatting 1

      • laraus2022
    3. Replies
      1
      Views
      627
      1

    4. royUK

    2. Formula for Conditional Formatting Based on the cell to the left 1

      • JJeffery99
    3. Replies
      1
      Views
      436
      1

    4. mfroelaz

    2. Nesting formulas 1

      • kooala
    3. Replies
      1
      Views
      281
      1

    4. royUK

    2. Using Countif to calculate totals from another excel tab 1

      • Xani
      • Xani
    3. Replies
      1
      Views
      275
      1

    4. alansidman

    2. Conditional fomatting rule to only apply if two conditions are met. 1

      • Shezmo1
    3. Replies
      1
      Views
      418
      1

    4. royUK

    2. use xlookup function to retrieve value within another xlookup function 1

      • paulbiddis
    3. Replies
      1
      Views
      398
      1

    4. royUK

    2. MAX date with conditions 1

      • ppcash
    3. Replies
      1
      Views
      481
      1

    4. Estevaoba

    2. Decimal in manual calculator but no decimal in Excel 1

      • newgirl
    3. Replies
      1
      Views
      349
      1

    4. rory

    2. Vlook up an amount for an item and deduct it from that row - issue is that items repeat multiple times - need to take into account the amount already deducted from the same item in the above rows 1

      • jpetraityte
    3. Replies
      1
      Views
      429
      1

    4. Estevaoba

    2. Excel formula or VBA code for extracting external file links 1

      • dkool
    3. Replies
      1
      Views
      295
      1

    4. royUK

    2. Dynamic Formula To Lookup Most Recent Data On Or Before Given Data Based On Multiple Criteria 1

      • EnginerdUNH
    3. Replies
      1
      Views
      448
      1

    4. EnginerdUNH

    2. Extract Year part from Date and convert to text 1

      • tomchy
    3. Replies
      1
      Views
      406
      1

    4. rollis13

    2. Rank Issue using value from Pivot Table 1

      • Box Jockey
    3. Replies
      1
      Views
      300
      1

    4. royUK

    2. Form in Excel 1

      • Ankit4680
    3. Replies
      1
      Views
      340
      1

    4. royUK

    2. Returning Data if Two matches are made 1

      • chelly
    3. Replies
      1
      Views
      435
      1

    4. chelly

    2. Mapping vintages to sales and different rates 1

      • kooala
    3. Replies
      1
      Views
      359
      1

    4. kooala

    2. Populate cells with data related to a specific cell 1

    3. Replies
      1
      Views
      314
      1

    4. royUK

Label

Display Options