Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Using index and match in the right way 2

      • MihaiBanciu
    2. Replies
      2
      Views
      132
      2
    3. Niraj

    1. Using IF, AND, OR 3

    2. Replies
      3
      Views
      779
      3
    3. skywriter

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

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

    1. Using Address() in a logical test 3

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

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

      • yogeshtalks
    2. Replies
      8
      Views
      1.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
      317
      8
    3. Ryan017

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

      • trader1588
    2. Replies
      11
      Views
      693
      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
      184
      2
    3. tac_79

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

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

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

      • babr1477
    2. Replies
      3
      Views
      141
      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
      363
      11
    3. Fluff13

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

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

    1. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    2. Replies
      3
      Views
      965
      3
    3. AliGW

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

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

    1. Urldownloadtofile is downloading files to INetcache 1

      • Thanis Albert
    2. Replies
      1
      Views
      149
      1
    3. AlanSidman

    1. Update Validation list from another cell 2

      • Darryl256
    2. Replies
      2
      Views
      73
      2
    3. Darryl256

    1. Update column using vlookup and 2 cell references 1

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

    1. Unique reference based on multiple columns 6

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

    1. Unique rank with multiple criteria 1

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

    1. Unique (text) value for Randbetween 4

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

Display Options