Looking for formula that can do the lookup shown in attached table with the added criteria that the lookup value not include products that have 100% VOC content. In other words incorporate criteria (e6:e13<1) at the appropriate place in the formula at J160.
So in my real sheet, I have a drop...
I have developed a portfolio tracking workbook consisting of the following worksheets:
Master
Dividend Per Share
Dividends Received
See attached file.
Note that the Master holds all of the pertinent investment data.
The Dividend Per Share and the Dividends Received worksheets have specific...
I am in need of a solution to count the number of times the word “Strip” and "Prep" appears in a column but stop when the cumulative time in another column reaches 24 hours (Elapsed Time hrs column).
Data is set up like this:
Start Stop Mode Elapsed Time (min)...
I am in need to create a summary table of cumulative points for each participant that has entered in monthly competitions. Currently I have a summary worksheet that I have to manually enter names when new members join and submits to the competition. I am looking for a way to automatically...
Hi,
Need assistance in creating a summary table based on two criteria from an array of stacked tables one after another. The tables have been rearranged as suggested earlier (see link to other post -...
I have a workbook consisting of worksheets with the same layout by month (i.e, Jan 2012, Feb 2012). From that I wish to lookup across each of the worksheets and list all category levels and corresponding months for the three criteria in columns B, C and D which are drop down boxes.
This...