Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Collate data from last x days based on todays date 7

      • DezB
    3. Replies
      7
      Views
      590
      7

    4. Pecoflyer

    2. IF Functions and tolerances. 3

      • Shezmo1
    3. Replies
      3
      Views
      440
      3

    4. gijsmo

    2. color rows with almost same amount which appear more than twice with CF 6

      • RAJESH SHAH
    3. Replies
      6
      Views
      1.1k
      6

    4. RAJESH SHAH

    2. Gathering name of products which have a same discount percentage 10

      • Q2Be
      • Q2Be
    3. Replies
      10
      Views
      1.1k
      10

    4. alansidman

    2. Creating customer frequency report 6

      • JamJ
      • JamJ
    3. Replies
      6
      Views
      408
      6

    4. JamJ

    2. Subtraction With Catagories 1

      • jgaffney86
    3. Replies
      1
      Views
      339
      1

    4. KjBox

    2. Check Row for data in column and return value and heading for each column containing a value 2

      • Excel Noob
    3. Replies
      2
      Views
      624
      2

    4. Excel Noob

    2. Adding contents of cells based on month and location 9

      • DezB
      • DezB
    3. Replies
      9
      Views
      570
      9

    4. mrgramm

    2. Needing help with formula to auto move text from one cell to another 2

      • Jingles3X
    3. Replies
      2
      Views
      296
      2

    4. KjBox

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

      • JJeffery99
    3. Replies
      1
      Views
      469
      1

    4. mfroelaz

    2. SUM with OFFSET | Fix #REF if Starting Date isn't 1st of Month 4

      • ruppk825
    3. Replies
      4
      Views
      261
      4

    4. Pecoflyer

    2. Is it possible to copy multiple but separate formulae worksheet lines at the same time, between different worksheets? 6

      • NormanW
    3. Replies
      6
      Views
      1k
      6

    4. NormanW

    2. Retrieving Table Header for a Value 1

      • KnowNoVba
    3. Replies
      1
      Views
      229
      1

    4. Pecoflyer

    2. Excel Formula Help 3

      • tdm99
    3. Replies
      3
      Views
      252
      3

    4. alansidman

    2. Conditional Weighted Averages using SUMPROD and IF Statements? 3

      • ruppk825
    3. Replies
      3
      Views
      441
      3

    4. Pecoflyer

    2. starting a formula from the next cell on from the previous formula 1

      • DezB
      • DezB
    3. Replies
      1
      Views
      388
      1

    4. GlennUK

    2. Conditional formatting/coloring depending on values of 2 different cells 2

      • BlueOcean2023
    3. Replies
      2
      Views
      389
      2

    4. AliGW

    2. Formula to display numbers only 8

      • Adel Althahbah
    3. Replies
      8
      Views
      466
      8

    4. alansidman

    2. average time between multiple dates 6

      • Billyrj
    3. Replies
      6
      Views
      389
      6

    4. Billyrj

    2. Rolling total based on cell value 1

      • Mirinjawbro
    3. Replies
      1
      Views
      397
      1

    4. Pecoflyer

Label

Display Options