|
|
#6
01-16-2012, 01:46 AM
|
||||
|
||||
Hi Woolstar,
It's not clear what you want. To exclude email addresses from the test, change the first formula to: =A2&B2&C2&E2 To inc;ude the 'initial' occurences of duplicates amongst the duplicates, , change the second formula to: =COUNTIF(F:F,F2)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Construct a summary sheet by summing up from one or more than one sheet.
|
PRADEEPB270 | Excel | 1 | 11-04-2011 03:46 AM |
|
Merge Doc skips records
|
eonelson | Excel | 11 | 01-30-2011 03:49 PM |
|
Moving formula range multiple cells when moving sum over one cell
|
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
| Help with consolidating multiple records into one | wbiggs2 | Excel | 0 | 11-30-2006 01:02 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode