Posted to microsoft.public.excel.misc

Secret Squirrel Secret Squirrel is offline

external usenet poster

Posts: 172

Finding Duplicate Rows

I have a worksheet with a detail tab and a summary tab. In column A on my
summary tab I have a list of values. What I want to do is look these values
up on my detail tab and see if they exist more than once. If they do I just
want to return a value of "1" in column B on my summary tab. Some of these
values are a combination of text and numbers. How would I write this formula?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Finding duplicate entries	mmcap	Excel Worksheet Functions	5	February 7th 07 07:00 PM
finding duplicate addresses	diamonds	Excel Worksheet Functions	2	June 21st 06 11:40 PM
finding duplicate rows	[email protected]	Excel Worksheet Functions	1	June 16th 06 01:31 PM
Need help with finding duplicate entries	Phil	Excel Worksheet Functions	6	October 20th 05 03:56 AM
Finding duplicate data	Eric Stoakes	Excel Worksheet Functions	3	December 9th 04 04:33 PM

All times are GMT +1. The time now is 03:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us