Posted to microsoft.public.excel.worksheet.functions

Haz

external usenet poster

Posts: 46

function for repeated cells

hi

I have a spreedsheet that has cells that are repeated amongst others I want
to write a function that will identify these.
if column A has this data in it how can I pick up the identical cell in
Column B
DMM9844
DMM9844 1 - this what I want in col B.
DMM9756
DMM6456 1
DMM6747
DMM3463
DMM4574

i think it may be a sumif function but i can't get it to work. Can anybody
help?
Thanks

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 repeated data in adjacent cells	akeene	Excel Discussion (Misc queries)	3	July 14th 06 08:54 PM
Printing text in a repeated cell/row that is longer than repeated	Valerie Dyet	Excel Discussion (Misc queries)	1	February 13th 06 03:27 AM
Deleting cells with repeated data	petevang	Excel Worksheet Functions	2	December 6th 05 10:27 PM
Delete repeated Cells	Mosqui	Excel Worksheet Functions	2	September 13th 05 01:31 AM
Repeated row	carlo	Excel Discussion (Misc queries)	2	December 3rd 04 10:47 AM

All times are GMT +1. The time now is 10:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us