I am trying to create a formula that I am afraid is beyond the scope of excel. My first question is - Is it beyond the scope? and second - Do you have any suggestions as to what to use for what I am doing?(ie. crystal reports, jreports, etc.)
I have a worksheet that has multiple fields to...
Hello,
I am trying to create a formula that uses (dynamic) data in a cell that has a drop down menu. However, if I leave the cell blank I want it to use the cumulative data from everything in the drop down combined.
For example: I have multiple sales people and I have a drop down menu that...
I have a multiple page spreadsheet and I am trying to complete a chart page for the data in the earlier pages. The spreadsheet tracks "Sales Opportunities" by "Product Type" and by "Salesperson". There are 29 "Salespeople" and 30 "Product Types", I would like to display each "Salespersons"...