Prev: Oracle Extract in Excel 2007 causes processor to run at 100%
Next: Fill Series
From: Ron on 9 Feb 2010 21:42
Here is my problem. I have to enter apt # on a spreadsheet for tracking
material used. The problem is I am always finding duplicates. What I would
like to be able to do is this.
Enter the unit number ain a single cell. That will then move to a specific
row in numeric order. If i enter a number that already been entered it will
flag me.

Does this make sense.
From: Vital_ar on 10 Feb 2010 02:36
Dear Ron,
Is it should be highlited if you enter a Apt #, which is alredy entered?
Then Conditional Format ("Format only unique or Duplicate values" in Excel
2007) may help you.

Thanks & Regards

"Ron" wrote:

> Here is my problem. I have to enter apt # on a spreadsheet for tracking
> material used. The problem is I am always finding duplicates. What I would
> like to be able to do is this.
> Enter the unit number ain a single cell. That will then move to a specific
> row in numeric order. If i enter a number that already been entered it will
> flag me.
>
> Does this make sense.
 | 
Pages: 1
Prev: Oracle Extract in Excel 2007 causes processor to run at 100%
Next: Fill Series