Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Quick help with an IF formula in excel not working on large dataset 1

      • healthguy
    2. Replies
      1
      Views
      201
      1
    3. royUK

    1. Need help converting this logic into a sumproduct type of formula 3

      • newparadigmz
    2. Replies
      3
      Views
      229
      3
    3. bosco_yip

    1. Using Address() in a logical test 3

      • OceanRoaming
    2. Replies
      3
      Views
      241
      3
    3. OceanRoaming

    1. Converting Date to text add 1 Week 13

      • Billyrj
    2. Replies
      13
      Views
      385
      13
    3. Billyrj

    1. VBA to insert IF formula to convert dates to DD/MM/YYYY 8

      • Rovi
      • Rovi
    2. Replies
      8
      Views
      475
      8
    3. Rovi

    1. Data Query based on the drop down selection based on the dependent/independent drop down validation list 7

      • kumarma
    2. Replies
      7
      Views
      431
      7
    3. GlennUK

    1. Number input to correspond with specific text 9

      • Sp8y8
    2. Replies
      9
      Views
      392
      9
    3. Fluff13

    1. conversion of hours & Minutes to hours & hundredths 1

      • CaptianBill
    2. Replies
      1
      Views
      149
      1
    3. royUK

    1. xlookup multiple criteria? 2

      • browncoat
    2. Replies
      2
      Views
      647
      2
    3. gyankosh.net

    1. Counting unique rows 24

      • schweggen
    2. Replies
      24
      Views
      1k
      24
    3. loisdoig

    1. Format a range depending on inputted values 1

      • D_88
      • D_88
    2. Replies
      1
      Views
      162
      1
    3. GlennUK

    1. Water Billing Rates Formula 2

      • EvanBerrett
    2. Replies
      2
      Views
      203
      2
    3. EvanBerrett

    1. Looking for Absentees 8

      • kennethbrandon
    2. Replies
      8
      Views
      414
      8
    3. GlennUK

    1. Countif Formula inc Trim 1

      • Krayna
    2. Replies
      1
      Views
      178
      1
    3. GlennUK

    1. Conditional Formatting highlight consecutive cells above a specific value 3

      • Palletjack
    2. Replies
      3
      Views
      271
      3
    3. GlennUK

    1. Dynamic Formula with specific terms defined in table 4

      • johanzarchu
    2. Replies
      4
      Views
      163
      4
    3. GlennUK

    1. Searching on multiples dates. 7

      • Granier22
    2. Replies
      7
      Views
      346
      7
    3. royUK

    1. Sum with criteria in a table 1

      • Mark UK
    2. Replies
      1
      Views
      143
      1
    3. CARACALLA

    1. Custom searchable drop down list..... 8

      • nmkhan3010
    2. Replies
      8
      Views
      459
      8
    3. GlennUK

    1. COUNT AND SUM FUNCTION BY DIALY, WEEKLY AND MONTHLY 2

      • nmkhan3010
    2. Replies
      2
      Views
      169
      2
    3. nmkhan3010

Display Options