Another Excel question - Page 2

Kevy Baby · 04-25-2008, 04:38 PM

I'll have to give this a try on Monday. Thanks Alex - you rock!

Pirate Bill · 04-28-2008, 08:35 AM

I've never tried deduping in Excel, but I do it all the time in Access (just one of my usual tasks here at work). So I'm wondering, why use a spreadsheet for database type work?

Kevy Baby · 04-28-2008, 09:24 AM

Quote:

Originally Posted by Pirate Bill

I've never tried deduping in Excel, but I do it all the time in Access (just one of my usual tasks here at work). So I'm wondering, why use a spreadsheet for database type work?

Because I have Excel and I know how to use it. There is only one project that I need to do this one, so I haven't taken the time to get and learn Access (or Fox Pro). The main thing I use Excel for (often in conjunction with Word) is for cleaning up sloppy data entry and for re-formatting before importing into Filemaker Pro, which is where we do the actual publishing.

There may be better ways to accomplish this, but I am using the tools I know. If this we're a full time project, I would either learn new tools or (more likely) hire a programmer.

04-25-2008, 04:38 PM	#11
Kevy Baby Chowder Head Join Date: Jan 2005 Location: Yes Posts: 18,500	I'll have to give this a try on Monday. Thanks Alex - you rock! __________________ The thing about quotes on the internet is that you cannot verify their validity. - Abraham Lincoln
	Submit to Quotes

04-28-2008, 08:35 AM	#12
Pirate Bill Quality since 1973 Join Date: Dec 2007 Location: Right here Posts: 473	I've never tried deduping in Excel, but I do it all the time in Access (just one of my usual tasks here at work). So I'm wondering, why use a spreadsheet for database type work?
	Submit to Quotes