advance filter.

This Week's Hot Topics

• Code optimization required - run all processes in memory before placing result to worksheet

  • Started by kelly mort
  • Feb 18, 2020
  • Replies: 32

  I need to get these codes run in memory for the various processes, before placing the result onto the sheet instead on interacting with the sheet...
• Formula to insert names

  • Started by Glacombe
  • Feb 17, 2020
  • Replies: 32

  Good afternoon, I have a worksheet that contains employees and their sectors, which we have 14 sectors, what would be the formula to extract all...
• Fill Cell based on Specific Row and Column Text

  • Started by temerson
  • Feb 17, 2020
  • Replies: 29

  Hello, I have a matrix and want to create a code if it finds a specific text in a column (Column F) and row (Row 3), it will fill a cell starting...
• Can Excel unhide/hide rows just by hovering a mouse over it

  • Started by atuljadhavnetafim
  • Feb 18, 2020
  • Replies: 31

  Hi, I have values in D4 Cell which is sum of D5:D8 and again I have value in D9 cell which is sum of D10:D13 and so on...... now I don't want to...
• Copy a worksheet and rename it to the project name in a given cell.

  • Started by Jay3
  • Feb 18, 2020
  • Replies: 26

  Hi All, I have a sheet called "new project requiring board". in column H I have a Yes/No drop down validation list. If the user selects yes I...
• Sum first n cells

  • Started by raikks
  • Sunday at 1:21 AM
  • Replies: 25

  Hi - I need a formula that sums the first 3 cells of component1 that contains ``yes'' (result should be 88) Also - I need to sum the first 3 cells...