Functions

formatted cells
cells are formatted a certain way i.e. with formulas or dates. On more than one occasion when i close the worksheet and reopen, the cells are formatted completely differently ... 16 Apr 2010 11:43

Converting PDF or HTML to Excel
Is there a way to take the information in this link: http://204.65.203.5/public/441280noadd.pdp and convert it into an excel spreadsheet that separates the information according to name, zip code, etc? This is the main website with numerous listings. The file is in PDF too. http://www.ethics.state.tx.us/php/... 16 Apr 2010 16:14

Count if past today () - 30 days
Hi all, Trying to count the amount of risks the are open and and past todays date by 30 days... So far i have =COUNTIF(C9:C98,"Open"'(R2) Risks Log'!C9:C98,">="&TODAY() - 7)) but i can not get this to work :( ... 20 Apr 2010 12:24

If 3 If's, then sum
I need to add hours if 3 critera match. In the below, if there is a 90 in the G column AND a 10 in the J Column, AND a 100 in the D column, then add the H column. Being that this criterea is found only in row 3 and row 6, I need the result to be 3 (H3 +H6). row D G H J 3 100 ... 19 Apr 2010 12:37

Dynamic Filtering...Need Help
Using Version Excel 2003 I have a report that retrieves different data based of data validation. In each case there are rows that have no data and I want these hidden when the user selects another data set based on their validation selection. To do this I am using the auto filter function. The issue I am ru... 16 Apr 2010 11:43

Finding the lowest cost for a product from a list
I have a list of products with the cost of each (each product appears on the list multiple times with varying costs). I need to create a formula that will pull the lowest cost for each product into another existing list which displays all the products once. Any help is appreciated. ... 16 Apr 2010 11:43

Using text and formatting sum function in formula
I am attempting to show text in a cell concatenated with the sum function and it works fine. The problem is the result has 10 decimal places in the resulting number. I have tried to use the format function with the sum function without success. Here is the formula I am working with: ="Total is: " & Format(SUM(... 16 Apr 2010 14:00

Identify the windows just below the menu
I am writing instructions for non-users of excel and need to identify the windows just below the menu. specifically the one that identifies what cell is ready for data. the one that indicates the name of the selected data for sorting purposes (just above cell A1. ... 16 Apr 2010 14:00

Can you sum the amount of type a word appears?
Trying to sum the about of type a risk is open....So i need a statement to say =SumIF(A1;A6=open,dont count)??? ... 16 Apr 2010 11:43

excel 2007 macro recorded pivot table
I record a macro in excel 2007 in which i create a pivot table. when i try to run the macro i get "invalid procedure call or argument". the same process works fine in excel 2003. If i look at the debug window the "problem code" is : -ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ ... 19 Apr 2010 04:19