Other Excel
| Q | How do I delete a self certification? |
| A | Start, Run, Certmgr.msc, look in the Personal tree branch. |
| Q | Can I monitor my PC's performance within Excel? |
| A | From the menu: Insert > Object: System Monitor Control |
 |
|
| Q | How do I calculate where two (or more) criteria are required? |
| A | several ways, but here is one using SUMPRODUCT. The benefit of SUMPRODUCT over other methods is that you don't have to enter this as an array formula. |
 |
|
| Q | Is there an Excel equivalent to Lotus 123's XINDEX? |
| A | Not directly, but here is an alternative formula using SUMPRODUCT. |
 |
|
Published: 20-May-2005
Last edited:
04 August 2005 11:59