Latest revision as of 17:40, 24 March 2023

conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.
Then combine the results into 1 excel file

How to Split an Excel File into multiple sheets or multiple files

Merge 2 files based on id, then calculate total price by multiplying 2 columns. The create a pie chart

@@ Line 1: / Line 1: @@
+=[[Rename files using excel as source template]]=
 =[[Clean up excel data]]=
 =[[Merge Excel Spreadsheet with same columns]]=
 =[[Conditional Search Multiple Excel Files]]=
 * conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.
+* Then combine the results into 1 excel file
 =[[How to Split an Excel File into multiple sheets or multiple files]]=
 * Filter data and put results in either multiple sheets or multiple files
+=[[Combine multiple excel files into One]]=
+* Go through a dir and combine multiple excel files
+=[[Merge files based on ID, then do calculation]]=
+* Merge 2 files based on id, then calculate total price by multiplying 2 columns. The create a pie chart
+=[[Merge Files based on primary key, and sort]]=
+* query two files based on primary key, sort results on various columns
+=[[Python, Excel Individual Commands]]=
+* Single commands such as: sorting pie charts opening excel files