Excel function help wanted.....

Go to: Forums > Technology: Applications and Software

There are 18 postings to this topic on our Member website and this page runs 7 days behind our Member website. For the full topic click to sign up to OUTeverywhere.

A topic from Technology: Applications and Software

non_sequiturTue 29/04/08 10:04		I have a spreadsheet with values in columns B to P. Column A is the name of each row of values. Column Q is a numerical value that we can ignore for the purposes of this question. Sometimes in the same row the same value might appear - eg, 1AS123 might turn up in D7500 and G7500. or 2SL100 might show up in E340 and H340. You know what I mean. So, the question is how do i show in column R whether that row has a duplicate value?
countryslickerTue 29/04/08 10:20		I'm not sure that you can do it using a function, but you could highlight duplicate values using conditional formatting; To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab. Hope this helps!
cliveTue 29/04/08 10:23		quoting > "I'm not sure that you can do it using a function, but you could highlight duplicate values using conditional formatting; To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab. " But that's only any good if there are only a handful of possible cell entries that are duplictaed. I get the impression there could be many possible cell contents that could be duplicated.
non_sequiturTue 29/04/08 10:24		Hmm - thanks for that - but as there are 1000s of rows, it would still entail me visually checking for the rows with the formatting. having a signifier in column R would allow me to use an autofilter to just show those rows - which i have to report on separately. I'm sure its possible - after all, am i not just looking for frequency of an value that is greater than 1?
non_sequiturTue 29/04/08 10:25		good point, clive - i dont actually know which values will be duplicated... just that some values are!
cliveTue 29/04/08 10:27		How many possible outcomes are there? If there aren't too many, could you not set up a new column for each one and then use one of the count functions to show the number of duplicates there are on each row for each outcome?
cliveTue 29/04/08 10:28		Sorry, didn't see you last post when I made my last one.
non_sequiturTue 29/04/08 10:34		no worries - appreciate the thinking though!

There are 10 more postings on this topic on our Member website. For the full topic click to sign up to OUTeverywhere right now.

Enjoy chatting with our members

Imagine joining a social network of people from all around the country and see how you'll feel a year from today. You're increasing your circle of friends. You're doing more of the stuff you enjoy. You're having a great time meeting new people in your area. You're seeing all the benefits of becoming a member of OUTeverywhere. It still feels great making new friends and every day you're hearing more and more about the stuff that everyone's doing. You're joining in. Now, that was easy, wasn't it?

We make meeting people easy. Click to sign up to OUTeverywhere and get up and do something different!

PLEASE NOTE: Events are listed on this website on behalf of organisers in accordance with the Terms of Membership of OUTeverywhere and only if they have chosen broad publicity when adding their event to the Member Events calendar. As such, events are not necessarily affiliated to or endorsed by OUTeverywhere and may not be organised by the person who has listed the event: the person listing this event may simply be attending an event organised by another person or organisation and may wish to meet other people sharing their interest in the event. The mention or appearance of any person or organisation featured on these pages is not to be taken as any indication of sexual, social or political orientation of such persons or organisations. We cannot guarantee that the information is accurate and recommend that you always seek to contact the organiser directly to confirm full details of any event. Under no circumstances will we be responsible for any loss or damage resulting from reliance on, use or misuse of, the information on this website.

Our Vision | Our Team | Privacy Policy | Identity Theft Protection | Terms of Membership

Chat and Meet People

Enter one or two words to tell us something you enjoy:

Or enter a postcode or the name of a place:

Latest Shout OUT

Broadcast to the gay world with our public Shout OUTs service! Post on our member website or from your mobile phone and raise your profile.

Chad R (badlands) from the Leicester area in United Kingdom shouts OUT: "Why are all the hot guys taken?"

Events Calendar

< July 2008 >
S	M	T	W	T	F	S
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

This Topic's Tags

Members tag topics with key words to help us find similar topics.

Discover GMEET

Add all your web profiles to the new GMEET.com website profiles directory service. Supports Facebook, YouTube, MySpace, Bebo, LinkedIn and dozens more. For social and business networking, web personals and online dating.