Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Deniall

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Depending perhaps upon the result of the clarifications requested by several of us above, you might be able to attack your problem by creating a subsidiary tabulation that present your information is a different way. We are told that your present table contains about 1500 columns, each of which...
  2. Deniall

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I am still having difficulties understanding exactly what you are trying to do. My best guess at this stage is that you are trying to identify codes that appear more than once in one column AND also appear in any other column. Can you please confirm/clarify/correct/contradict this.
  3. Deniall

    reversed words in english leading new english words

    I have no comment to make about your main quixotic quest, nor about the way you are approaching it. However your statement I quote above is almost certainly correct, and (if so) will apply to all non-logographic languages, not just English. I further suspect that this would be provable using...
  4. Deniall

    Formula with & and a single quote

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

    Excel: Formula only works with certain numerical values

    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...
  6. Deniall

    What has happened here to Tek-Tips??

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

    What has happened here to Tek-Tips??

    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...
  8. Deniall

    What has happened here to Tek-Tips??

    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...
  9. Deniall

    Not able to log into my previous account, and there's no "Forget Password"

    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...
  10. Deniall

    Count range overlap cells

    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...
  11. Deniall

    Remove recently used symbol

    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.
  12. Deniall

    Remove recently used symbol

    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...
  13. Deniall

    Where to post Q about Microsoft Powertoys App? Solved

    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...
  14. Deniall

    AutoHotKey for a very simple task

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

    Lost edited data in Excel File

    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...
  16. Deniall

    AutoHotKey for a very simple task

    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...
  17. Deniall

    AutoHotKey for a very simple task

    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...
  18. Deniall

    Excel 365- Formula Help - When A1=X and B1=Y, Return C1

    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...
  19. Deniall

    Problem accessing Eng-Tips website

    Kennabytes.[ ] Many thanks for that simple explanation, which some quick experimentation shows to be exactly right.[ ] I can now trigger the error at will. So perhaps the "fix" that seemed to happen overnight a few days ago was a mirage.[ ] Engineering.com didn't fix anything...
  20. Deniall

    Problem accessing Eng-Tips website

    Now, nine hours plus a good night's sleep later, the problem SEEMS to have been fixed, both on my Windows computer and my Android phone.[ ] No reply yet from engineering.com, but the fix is the important thing (provided it persists). [ ]————————————————————————————————— Engineering...

Part and Inventory Search

Back
Top