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!

Search results for query: *

  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/
  16. M

    Excel Pivot Table - Combine Values into a single row

    At least one of us doesn't understand your requirements. That makes it a lot harder to help.
  17. M

    Excel Pivot Table - Combine Values into a single row

    Please step us through the process. In the beginning we have: A B C A user needs to use A, B and C to do: X Y Z At the end we have....
  18. M

    Copying current file to destination

    Offhand, I see these problems: "*" is an illegal character in a file name, so there can never be any files that .endswith('*.txt') so src_files will always be empty. today is not defined. dest_files is not defined Since you're using r strings you don't need to escape the slashes in the paths...
  19. M

    Excel Pivot Table - Combine Values into a single row

    Hi remeng, Thanks for attaching the spreadsheet. However, the spreadsheet that you attached is quite different from everything that you've posted so far: It introduces "Serial Number" that hasn't been discussed at all. In the Component table, the listed "Comp_Qty" is 1 for every serial...
  20. M

    Excel Pivot Table - Combine Values into a single row

    Start with two tables. One to define what parts are in each kit, a second to define how many of each kit are required. Then use Power Query LeftOuter join to get this table: Then pivot that to get what you want:

Part and Inventory Search

Back
Top