Shorter version
=OR(AL2={5,10,25,50,100})
Shorter version
=OR(AL2={5,10,25,50,100})
Also be aware that formatting is the way XL shows contents to the outside world. The underlying value is a number. e.g. 0.6666666 is the same as 16:00:00 or 04:00:00 PM, etc.. Formatting will NOT change the underlying value which XL will use for calculations
I haven't followed the entire discussion, just wanted to add that in O365 ALL formulas are array formulas by default AFAIK. So, entering with CSE is not necessary any more. ( to remove the feature the formula should be preceded by a @)
Would be Great if we, all, could benefit from the OP's feedback ... !!!
After 7000 + posts you still wonder ?
I've thousands of posts on another forum, and it still frustrates me every day
1. Your strings in col B in the TELUS sheet are text while in the other sheet they are numbers so they cannot match
2.=VLOOKUP($B2,TELUS_SEPT_2022!$B$2:$C$1469,3,0) is impossible as you are looking in the 3rd column of a two column range ( the lookup column refers to the range in your formula, not the position in the sheet
Try
instead and pull down
As text is left aligned in cells and number are right aligned, NEVER apply manual alignment of columns before your formulas are working
Seeing your workbook ( not a picture) would help..
Your sheet seems to be protected ? Still using XL 2007? Please add some expected results. Thx
Why not simply use MSWord's Mail Merge?
Lots of tips and tricks at https://www.msofficeforums.com…ailmerge-tips-tricks.html and https://yamm.com/blog/mail-merge-excel/
ruppk825 Please add your XL version to your profile, as answers are tailored to the version you are using. Thanks
I've also searched the Registry for it and it doesn't seem to be there either.
Have you observed in the provided clip that when the Key is not present you can add the DWORD yourself to the registry?
Cross posted on at least 4 other forums
Just a wild guess. Have you tried enabling/disabling hardware acceleration ?
For pre-O365 versions see https://www.top-password.com/b…-acceleration-for-office/
For O365have a look at
I have faced this date problem many a times in my past applications .Hopefully I will come up with something to solve this problem too
To make your XL experience easy, DO NOT apply manual alignment to ranges you will use in formulas. Why ? Because text is always left aligned by default in the cells. So, if you see a left-aligned date, you immediately know you have to (probably) work on it
for Excel this is THE beginning of Time !!!
That I can do by selecting the A column from cell A2 to end in the raw data sheet, right click and convert it into dd-mm-yyyy
You might want to read https://www.excelcampus.com/fu…/how-dates-work-in-excel/ to understand how it works
Why did you start a new thread? It makes things confusing for the forum members
You can enter a range in the Holidays argument containing formulas that calculate variable holidays
I found one for Easter at https://www.contextures.com/exceleastercalculation.html
As for Labor day, it depends on the country I suppose. So, search the Net for other variable dates you need, there is probably an answer out there
I know, but you asked for a formula, so...
Same here