Functions

Excel 2007 AutoSaves
I have AutoSave set up to save every 10 minutes to c:\data\autosave\, but there is never anything in the folder. I am saving in the .xlsm format, have left the Default File Location blank, and have not checked the box under Exceptions. Is there something else I need to do? Respectfully, Bob Myers ... 26 Dec 2009 02:33

Strip Flat File Table into less entries
I have a table I found that is essentially a 'hierarchical' table but laid out in such a way I can't really use it w/o further processing. Essentially it is currently something like this Type | Type Code | Subtype | SubType Code | SubSubType | SubSubType Code I really just want to end up with Type | Type ... 26 Dec 2009 05:44

XMAS
Hi All, Merry Christmas to all these wonderfull people who support everyone for free. And of course to all of us who need them. Merry Christmas, JP ... 25 Dec 2009 11:30

repeat code remove
We have a material code list in one column.many code has repeat. We want only one code come only one times.please help Material code. 604789 604801 604801 604865 604865 604890 604893 604895 604895 604896 604896 604896 604901 604901 622992 622993 Submitted via EggHeadCafe - Software Develo... 25 Dec 2009 06:08

Multiple If Function
Im trying to create a report using multiple IF criteria. My formula is working however how can i get the field to be blank if it doesnt meet the criteria? currently if it matches criteria in column C and not column D it is blank but if it doesnt match column C it sais "FALSE". =IF(AND(ISNUMBER(SEARCH($F$1,... 24 Dec 2009 15:10

adding every other column
i need a formula in cell A1 to total cell C1 and everyother column after that i.e. E1,G1 ect i need a formula in cell B1 to total cell D1 and everyother column after that i.e. F1,H1 ect how do i do that? ... 26 Dec 2009 16:35

Please help me to solve the below equation in excel
Hi The equation if item_a=stockitem_a (stockqty_a=stockqty_a-itemqty_a) else if item_b=stockitem_b (stockqty_b=stockqty_b-itemqty_b) .... but more than 7 nested loops are not applicable. so please suggest. .... when i enter an item, the stock should be reduced by the quantity and whn i enter the same it... 24 Dec 2009 11:53

How can I solve this.
Hi when i enter an item the stock should be reduced by the quantity and whn i enter the same item quantity again then stock should be reduced from the remaining quantity. how will i do that...eg item a is entered twice 1st 12 quantity, so the stock should be 2 and i entered a again in the last 1quantity. so... 26 Dec 2009 04:40

Sorting a protected set of cells
I want to sort a range of protected (locked) cells. When I set the protection for the cells I clicked on the Sort option, but my cells still will not sort. What is the point to the Sort option in the Protect Sheet dialogbox? ... 24 Dec 2009 16:15

V-lookup and Countif
I'm trying to create a formula that will look up criteria in one column and count the result of another column. Here is some data as an example: Fruit Have in Stock Orange X Pear X Apple Orange X Orange Apple X I'm trying to create a formula that looks up "Orange" in colum... 23 Dec 2009 16:18