FILTER works well with other Excel functions like SORT and UNIQUE to create powerful data management combinations. You can ...

Want to remove your identification when adding a Comment or an edit change in Word’s Track Changes or a Comment in Excel? Gregory A. Hook, CPA, director of the performance audit division of the ...

If you are interested in learning more about how you can manage data categorization in Excel while preserving historical values, a concept known as a “slowly changing dimensions” (SCD). Managing and ...

Please note: This item is from our archives and was published in 2004. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I have a spreadsheet ...