Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training london - Formulas

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel software training london - Formulas

Resolved · Low Priority · Version Standard

Reply Wed 16 May 2007, 12:49Delegate Joanna said...

Joanna has attended:
Excel Advanced course

Formulas

How do I create a formula to find double entries in database spreadsheets? For example same Company names with the same Account Managers in different column.

For upcoming training course dates see: Pricing & availability

Reply Thu 17 May 2007, 09:46Trainer Amanda said...

RE: Formulas

Hi Joanna

Thank you for your question.

Do you want to be able to eliminate any duplicates from the spreadsheet, or just be able to find where there are double entries?

thanks
Amanda

Reply Thu 17 May 2007, 10:14Delegate Joanna said...

RE: Formulas

hi,

Find them first, assess which needs to be deleted and then remove, therefore find only option would be better.
thanks

Reply Thu 17 May 2007, 11:28Trainer Amanda said...

RE: Formulas

Hi Joanna

Thanks for clarifying that for me.

I have found a web page which contains quite useful information on how to go about this. Please see
http://www.cpearson.com/excel/duplicat.htm

It involves creating an array formula, so rather than me trying to explain it here, it would be best to refer directly to the reference I have put in above.

If you are interested, and you are doing this kind of thing enough to warrant it, there are pieces of software that you can buy specifically for what you want to do, for example, the Fuzzy Duplicate Finder (see http://www.ablebits.com/excel-duplicates-find-remove-addins/index.php)

I hope this helps.
Amanda

Excel articles

· Identifying Suitable Candidates For VBA For Excel Training
· Want To Use Excel To Calculate Your Mortgage Repayments?
· The Secret Formula To Creating Correct Calculations In Excel
· How To Create A Macro In Excel 2010
· Which Is Better, Excel Or Access?

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips