Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Use Option Button when selected to copy selected field and paste in other sheets 4

      • crbenn01
    2. Replies
      4
      Views
      469
      4
    3. crbenn01

    1. Use of OFFSET function to define X-Axis 3

      • babr1477
    2. Replies
      3
      Views
      216
      3
    3. Carim

    1. Use last value in a column, increment it by 1 and start a new column with this value. If value>x, then start the count in this column, from 1 11

      • leema
    2. Replies
      11
      Views
      804
      11
    3. Fluff13

    1. Use Hlookup to find then sum column within specific dates 1

      • merz
      • merz
    2. Replies
      1
      Views
      682
      1
    3. merz

    1. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    2. Replies
      3
      Views
      1.2k
      3
    3. AliGW

    1. Use a cell as reference to sheet to look in 1

      • wes2706
    2. Replies
      1
      Views
      179
      1
    3. wittonline

    1. Urldownloadtofile is downloading files to INetcache 1

      • Thanis Albert
    2. Replies
      1
      Views
      271
      1
    3. alansidman

    1. Update Validation list from another cell 2

      • Darryl256
    2. Replies
      2
      Views
      125
      2
    3. Darryl256

    1. Update column using vlookup and 2 cell references 1

      • Shezmo1
    2. Replies
      1
      Views
      159
      1
    3. Shezmo1

    1. Unique reference based on multiple columns 6

      • Richard_C
    2. Replies
      6
      Views
      382
      6
    3. jl2509

    1. Unique rank with multiple criteria 1

      • hydebedi
    2. Replies
      1
      Views
      1.2k
      1
    3. NBVC

    1. Unique (text) value for Randbetween 4

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

    1. Unable to perform the index and multiple match array function 4

      • Srisreshtan
    2. Replies
      4
      Views
      573
      4
    3. Fluff13

    1. Unable to perform picture lookup in excel 4

      • Srisreshtan
    2. Replies
      4
      Views
      663
      4
    3. Srisreshtan

    1. Turn Surname and Firstname around 5

      • DezB
      • DezB
    2. Replies
      5
      Views
      303
      5
    3. DezB

    1. Turn SUMIFS negative value into 0 (ZERO) 6

      • jentry.highland
    2. Replies
      6
      Views
      391
      6
    3. Carim

    1. Trying to use data bar formatting 10

      • excelhatesme!
    2. Replies
      10
      Views
      1k
      10
    3. 63falcondude

    1. Trying to understand cell formulas when extra characters used, learn to SUM and AVE 9

      • wittonline
    2. Replies
      9
      Views
      810
      9
    3. wittonline

    1. Trying to retrieve Data over multiple Rows and Columns 3

      • Trompie2017
    2. Replies
      3
      Views
      558
      3
    3. CaulfieldS

    1. Trying to pull specific data from sheet1 to other sheets if it meets criteria 10

      • blade671
    2. Replies
      10
      Views
      1.5k
      10
    3. blade671

Display Options