Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Using dropdowns to copy cells from one worksheet to corresponding cells of another worksheet and add new rows if needed. 4

      • CNeedsHelp
    2. Replies
      4
      Views
      771
      4
    3. royUK

    1. Using COUNTIFS to try to count records between two dates 5

      • cthompson73
    2. Replies
      5
      Views
      327
      5
    3. royUK

    1. Using Countif to calculate totals from another excel tab 1

      • Xani
      • Xani
    2. Replies
      1
      Views
      187
      1
    3. alansidman

    1. Using Cell Content As Input to a Structured Reference 2

      • thefatstig
    2. Replies
      2
      Views
      415
      2
    3. pike

    1. Using Address() in a logical test 3

      • OceanRoaming
    2. Replies
      3
      Views
      926
      3
    3. OceanRoaming

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

      • yogeshtalks
    2. Replies
      8
      Views
      2k
      8
    3. NBVC

    1. using a formula to find number of days prior to a lost time occuring 8

      • Ryan017
    2. Replies
      8
      Views
      739
      8
    3. Ryan017

    1. using 2 multi conditional if then statements based on value of another cell 11

      • trader1588
    2. Replies
      11
      Views
      1.5k
      11
    3. AliGW

    1. Users able to select only today's date which then remains a static value 2

      • tac_79
    2. Replies
      2
      Views
      470
      2
    3. tac_79

    1. use xlookup function to retrieve value within another xlookup function 1

      • paulbiddis
    2. Replies
      1
      Views
      302
      1
    3. royUK

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

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

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

      • babr1477
    2. Replies
      3
      Views
      356
      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
      1.7k
      11
    3. Fluff13

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

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

    1. Use COUNTIF on column that contains TRIM formula 3

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

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

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

    1. Urldownloadtofile is downloading files to INetcache 1

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

    1. Update Validation list from another cell 2

      • Darryl256
    2. Replies
      2
      Views
      225
      2
    3. Darryl256

    1. Update column using vlookup and 2 cell references 1

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

    1. Unique reference based on multiple columns 6

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

Label

Display Options