摘要
针对VLOOKUP函数查询基本模型的局限性并考虑到模型的延展性,为了解决其只能完成首列满足条件的非重复单个数据的查询,本研究对此模型进行了修改和完善。改良后的模型兼具查询和统计功能,具有一定的实用价值。
According to the limitation and extension of VLOOKUP function inquire basic model,and in order to achieve the inquire of non-duplicating individual data which satisfy the begin column,the research revises and perfects the model.The improved model owns inquire and statistic function,and it has practical value.
作者
梁明
Liang Ming(Department of Shipping Economy and Trade, Guangzhou Maritime University, Guangzhou 510725, China)
出处
《黑龙江科学》
2020年第14期26-27,共2页
Heilongjiang Science
