LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Duplicate info in a database

howdy,
I'm sorry if this has already been asked and answered but I can't seem
to find it.
I have a database with 5927 entries in each column with a total of 5
columns (A-E). I need to remove the duplicate information in the first
column (A) however the information is linked with figures in the other
4 columns. When I tried the advanced format feature I couldn't get it
to work properly (could sort column A but not have the linked data) is
there a simple way to do this or will I require a complex forumla?
Thanks a million
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
duplicate info in cells ranvin56 Excel Worksheet Functions 2 December 12th 07 05:27 PM
how do I duplicate info from an original worksheet to another? spiderWebb Excel Discussion (Misc queries) 1 November 24th 06 03:49 PM
Link info in one cell to info in several cells in another column (like a database) hansdiddy Excel Discussion (Misc queries) 1 February 22nd 06 02:27 AM
Look up info in a database using 2 conditions cbuker Excel Worksheet Functions 0 January 25th 06 08:59 PM
extracting contact info to a database gordie Excel Discussion (Misc queries) 1 January 15th 05 02:50 PM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"