LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Duplicate with Criteria

Hello -

Would anyone be able to help with a Duplicate with Criteria formula.

Thank you!

Formula needed for:

If "Number" column is a duplicate, and "Name" = B, then "X", if not, blank.


Name Number A B C
A 1
B 2
B 3 X
C 3
B 3 X
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do you duplicate information if it matches a criteria Philip Errington Excel Discussion (Misc queries) 3 April 28th 12 10:12 PM
Sum single or duplicate rows with multiple criteria Lisa B Excel Worksheet Functions 3 August 15th 07 08:29 AM
Highlight duplicate entries matching 2 criteria in another workshe RS Excel Worksheet Functions 12 March 15th 07 02:17 PM
Cut Duplicate Records based on criteria Shiva Excel Programming 0 January 3rd 07 03:37 PM
How to use autofilter to delete duplicate rows (2nd criteria) ? Mslady[_11_] Excel Programming 2 October 29th 05 06:36 PM


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"