Orderid
3 Stories

Quickly delete every nth row in Excel

Techguide Susan Harkins explains how to use AutoFilter to delete specific rows in a worksheet.

Wednesday, October 21 2009 01:12 PM

Tags: Microsoft Office, Row, Column, MsgBox, Microsoft Corp., OrderID, Microsoft Word Override Word, Goto, Clear, Microsoft Excel

Two ways to return a unique list in Excel

Techguide Filtering data to produce a unique list of entries is a common task in Excel. Here are two methods of getting the job done: manually and with a bit of VBA automation.

Thursday, April 16 2009 11:48 AM

Tags: Microsoft Office, Microsoft Corp., Data, List, Cell, Database, AdvancedFilter Method, Default Value, Mouse, Microsoft VBA

Reseed SQL Server identity column

Techguide Seeding and reseeding an identity column in Microsoft SQL Server is easy and relatively safe, if done correctly.

Wednesday, July 23 2008 08:51 PM

Tags: Servers, Server platforms