General

How do I copy a formula with the cell increasing by increments?
I have a similar issue but I am just trying to reference cells and not sum. I have a row with several sets of data in in it that I want to consolidate into a more vertical structure for analysis. for example Row 1, columns A:AX, the first two columns stay the same and then in sets of 6 columns I want to bring... 3 May 2010 16:30

merge cells without losing data OR format
Need to merge A1 with B1. Critical to retain the format of each cell. A1 has text that is Left Justified. [JOHN ] B1 has text that is Right Justified.[ SMITH] Need the merged cell to retain each format. ie. [JOHN SMITH] I know I cannot use the CONCATENAT function with the spaces, becau... 6 May 2010 09:40

Locating row with no duplicate matching amount
I have a spread sheet with 4 columns and 900 rows I am trying to identify the rows that do not contain a duplicate amount. For example I have rows with 100 100 97 97 96 96 98 101 I am trying to pull the list of 98 and 101. The spreadsheet is a list of invoices paid vs invoices unpaid if it is ... 3 May 2010 17:37

Finding all unique rows and excluding all duplicates
I have a spread sheet with 4 columns and 900 rows I am trying to identify the rows that do not contain a duplicate amount. For example I have rows with 100 100 97 97 96 96 98 101 I am trying to pull the list of 98 and 101. The spreadsheet is a list of invoices paid vs invoices unpaid if it is ... 3 May 2010 16:30

finding unique values
I have a spread sheet with 4 columns and 900 rows I am trying to identify the rows that do not contain a duplicate amount. For example I have rows with 100 100 97 97 96 96 98 101 I am trying to pull the list of 98 and 101. The spreadsheet is a list of invoices paid vs invoices unpaid if it is ... 3 May 2010 17:37

Sorting in Pivot table
I have a data set I am putting into a pivot table to show the data over time but do no not want the data added up. I have the product as a page by, the classification in row, mont in column, and # and % in data. The problem is it is adding the West New Customers and West Continuing Customers together. The da... 3 May 2010 16:30

drawing in excel
how do you set up grid for drawing in excel ... 3 May 2010 16:30

convert .123 file
Is there a way to convert a Lotus 123 spreadsheet (.123 extention) to an excel 2007 file? ... 3 May 2010 16:30

Reference Column of Named Cell vba
I have named a cell on sheet - how doe I reference just the column property of that named cell in vba on another sheet in the same workbook please ? Thanks ... 3 May 2010 09:50

VBA vocabulary
A self-taught learner of any language needs good a dictionary. Can any one tell me where I can find a publication of VBA vocabulary? Thanks. Tom ... 3 May 2010 03:22