Recent Activity

Activity stream for all registered members at Microsoft Office Forums.

  1. JAYEOLA DAVID KEHINDE posted a new thread.

    Removing {PAGE/*MERGEFORMAT} from my microsoft document

    Pls, I have been working on a document on microsoft word . Just today , I started seeing {PAGE/*MERGEFORMAT} . The references of the...

    Forum: Word

    Mar 29, 2017 at 5:27 PM
  2. msnarayanan replied to the thread Duplicate entry in a column/row.

    Dear frygirl I could not locate #11. But entered the following formula: =Not(or(counting($a$1:$i$9,a1)=1)) The result is that column A...

    Mar 29, 2017 at 3:18 PM
  3. msnarayanan liked FryGirl's post in the thread Duplicate entry in a column/row.

    Try using the formula I suggested in post #11, not this one NOT(OR(COUNTIF($I$6:$M$10,I7)<>1,COUNTIF($I$6:$M$6,I7)<>1)) That which is...

    Mar 29, 2017 at 1:19 PM
  4. FryGirl replied to the thread Duplicate entry in a column/row.

    Try using the formula I suggested in post #11, not this one NOT(OR(COUNTIF($I$6:$M$10,I7)<>1,COUNTIF($I$6:$M$6,I7)<>1)) That which is...

    Mar 29, 2017 at 12:41 PM
  5. Becky liked Ian's post in the thread Microsoft MVP Status.

    Are you a Microsoft MVP? If so, please drop me a private message with a link to your MVP profile (or other proof), and I will enable an...

    Mar 29, 2017 at 11:45 AM
  6. msnarayanan attached a file to the thread Duplicate entry in a column/row.

    dear frygirl thanks for your suggestions. i tried with the formula entered as per instructions: 1. selected all cells i6:m10 2....

    Mar 29, 2017 at 8:06 AM
  7. FryGirl replied to the thread Duplicate entry in a column/row.

    Highlight I6:M10 Data...Data Tools...Data Validation Allow: Custom Formula: =NOT(OR(COUNTIF(I$6:I$10,I6)<>1,COUNTIF($I6:$M6,I6)<>1))

    Mar 28, 2017 at 10:47 PM
  8. LenK replied to the thread Migrate Microsoft Word 2003 AutoText Entries into Word 2016.

    It did the trick! :) Many thanks for helping.

    Mar 28, 2017 at 3:21 PM
  9. msnarayanan replied to the thread Duplicate entry in a column/row.

    dear frygirls i have entered the formula as suggested: =countif($i$6:$m$10,i6)=6 i have not entered "(" sign before =countif: is this a...

    Mar 28, 2017 at 2:14 PM
  10. FryGirl attached a file to the thread Duplicate entry in a column/row.

    Let's start off with this. Maybe it fits what you are looking for. I've added two conditional formatting to table #2. It checks for...

    Mar 28, 2017 at 12:47 PM
  11. msnarayanan attached a file to the thread Duplicate entry in a column/row.

    hi further to my earlier posting, i am now able to "post reply". i am 82 years old and am tech savvy. my passion is to learn...

    Mar 28, 2017 at 10:12 AM
  12. msnarayanan replied to the thread Duplicate entry in a column/row.

    hi Since post reply icon did not appear i have sent a reply per email. Hope this is ok. m s narayanan

    Mar 28, 2017 at 9:46 AM
  13. FryGirl replied to the thread Duplicate entry in a column/row.

    So we don't keep going back and forth, please add an attachment with a clear picture of before and after. What you expect and what you...

    Mar 27, 2017 at 11:59 PM
  14. msnarayanan replied to the thread Duplicate entry in a column/row.

    Hi I tried the formula as suggested by you; but it did work with column A only. I copied the formula to other columns also. The rows...

    Mar 27, 2017 at 4:48 PM
  15. LenK replied to the thread Migrate Microsoft Word 2003 AutoText Entries into Word 2016.

    Thank you for that. I had already identified the link you mentioned but wasn't sure if the result would work for Word 2016. I know I...

    Mar 26, 2017 at 3:58 PM
Loading...