+ Reply to Thread
Results 1 to 7 of 7

formatting of duplicates/formula for knowing duplicates

  1. 12-09-2013, 11:03 PM #1
    sevaa
    sevaa is offline
    Registered User
    Join Date
    07-31-2013
    Location
    Atlanta ,Georgia USA
    MS-Off Ver
    Excel 2010
    Posts
    19

    formatting of duplicates/formula for knowing duplicates

    hi, any one know how to format to know that there are duplicates in your cell..like for example:
    calf exercise -dec 9
    exercise workout -dec 11
    chin ups bodybuilding - dec 9
    how to do chin ups - dec 11
    chin up exercise - dec 13

    i just need to format the first two words excluding the dates so that i would know if i type any of the same word on the following cell or on the next lines.

    any one know how to formulate it?thanks
    Reply With QuoteRegister To Reply
  2. 12-09-2013, 11:26 PM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: formatting of duplicates/formula for knowing duplicates

    Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 12-09-2013, 11:29 PM #3
    sevaa
    sevaa is offline
    Registered User
    Join Date
    07-31-2013
    Location
    Atlanta ,Georgia USA
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: formatting of duplicates/formula for knowing duplicates

    i have attached the file..
    Attached Files Attached Files
    Last edited by sevaa; 12-09-2013 at 11:36 PM.
    Reply With QuoteRegister To Reply
  4. 12-09-2013, 11:32 PM #4
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: formatting of duplicates/formula for knowing duplicates

    Thanks for the sample file

    But please don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

    So please edit post #3 and remove my contents from it.
    Reply With QuoteRegister To Reply
  5. 12-09-2013, 11:54 PM #5
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: formatting of duplicates/formula for knowing duplicates

    Give some brief about your attached file like the which data needs to be considered and how?
    Reply With QuoteRegister To Reply
  6. 12-10-2013, 12:03 AM #6
    sevaa
    sevaa is offline
    Registered User
    Join Date
    07-31-2013
    Location
    Atlanta ,Georgia USA
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: formatting of duplicates/formula for knowing duplicates

    well the datas under FCS schedule,i wanna format it based on the words because i might type the same set of keywords for the next week..so i would just be aware that i have already that keyword on the 1st week scheduled.
    Reply With QuoteRegister To Reply
  7. 12-10-2013, 02:43 AM #7
    sevaa
    sevaa is offline
    Registered User
    Join Date
    07-31-2013
    Location
    Atlanta ,Georgia USA
    MS-Off Ver
    Excel 2010
    Posts
    19

    Unhappy Re: formatting of duplicates/formula for knowing duplicates

    maybe i can just take off the date..and how to format the cell? it wouldn't apply to the last one down..any formula on these?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to find duplicates, concatenate cells, then delete old duplicates
    By givemepuppies in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-04-2016, 02:43 AM
  2. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  3. Macro concatenating columns together, exceptions with duplicates, delete duplicates
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-05-2011, 05:37 PM
  4. Formula for removind duplicates without using 'remove duplicates' button
    By acaran02 in forum Excel General
    Replies: 2
    Last Post: 03-20-2011, 11:19 AM
  5. Duplicates with spelling errors, not exact duplicates and partial duplicates
    By ViaPointe in forum Excel General
    Replies: 3
    Last Post: 03-09-2011, 07:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1