Formula to calculate Latest Cost (inventory valuation) I have a worksheet that contains the daily purchases for 4 products. column B contains the products column D contains the purchase price column K contains the division column J contains the day of the month I need a formula that will pull the latest purchase price by product by division. In other words the ... 4 May 2010 13:29 How do I remove data in a row in excel without losing all data in ... 29 Apr 2010 14:41 I want to conditionally format an entire column after 1 year from I am trying to conditionally format a column to have the text (which are dates) to turn red/bold a year from the date in the cell. I know how to bold/red, I just can't figure out how to set it for a year from the date in each particular cell. The dates are different in each cell. Thank you! ... 29 Apr 2010 14:41 Formula issue. I am creating a formula to copy data from one cell to another and I always get the \$ in my formula. I do not want to copy the same data that is in that cell, so I have to go in and manually remove the \$. How do I fix this issue. ... 29 Apr 2010 13:33 IF, THEN HELP I have a rate chart which covers different values, such as: If the rate is between 32.00 and 33.99 then the cost is multiplied by 38% (1.38). If the rate is between 34.00 and 35.99 then the cost is multiplied by 37% (1.37) I want excel to automatically give me the resulting figure when I put in the rate, so t... 5 May 2010 18:17 Format a dollar amount to text Is there a way to take \$10.56 and format it to read Ten dollars and 56 cents. Thanks in advance for your help. Jordan ... 30 Apr 2010 10:36 Copy IF criteria met "Don Guillett" wrote: Sub GETDATA() With Sheet2.Range("a1:a200") Set c = .Find(What:="FILE ID #", LookIn:=xlValues, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=True) r = 2 If Not c Is Nothing Then firstAddress = c.Address ... 29 Apr 2010 12:25 using GETPIVOTDATA feature and need to keep formatting I want to copy a value from a pivot table and am combining it with text using the =(C1&" "&(Getpivotdata....)) feature. The values in the pivot table are monitary and I'd like to keep the \$ sign and '000 comma but the formatting disappears (ie no comma or \$ sign) Thanks ... 29 Apr 2010 13:33 Combine an And OR function I have a little function that i need help with. =IF(AND(\$B9="Z",AE9=35,J9=1),1000). This function works fine, however I need to add in somehow that J9 could equal M or 1 or C and I would like the function still to be true and return the value as 1000. As I see it, this is smoehow combining and AND OR statement... 29 Apr 2010 12:25 dates on worksheets I want to type the date and day (05/01/2010 Sat) on my 31 sheets. How can I type in the first day of the month and have each successive sheet advance one day without typing it on each sheet individually? Thanks so much. -- Ann ... 29 Apr 2010 12:25