Hi, I'm writing a report script in excel, using powershell. I have sucessfully gathered my data into one excel worksheet and wanted to preform lookups based on the following format
Sheet1 is Report Summery
Sheet2 is Report Data
In Sheet2 I am using colums from A to K. The first row has colums headers.
From Excel or Powershell / Excel how can I preform the following
In colum B, if the cell contains the word "boom" and Colum I contains the word "dynamite" count the number of instances and report into Sheet1 colum D cell3?