Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Find adj. cells with specific text strings. Return a text string based on findings. 1

      • XJmikeT
    2. Replies
      1
      Views
      398
      1
    3. S M C

    1. Variable Cell Reference based on Path 9

      • xlbrian
    2. Replies
      9
      Views
      1k
      9
    3. Carim

    1. Unique (text) value for Randbetween 4

      • XXX7
      • XXX7
    2. Replies
      4
      Views
      622
      4
    3. KjBox

    1. Search Cell for Specific Characters 3

      • Yeppy12
    2. Replies
      3
      Views
      568
      3
    3. Yeppy12

    1. How do I average multiple columns (ignoring zeros and blank cells)? 1

      • yeto
    2. Replies
      1
      Views
      546
      1
    3. Carim

    1. Using a value from a cell inside a formula 8

      • yogeshtalks
    2. Replies
      8
      Views
      1.8k
      8
    3. NBVC

    1. extract data to another sheet with multiple conditions? 7

      • Zak2021
    2. Replies
      7
      Views
      819
      7
    3. Zak2021

    1. Nested array formula for a SUMPRODUCT operation 3

      • Zapillo
    2. Replies
      3
      Views
      819
      3
    3. NBVC

    1. Return column header from first cell from consecutive cells below a threshold 6

      • zara007
    2. Replies
      6
      Views
      1.2k
      6
    3. zara007

    1. Concatenate visible cells, remove duplicates 1

      • Zarfot
    2. Replies
      1
      Views
      658
      1
    3. Zarfot

    1. Calculate amount by looking up matching currency and rate of exchange 6

      • zdjbel
    2. Replies
      6
      Views
      722
      6
    3. zdjbel

    1. If cell is not blank calculate, else calculate another cell 3

      • zdjbel
    2. Replies
      3
      Views
      557
      3
    3. Carim

    1. Datevalue Problems 1

      • zeninc
    2. Replies
      1
      Views
      465
      1
    3. Ger Plante

    1. Split a lengthy paragraph into maximum 50 character lines with whole words 3

      • zerachiel76
    2. Replies
      3
      Views
      494
      3
    3. pike

    1. Need help in Excel

      • zey67
    2. Replies
      0
      Views
      160
    1. multipule sumproduct formula errors 7

      • Zippher
    2. Replies
      7
      Views
      576
      7
    3. Zippher

    1. comparing levels 2

      • zohar
    2. Replies
      2
      Views
      349
      2
    3. zohar

    1. calculating time 5

      • zohar
    2. Replies
      5
      Views
      610
      5
    3. zohar

    1. to Eliminate row needed for gapup and reoccurance function and data 4

      • zohar
    2. Replies
      4
      Views
      685
      4
    3. zohar

    1. Formatting problem

      • zohar
    2. Replies
      0
      Views
      197

Display Options