Recent content by Deniall

Can you utilise Excel's CHAR() function? CHAR(34) will give you a " and CHAR(39) will give you a '.

The approach BF...KC suggests is almost certainly what you will need to do with a formula like the one you are wrestling with. However if you have some suspicions of where your problem lies you can evaluate internal parts of the entire formula by highlighting it in the editing bar and pressing...

For those of us who are not up with the lingo, what is a "breadcrumb" when it is at home?

Thanks, Combo, for the suggestion about using the NOVA style. It removes the problem I had with invisible highlighting when I am composing a reply. Back in the good old days I used to make a lot of use of non-breaking spaces, generated with the code string [ ], mainly (but not only) as an...

I am in total agreement with all the above. Why was this done without any warning, and without providing registered users (ie contributors) with some sort of description of how to replicate the behaviours and nomenclature we were taking advantage of on the old site? I have wasted several hours...

On my computer at least, the entire site seemed to suddenly change its appearance, its structure and its underlying philosophy three or four days ago. If there was any advance warning that this was going to happen, I missed it. I used to get a start-up screen that simply showed me a summary of...

I am not aware of how you might do this entirely in the Excel environment, but in the VBA environment you can use the Intersect method. Intersect(Range("a1:d4"),Range("c3:g7")).Address returns $C$3:$D$4 Intersect(Range("a1:d4"),Range("e5:g7")).Address has a null return, meaning that the...

I am using Windows-10, and that Alt-key plus numeric keyboard caper seems to work with any program that is expecting keyboard input. [ ]————————————————————————————————— Engineering mathematician/analyst.[ ] See my profile for more details.

Another way to get an en-dash is to hold down the Alt key while typing 0150 on the numeric key pad.[ ] To get his big brother the em-dash, it's Alt-0151.[ ] I use both these symbols sufficiently often that it is worth my while to have memorized them...

I have successfully used AutoHotKey for this purpose (shortcuts for text substitution).[ ] When I needed some help with it I posted on this site's "Microsoft:[ ]Windows" forum. [ ]————————————————————————————————— Engineering mathematician/analyst.[ ] See my profile for...

Thanks.[ ] It has (further) helped me, and has become my preferred approach. [ ]————————————————————————————————— Engineering mathematician/analyst.[ ] See my profile for more details.

If I am working on a complicated spreadsheet for an extended period of time I initiate my own frequent backups in addition to whatever AutoSave might do.[ ] I give these backups different names every time:[ ] MyWorkbook01.xls, MyWorbook02.xls, MyWorkbook03.xls, and so on.[ ] On...

Thanks, Mike.[ ] I registered at the AHK site you gave, and submitted my query.[ ] However it has not been posted yet b/c they (quite rightly) want to individually vet the first posts from new members before actually posting them.[ ] In the meantime I did some more spade-work...

I am a first-time user AutoHotKey (AHK), trying to get it to give me a shortcut for a text string (my email address) that I have to enter very frequently in all sorts of contexts.[ ] The shortcut I wanted to use was Ctrl-Shift-R, and I expected this would be an easy task requiring only the...

I pretty sure I am missing something here, but the way I read your query would result in the answer to place the formula =IF(AND(A1=x, B1=y), C1, "something else") in whichever cell you are dealing with.[ ] If this is not what you mean can you please elaborate things a bit more...