Second, tools and raw materials: excel tables.
Third, the method:
1. Create an inventory list. As shown in the figure below:
Inventory goods are registered in chronological order, and the balance is automatically accumulated.
F2 = if (C3 = "","",sum product ((C $3: C3 = C3) * (D $3: D3-E $3: E3)) is copied.
2. Establish a query table of outbound, inbound and inventory balance to keep abreast of the inventory situation of each commodity. See the figure below:
i2=index(c:c,min(if(countif(i$2:i2,$c$3:$c$ 1000),4^8,row($c$3:$c$ 1000))))&； The array formula was copied.
Array formula. After the formula is entered, put the cursor in the formula edit bar and press CTRL+SHIFT+ ENTER to make the array formula take effect.
J2 = if (i3 = "","",sum product (($ c $3: $ c $1000 = $ i3) * d $3: d $1000)) is copied down to the right.
L2=IF(I3= "","",JBOY3 -K3) copy it down.
Microsoft Excel is one of the components of Microsoft office. It is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems. Excel is an important part of Microsoft office suite software, which can process all kinds of data, make statistical analysis and assist decision-making, and is widely used in management, statistical finance, finance and many other fields.
Microsoft office
Microsoft Office is a set of office software developed by Microsoft, which can run on Microsoft Windows, Windows Phone, Mac series, iOS and Android. Like other office applications, it includes federated servers and Internet-based services. Since the 2007 version of Office, it has been called "Office System" instead of "Office Suite", which reflects the fact that they include servers.
Office was originally a promotional name, which appeared in1early 1990s, referring to a collection of software previously sold separately. At that time, the main promotion focus was: buying a collection saved a lot of money than buying it alone. The original versions of Office included Word, Excel and PowerPoint. "Professional Edition" includes Microsoft Access, and Microsoft Outlook did not exist at that time. With the change of time, Office applications are gradually integrated and enjoy functions such as spelling and grammar checking, OLE data integration and VBA scripting language. At present, Microsoft extends Office as a development platform, and can download third-party software from specialized stores.
Office is often the standard for making document files. It has some functions that other products do not have, but other products also have functions that Office lacks. Since 2007, Microsoft Office System has had a completely different user interface from the previous version. This interface is called Ribbon interface, which is used in Microsoft Office 20 10, Microsoft Office 20 13 and Microsoft Office 20 16.