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