I tried the formula and have DIV# errors... I have uploaded the sample doc as per requested HUI...Heres the link to my sample in drop box....
http://dl.dropbox.com/u/15655422/Sample.xlsx
Thank you!!!!! (any other suggestions are eagerly welcomed!!!
Row1-row500: Product Names,
Store A - Column2: # of products in inventory... sometimes zero
Store A - Column3: Cost of Products...sometimes zero (if price has not been key'd)
Store B - Column4: # of products in inventory... sometimes zero
Store B - Column5: Cost of Products...sometimes...
I have large spreadsheet with many rows and columns... Each row is a product. the columns adjacent list., column 1:location, column2:# products in stock . column3:cost of product... Im trying to find the average product cost which is gathered from all the locations total spanning all locations...
Hello Chaos is back... It's Been awhile. Looking for best approach.
I have Specific Names (Job Titles) that are listed in 1st column one.
There are adjacent columns providing Names of 20 Locations (Site 1-20) with # of positions, and Annual Salary of position for dept within site (so they...
Okay... Heres the link... THANK YOU!!!
https://skydrive.live.com/redir.aspx?cid=8c4598bed3ef132a&resid=8C4598BED3EF132A!118&parid=8C4598BED3EF132A!108&authkey=!APbwTT7JCa7_nJc
I have given instruction in the report as too how the master report is feed by the field reports... Keep in mind I...
I have made the CMDUPDATE changes and everything per your instruction. One thought about the cell M21 wks1 and E32 and E34.
Are each of those cell to be blank? Of course thers'a sum formula in M21 because it's summing a total column..
As for the E32 its a link from M21...As for E34 that is...
Rats! I got the button to look like it works... It does not pop up anything like your example...as well it's kind of random when I think it's work, but it really isnt' working well.....
These are the reference info... maybe you can make it work this way...
I put the button on the Base report...
okay... I am not sure where I found it I have been collecting for a couple of years randomly... As for adding for a reference doc... I did not even know if it was functional so that's why I put it out there for Experts hands to figure out...
Thank you for your guidance... Once I know something...