I have a set of data that is linked to a certain Id number--in my table called "PIN". In the base data set, there are associated #s, such as total lot area,...

Date Session Time Topic Speaker Name 1st Feb 8:00 P.M - 8:30 P.M Key Note Abhishek Kanth 1st Feb 8:30 P.M - 9:30 P.M Ado .Net Entity...

I have a sheet with a list of items in column A and a quantity in Column B. In the case where I have identical items in column A, I only want to see the row...

Any clues for speeding things up to return the location/range of the last filled cell in a column? Function LastInRange(InputRange As Range) Dim CellCount As...

I have three Excel 2007 lists, around 200 rows each. I've now found I need to insert a blank row after each list entry. Is there any easy way to do this? ...

How to print the excel 2007 file's last save date as part of the footer? Google search found only...

I am having a problem with excel 2007 with copying sheets. I can copy a sheet repeatedly until I rename the sheet and then copy again. I get a message that...

I set rows 1-3 to repeat on all pages, but on the second page, it is getting cut off a few columns in.any suggestions? thanks!

Is there any function which will search for a specific combination of letters in a range of data. Say data is in column A(A1 to A1000). How to find how many...

I would like to create a worksheet that gives a weekly total for each of my teams call stats. That would then generate a monthend total for each team. Any...

Using Vista and Excel 2007, I will be constructing a mailing list with 10 columns. In the first empty row of column A will be added a new name for the list....

Is there a function key that will repeat the value entered in the previous column similar to access with out having to copy down?

Trying to write an IF statement to return one value if the cell is empty and another if not. For example, if the cell is empty, return the value above, if...

I have 4 sheets of data(sheet 1,sheet2,...) and 10 columns of data on each sheet, each sheet starts with column A as the part number and 10 as a price. I have...

I am using xl7.0. I have located ribbon & remove duplicates, but cannot seem to get correct result. I am using it against 6 cols of data. Is that my...

Hi, I have a report that prints with the same information on several rows. Let me explain. I have a heading row the includes the following. Name, SSN,...

Hi - I want to count based on a rolling data range and I can't seem to figure out how to do it. My data looks something like this: Jan09 Feb09 Mar09 ...

I have two separate worksheets Worksheet A COLUMNA COLUMNB Insurance Company Name ...

I need the use the equal sign -- "=" -- in a worksheet without Excel assuming I'm begining a function or formula. I changed the cell to "Text" format, but...