I am sure this is out there somewhere...I just can't find it. A B C D E Cage Box Kennel Dog 2008 ...

I have this formula: =INDIRECT("PrintData!J" &RowIndex) and need to wrap a subtotal 9, around it so that it only includes visible rows when there is an auto...

I have entered a vlookup formula that returns an #N/A error until the data is found. What I would like to do is to display this #N/A as meaningful text such...

I want to place an image (which is a jpeg image) on an Excel worksheet. Is there a way to do that? thanks

Table 1 Table 2 Column A Column B Column D Column E 56650 LSE 56650 LSE 56650 LSE 154004 ...

I need a formulas to exclude $$ Amounts from sumif based on how many months its been in service, example current formulas is:=SUMIF(M4:M23,"JJ",J4:J23) but I...

I have a validation list for a particular cell. It contains a list of longish phrases which I want to be able to select from for that particular cell. But...

I have the following formula below, but I want the formula to also match columnD in addition to columnA on my Data! sheet. ColumnA and ColumnD on Data! needs...

I have to keep track of the time and date that trucks hauling commodities into our business. I would like to use the NOW function, but each time I do all of...

I have tried deleting the certificate but I keep getting a message saying that the worksheet is read only. The worksheet totally locks up. How can I fix it.

i need something that will round as follows: OLD NEW 16.99 =16.99*1.04 result is as follows: OLD NEW 16.99 17.67 what i need is the 17.67 to...

Is it possible to apply a validation to a cell to allow only a 7 digit number followed by any letter from A to W e.g 1234567T? -- dalymjl

Can anyone help me out with creating a formula that does the following. sheet1 has a 'JobCode' in column C sheet 2 has a 'JobCode' in column A with an...

I have 4 protected sheets in a workbook with a little vb code behind them which includes sheet passwords. A user could click on menu bar and add VB Editor...

G'day everyone Many years ago, when I was using an earlier version of Excel (Now currently using 2007), I came across an add-in program that had several...

I am having an issue with getting Excel to reformat time. I copy and paste data from an Access query into a spreadsheet. After doing this, any changes to the...

I have a sheet that has a scorecard on it. I have a drop down list that refers to records from another sheet. If I choose from the drop down list, say 1-5,...

I have a table for each person that's periodically updated with essentially 3 columns: A = week ending dates, B= work hours, and C= travel hours. For any...

I am not aware of a way to save selection sets. I find that I have to change formatting repeatedly for sets of selected cells. It would really help to have...

I have raw data that is horizontal in a worksheet. I need to pull it into a report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1...