我认为,我知道,从哪里开始这样做,但令人痛心的是,我很早就需要一些援助。 首先,我与我的产品数据相比,需要将四种产品数据清单进行比较。
例如,每个产品清单都有以下数据:
Product Category
Product Name
Inventory
Product Price
Each of the lists have at least a thousand records.
What I need is a fifth list that tells me which of the competitors products I don t have on my list.
最后但并非最不重要的是,如果这种骗局是,库存包含重复记录。
我甚至难以在我花时间处理这个问题。
What I want though is a list of products that are shared by all of the competitors that I do NOT have on my product list.
如果你熟悉实用软件,那么多分辨率幅度办法或许可以用来满足你们的需要。
通过利用PivotTable wizard dialog(Shortcut: Alt+D+P)选择多功能区块,然后进入与以下相似的方言。 这些数据载于同一表格,但同样可以存放在不同的表格中,甚至可以存放在封闭的手册中。
如表所示,将栏目和组别产品名称改为“材料”和“未配对”。 有几种方法使分组自动化,最简单的方法可能是在4个物品的囚室添加一栏可装饰和过滤器,然后通过Alt+来选择在行方的可见物品;选择集团选择。 将这一组改为“材料”,然后在计数栏中过滤少于4项的物项,并改名为“不匹配”组。
现在,你可以使用简单的ook或其他方式,把所有与你自己的产品名称进行比较。
For an Excel formula I need the first cell out of a list of cells which contains a numeric value: A | B | C | ... | Z | ----------------------------- | 0.1 | 0.4 | ... | =0.1 | | ...
I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
Does anyone know how to convert an Excel date to a correct Unix timestamp?
I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...
I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...
I have created an Add-In in C# that implements user defined functions for Excel. These UDF s return immediately, but they control background asynchronous procedures. These procedures have status ...