How to do the excel list table: First use the formula in list H4 [=Calculation Sheet!G4]; then click on the G4 cell of the calculation sheet, open the name manager, and customize the formula [=EVALUATE(Calculation Sheet!$ H4)].
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
How to do excel list table:
1. As shown in the figure, the E4 formula of the calculation table: =IF(D4=List!B4,"√","" ) , G4 formula: =IF((E4="") (H4=""),"",JS)
List H4 formula: =calculation table!G4
2, Click on cell G4 of the calculation table, as shown in the figure to open the name manager and customize the formula. The formula inside is:
=EVALUATE(calculation table!$H4)
3. Remember to save as .xlsm format when saving.
Related learning recommendations: excel tutorial
The above is the detailed content of How to make excel list table. For more information, please follow other related articles on the PHP Chinese website!