Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Unique names in list of names 3

      • Bootz
    3. Replies
      3
      Views
      245
      3

    4. Carim

    2. Formula to display numbers only 8

      • Adel Althahbah
    3. Replies
      8
      Views
      388
      8

    4. alansidman

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

      • BlueOcean2023
    3. Replies
      2
      Views
      338
      2

    4. AliGW

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

      • ruppk825
    3. Replies
      3
      Views
      398
      3

    4. Pecoflyer

    2. Retrieving Table Header for a Value 1

      • KnowNoVba
    3. Replies
      1
      Views
      189
      1

    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
      981
      6

    4. NormanW

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

      • ruppk825
    3. Replies
      4
      Views
      221
      4

    4. Pecoflyer

    2. Excel Formula Help 3

      • tdm99
    3. Replies
      3
      Views
      222
      3

    4. alansidman

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

      • Jingles3X
    3. Replies
      2
      Views
      258
      2

    4. KjBox

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

      • DezB
      • DezB
    3. Replies
      9
      Views
      512
      9

    4. mrgramm

    2. Subtraction With Catagories 1

      • jgaffney86
    3. Replies
      1
      Views
      307
      1

    4. KjBox

    2. Creating customer frequency report 6

      • JamJ
      • JamJ
    3. Replies
      6
      Views
      340
      6

    4. JamJ

    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
      574
      2

    4. Excel Noob

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

      • DezB
      • DezB
    3. Replies
      1
      Views
      355
      1

    4. GlennUK

    2. IF Functions and tolerances. 3

      • Shezmo1
    3. Replies
      3
      Views
      375
      3

    4. gijsmo

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

      • DezB
    3. Replies
      7
      Views
      527
      7

    4. Pecoflyer

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

      • RAJESH SHAH
    3. Replies
      6
      Views
      992
      6

    4. RAJESH SHAH

    2. Format a cell based on information in another worksheet

      • DSessions
    3. Replies
      0
      Views
      261

    2. Color code bar chart data bars based on a y- axis criteria dynamically 1

      • CapG
      • CapG
    3. Replies
      1
      Views
      729
      1

    4. GlennUK

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

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

    4. alansidman

Label

Display Options