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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mintjulep

  1. M

    Apply Filter

    Embrace Boolean. =ISBLANK(B5) Filter on TRUE To show things on a separate sheet, use the FILTER() function. If you have a newish version of Excel you could also use the PIVOTBY() function.
  2. M

    PRINT title in center on hight page for each page

    Maybe he figured out himself.
  3. M

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Just to illustrate how this "problem" and "solution" grow: OP states that the data size is 1,500 x 300. OP provides trivial example with size 3 x 5 The trivial example produced 5 results. Increasing the data size to 4 x 7 produces 198 results. How many results will be produced from the full...
  4. M

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I'll restate my first reply. This sounds like you are asking for help at implementing a possible solution to a problem rather than asking for help to solve the actual underlying problem. Why don't you take a step back and try to more clearly explain what you have, and what you need.
  5. M

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Here it is in raw Python. import pandas as pd import itertools as itt data = {'column1': ['ABC', 'BCD', 'EFG', 'HU', 'KLM'], 'column2': ['BCD', 'EFG', None, None, None], 'column3': ['KLM', 'MNO', 'EFG', None, None]} df = pd.DataFrame (data) print (df) for source_column in...
  6. M

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Hi mikrom, I'm surprised to hear your claim of itertools ignorance, since you once helped me with it. https://www.tek-tips.com/threads/all-combinations-of-a-list-of-boolean-items.1796539/ Unfortunately, my version of Excel doesn't seem eligible for python. Without disparaging your solution...
  7. M

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    @mikrom Instead of building a dictionary, try a set. Use itertools to generate all the subsets. Test for presence of each subset in each column.
  8. M

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Seems like set intersections, i.e. inner join, might be useful.
  9. M

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    How do either of those proposed solutions address "two or more like values"?
  10. M

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    @Kim296, your description is confusing to me also. Your screenshots provide trivial examples compared to the stated size (1,500 x 300) of your data and number of possible permutations to check for (two or more). Frankly, this sounds like you are asking for help at implementing a possible...
  11. M

    XBRACKETS - bracket MATCHING IN NOTEPAD++

    DM is called a "conversation". There's an envelope icon. But d0vgan hasn't logged on in three years.....
  12. M

    Excel Webservice

    See this: https://www.tek-tips.com/threads/activeworkbook-saveas-when-the-template-is-on-onedrive.1809713/
  13. M

    PDF to text converter for batch folder processing

    I'd try Goolge's NotebookLM for this. There's an API, so you can interact programmatically.
  14. M

    Having trouble with Excel Lookup

    Many functions (including the lookup functions) accept or require arrays as inputs. Such functions are NOT array functions. Array functions return an array. In current versions of Excel functions that return arrays do so automatically. It's no longer necessary to explicitly enter them as...
  15. M

    Excel: Formula only works with certain numerical values

    Take a look at Doug's collection. https://newtonexcelbach.com/2014/05/31/feet-and-inches-and-other-units/
See more

Part and Inventory Search

Back
Top