|
|
|
|
| Author |
|
|
Registered
Join Date: Dec 2005
Posts: 3,384
|
Spreadsheet query
Is there any way to have my spreadsheet software tell me if an entry I make in a column was previously made? We're scanning in bar codes into column a but I don't want more than 1 listing for each item on the spreadsheet. I am hoping to do this in google spreadsheets, or office 03.
|
||
08-11-2011, 06:31 PM
|
|
|
Now in 993 land ...
|
|||
|
08-11-2011, 06:39 PM
|
|
|
Registered
Join Date: Jun 2003
Location: Fresno, CA
Posts: 7,768
|
I use Excel and with the many versions of Excel, the procedure has changed a tad but is basically the same.
The formula is Edit/Find/Number you are looking for. Choose Next and it will find he first one, pause, and then find the next, and so on. Other options are find & replace (but this is not what you are looking for). It's basically used for finding misspelled words and in that case, you would select replace all. Hope this helps - excel can get frustrating when they jumble up the menues everytime they want to sell a "new' version but the fimction is still there. I'm sure other speadsheet programs are similar. |
||
|
08-12-2011, 12:35 AM
|
|
|
Back in the saddle again
Join Date: Oct 2001
Location: Central TX west of Houston
Posts: 55,880
|
edit-find sounds like a really labor intensive way to do it. Is there a way to automate that so it performs it automatically each time he scans/enters a new number or are you talking about doing it manually each time he enters a number?
I would think that there would have to be a script or macro that he could use if aigel's method isn't automated.
__________________
Steve '08 Boxster RS60 Spyder #0099/1960 - never named a car before, but this is Charlotte. '88 targa  SOLD 2004 - gone but not forgotten
|
||
|
08-12-2011, 05:17 AM
|
|
|
Back in the saddle again
Join Date: Oct 2001
Location: Central TX west of Houston
Posts: 55,880
|
I assume the ideal would be that you scan a number into a column, and the spreadsheet tells you right away if that column already exists so you delete it then and there and go on to the next widget?
these might be some other options Determine if column contains duplicate value - ExcelBanter VBA Tips & Tricks: Detecting duplicate values (Excel VBA) Spreadsheet Page Excel Tips: Using Data Validation To Check For Repeated Values Avoid duplicate data within a column? - Google Docs Help
__________________
Steve '08 Boxster RS60 Spyder #0099/1960 - never named a car before, but this is Charlotte. '88 targa SOLD 2004 - gone but not forgotten
|
||
|
08-12-2011, 05:24 AM
|
|
|
P-Zero Burner
|
What about using Excel Conditional Formatting? You can setup a column or row to highlight duplicate values in red (or any color). Then as you enter the info it will immediately change the cell color if its a duplicate.
__________________
Stephen 2006 997 Carrera S - Sport Chrono, Full Leather 1968 912 - Purchased from Vasek Polak in 1971 and still in the family ----- 1989 Carrera 4 - Andial service history, Sold and missing it |
||
|
08-12-2011, 09:58 AM
|
|
|
|
Back in the saddle again
Join Date: Oct 2001
Location: Central TX west of Houston
Posts: 55,880
|
Well, I'm not the OP, but if I understand what he wants, that sounds perfect. I'd never heard of it.
__________________
Steve '08 Boxster RS60 Spyder #0099/1960 - never named a car before, but this is Charlotte. '88 targa SOLD 2004 - gone but not forgotten
|
||
|
08-12-2011, 10:16 AM
|
|
Silver Bullet
Red 64
Blue Mood 912
