Search for a command to run...
Articles tagged with #dataanalysis
Problem description & analysis: There is a data table: Task: We want to duplicate the data. Solution: Use SPL XLL and enter the following formula: =spl("=?1.id()",A2:A17) Download esProc Desktop for FREE and level up your Excel game!!! 🚀🔥⬇️ ✨SP...
Problem description & analysis: Here below is a personnel data table: Task: Identify whether there are duplicate data, if so, fill in 1 in the corresponding Dup field, otherwise fill in 0 (the identifying basis is that the data in the Name field are...
Problem description and analysis: Here below is a data table of names: Task: Identify whether there are duplicate names, if so, fill in 1 in the corresponding Dup field, otherwise fill in 0. Solution: Use SPL XLL and enter the formula in cell B2: =s...
Problem description: The following tables list the sales data of the top 10 products by sales in January and February: Solutions: Use SPL XLL to tackle the following tasks respectively: A. Find out the sales data of the products that make the top 1...
Problem description & analysis: We have a statistical table for daily sales: Task: Find out the date when the sales rises for three consecutive days or more. Solution: Use SPL XLL and enter the following code: A 1 =0 2 =E(‘A1:B32’).group@o(if(Sales...
Problem description & analysis: We have an Excel table for the daily sales of products: Task: Find out products with the largest daily sales and their sales: Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group(OrderDate).(~.max...
