Does anyone know how to delete duplicate numbers in a column within excel?

1 ⤊

Does anyone know how to delete duplicate numbers in a column within excel?

2007-03-20 02:21:09 · 4 answers · asked by fancy 1 in Computers & Internet ➔ Programming & Design

4 answers

Try this question link

2007-03-20 02:32:18 · answer #1 · answered by AnalProgrammer 7 · 1⤊ 0⤋

or you could highlight and backspace or delete. The problem sounds like those boxes have the duplicate formula for the row/column next to them.

2007-03-20 02:29:45 · answer #2 · answered by Billy Dee 7 · 0⤊ 0⤋

Yes use the find and replace utility located under edit. there should be more details about this if you goto: -

http://support.microsoft.com/kb/214138

Hope this helps?

pure_jax

2007-03-20 02:28:09 · answer #3 · answered by pure_jax 2 · 0⤊ 0⤋

edit, find , replace with.....

2007-03-20 02:25:15 · answer #4 · answered by Helping Since 1969 6 · 0⤊ 0⤋