How-tos - Sharing Tips and Tutorials for Microsoft Office


Here we share the tips and tricks we know about Microsoft Office. It's sharing all those things that we learn and experience along the way of developing Office add-ins and using Microsoft Office.

{tab title="Latest Articles" class="blue"} {tab title="Most Read" class="green"} {tab title="Latest Commented" class="orange"}
How to calculate odds and even numbers from lottery patterns in a cell

its greyed out for me . i'm unable to check the box. anyone else running into this issue ?? Please advise.

thanks for the info. how do you account for multiples of the same initials and can you write a formula to account for them? in other words, joe smith and john smyth, can you have some formula that uses a modified version of =CONCATENATE(LEFT(A2,1),".",LEFT(B2,1),"."), but also make initials for J.S.1, J.S.2 and then you can apply this to all rows?
From all the other posts and videos on this topic, this is the only one that really works.
Thank you
thanks for the info. how do you account for multiples of the same initials and can you write a formula to account for them? in other words, joe smith and john smyth, can you have some formula that uses a modified version of =CONCATENATE(LEFT(A2,1),".",LEFT(B2,1),"."), but also make initials for J.S.1, J.S.2 and then you can apply this to all rows?

is there a way to include .doc I noticed that it works for .docx but not .doc
@Christine24 is the hours

I created a file that contains 12 sheets, one for each month. Each month should have the same page format. I finished decorating my page but when I look at each sheet, I realize that only January, March, July, and September were modified. Why did this happen? How do I fix it?
I do not want to enter date but a constant value in the cell, eg: a number or a text string. please suggest the code changes for the same.

Thanks
hi! I used the basic highlight search bar, but am having a couple of issues. it is predicting my search and finding it with no issues... however, it always highlights the cell a couple below or above the searched one. Are you able to help me with this please?

{tab title="Most Commented" class="red"} {/tabs}