I have one list that contains general info. I made another to list different columns value from first list for Data, index and/or lookup functions. Is there a...

I need assistance creating a formula to extract the supplier name associated with the lowest supplier bid. A sample of the data looks like this. I need to...

I am trying to adjust a user inputted time, date and Time Zone to Universal time. Date: C2 Local Time: C3 Time Zone: C4 But the problem is subtracting...

I have a spreadsheet with $costs arranged according to values in both rows and columns. How do I create drop down lists for both the rows and columns and then...

I have an old database that stored it's data in a sequencial format with fixed lengths for each field. As Windows 7 64-bit no longer allows the running of...

Hi, I need to implement state machine in Excel as follows: There are 6 valid states: S1,S2,S3 and B1,B2,B3 Valid moves between...

Hi Richard try =IF(A1="O",B1*C1,IF(A1="F",D1,IF(A1="D",B1+C1,"no solution"))) HTH Frank Richard wrote: I am trying to work out a formula for multiple...

I would like to write a formula that will put the name of the sheet on that page. i.e. the sheet name is "Base Case", I would like to put a function in...

I have a file that was 8MB when I started. I created a pivot table pulling 7 fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot...

Hello, I'm looking for a formula that will calculate overtime. But here's the problem... We do business in California and are required to pay overtime...

Can someone please tell me how to get excel to count how many times 2 numbers appear in a series of sets of 7 numbers? I am try to write a lottery database...

Hi, Somehow my Pivot table is not summing up rows at the end when I have more than two data field in excel 2007. It does sums up by columns. Does any one...

I have been trying to figure out the leverage formula for a set of X Y values X Y 75 16 83 20 85 25 85 27 92 32 97 48 99 48

If cell B3 is between a number range and another cell in same Row =(Z) count. As cells are populated the count will increase. So the cell must be between 10...

Thanks in advance I have a row that that is sometimes blank or contains a number followed by a space and two letters eg. In cell A1 I have the value 456 CR...

Cell DQ contains a formula that pulls in the status of the item. Here is my existing formula so...

Working in Excel, I am looking for help using interactive fill-in check boxes. I am creating a form. Setting up a cell or a bunch of cells merged, or not...

I am using the formula COUNTIF but this would apply to any formula requiring range input. Must the range be for adjacent cells? I am trying to define the range...

I want to add to the following formula a condition if PO04!$T$24:$T$1500 contains the letter "E" a value will be returned, if not leave cell...

I have created a macro in a workbook that has multiply worksheets (tabs). The macro works great on the worksheet where the macro was created. However, when I...