Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Splitting long text 2

      • Xcasual
    3. Replies
      2
      Views
      94
      2

    4. Xcasual

    2. Display selection based on a value in another cell 5

      • xcel4me
    3. Replies
      5
      Views
      1.7k
      5

    4. xcel4me

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

      • XJmikeT
    3. Replies
      1
      Views
      532
      1

    4. S M C

    2. Variable Cell Reference based on Path 9

      • xlbrian
    3. Replies
      9
      Views
      1.3k
      9

    4. Carim

    2. Multiple returns with 2 criteria from another workbook 29

      • xsmurf
    3. Replies
      29
      Views
      1.7k
      29

    4. xsmurf

    2. Unique (text) value for Randbetween 4

      • XXX7
      • XXX7
    3. Replies
      4
      Views
      777
      4

    4. KjBox

    2. Search Cell for Specific Characters 3

      • Yeppy12
    3. Replies
      3
      Views
      702
      3

    4. Yeppy12

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

      • yeto
    3. Replies
      1
      Views
      873
      1

    4. Carim

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

      • yogeshtalks
    3. Replies
      8
      Views
      2.2k
      8

    4. NBVC

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

      • Zak2021
    3. Replies
      7
      Views
      1.1k
      7

    4. Zak2021

    2. Nested array formula for a SUMPRODUCT operation 3

      • Zapillo
    3. Replies
      3
      Views
      988
      3

    4. NBVC

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

      • zara007
    3. Replies
      6
      Views
      1.7k
      6

    4. zara007

    2. Concatenate visible cells, remove duplicates 1

      • Zarfot
    3. Replies
      1
      Views
      758
      1

    4. Zarfot

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

      • zdjbel
    3. Replies
      6
      Views
      1k
      6

    4. zdjbel

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

      • zdjbel
    3. Replies
      3
      Views
      700
      3

    4. Carim

    2. Datevalue Problems 1

      • zeninc
    3. Replies
      1
      Views
      546
      1

    4. Ger Plante

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

      • zerachiel76
    3. Replies
      3
      Views
      618
      3

    4. pike

    2. Need help in Excel

      • zey67
    3. Replies
      0
      Views
      215

    2. multipule sumproduct formula errors 7

      • Zippher
    3. Replies
      7
      Views
      805
      7

    4. Zippher

    2. comparing levels 2

      • zohar
    3. Replies
      2
      Views
      457
      2

    4. zohar

Label

Display Options