(Tech Tip: Excel) Suppress 0 values

<span style=”font-size:smallTo hide values (text or numeric) that have a 0
<
Bad: in general for your Excel sessions (independent of the file)
Tools(menu)… Options(menu)… View(tab)… Window Options(area)… Zero values(checkbox)
 
Better: You can use a formula such as
=IF(F7=0,””,F7)
 
Best: You can do it without a formula by formatting the cell with
Format(menu)… Cells(menu)… Number(tab)
Custom:   #,###_);

How to get unique names from a list

1. Open file and click on column A (selects the entire column)
 
2. Then choose Data… Sort and select “header row” (figure 1) and click OK
Now the list is sorted in alpha order

(Tech Tip: Excel) How to get unique names from a list

If you have a list of information and you want to remove duplicates, use Excel and follow these simple steps.

1. Open file and click on column A (selects the entire column) 
2. Then choose Data… Sort and select “header row” (see below) and click OK