1. 2

    Exceptions table

    Hello, How can I return records from table-1 that do not match with records in table-2? I have a master table (say Table-1) that contains all the data. Another table (Table-2) contains records that I do not want to see in the resulting table. I need to do following: (Table-1) - (Table-2) =...
  2. P

    Such as Pivot Table but not!

    Hi there, I have a table as attached "Table-1". How could I make it with fastest way to reshape like "Table-2"? My best way to make it is to copy "Module 1" and paste, then filter "Module 1" w/o choosing blanks, copy Part numbers and usage quantities and paste to near of "Module 1". And same...

Some videos you may like

This Week's Hot Topics