Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Using index and match in the right way 2

      • MihaiBanciu
    3. Replies
      2
      Views
      443
      2

    4. Niraj

    2. Using IF, AND, OR 3

    3. Replies
      3
      Views
      1.3k
      3

    4. skywriter

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

      • CNeedsHelp
    3. Replies
      4
      Views
      784
      4

    4. royUK

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

      • cthompson73
    3. Replies
      5
      Views
      337
      5

    4. royUK

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

      • Xani
      • Xani
    3. Replies
      1
      Views
      192
      1

    4. alansidman

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

      • thefatstig
    3. Replies
      2
      Views
      417
      2

    4. pike

    2. Using Address() in a logical test 3

      • OceanRoaming
    3. Replies
      3
      Views
      931
      3

    4. OceanRoaming

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

      • yogeshtalks
    3. Replies
      8
      Views
      2k
      8

    4. NBVC

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

      • Ryan017
    3. Replies
      8
      Views
      747
      8

    4. Ryan017

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

      • trader1588
    3. Replies
      11
      Views
      1.6k
      11

    4. AliGW

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

      • tac_79
    3. Replies
      2
      Views
      473
      2

    4. tac_79

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

      • paulbiddis
    3. Replies
      1
      Views
      314
      1

    4. royUK

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

      • crbenn01
    3. Replies
      4
      Views
      780
      4

    4. crbenn01

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

      • babr1477
    3. Replies
      3
      Views
      360
      3

    4. Carim

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

    4. Fluff13

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

      • merz
      • merz
    3. Replies
      1
      Views
      872
      1

    4. merz

    2. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    3. Replies
      3
      Views
      2.2k
      3

    4. AliGW

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

      • wes2706
    3. Replies
      1
      Views
      351
      1

    4. wittonline

    2. Urldownloadtofile is downloading files to INetcache 1

      • Thanis Albert
    3. Replies
      1
      Views
      519
      1

    4. alansidman

    2. Update Validation list from another cell 2

      • Darryl256
    3. Replies
      2
      Views
      228
      2

    4. Darryl256

Label

Display Options