General

Select number from leftmost column that has one
On a spreadsheet with 800 rows and 12 columns of data, how can I add a column that is filled by the leftmost column that has data. Some rows have data in only one of the 12 columns, some in 8, etc. No matter how many there are, I only want the leftmost, no matter which column it is. ... 28 Apr 2010 22:00

how to combine several files, all with same columns, into one
Hi Ron I have run the RDB Merge Ad-in, to merge 95 Excel files. There is just 1 problem, it merged the files and data, but the fill colours of the cells are now "no fill" and that is the most important part of my merge! How do I do the merge and make sure that the cell fill colours are also duplicated? Than... 28 May 2010 01:47

SUMPRODUCT(ARRAY) RETURNING "VALUE#"
I'm using =SUMPRODUCT(--('sheetname'!$c$2:$c$100="SAname"),--('sheetname'!$h$2:$h$100)) to find an SA in Col C and add up his roll call in Col H. The formula worked in the original worksheet, but when additional lines were added to 'sheetname', the formula is returning #VALUE!. The formula looks OK. What went... 28 Apr 2010 19:45

Splitting multiple cell contents from 1st column into 4 columns
n my first column I have 4 cells (1-4) (5-8) etc. with general content. The content from each of these 4 cells needs to be placed in a separate column to make a list that I can sort etc. Example: COLUMN A 1 01-04-425-001 2 Heatherridge Road #301 3 Harry Smith 4 H25 Condo Fairfax Place 5 01-05-356-041 ... 28 Apr 2010 18:37

Search end/beginning of cell
I know I can do this with functions but is there anyway to do search/replace indicating this? In word I just do ^pWord or Word^p but not sure how/if I can do this in Excel ... 28 Apr 2010 20:53

'07 Large Operation Error (Delete / Insert Rows and/or Columns
Thansk Bob - but - I get the same errors...... "Bob I" wrote: Perhaps Goto Last Cell and see where the sheet really ends, then delete the rows of nothing. Elgee wrote: Help! I was so excited to have '07 until... I have a very simple worksheet in a work book - This very simple wor... 29 Apr 2010 10:08

counting part numbers
Hello everyone- I would like excel to count how many same part numbers i have and list them. Such as P/N 11222=20, P/N 11333=30. Any suggestions? thx ... 28 Apr 2010 17:29

counting part numbers
Hello everyone- I have bunch of part numbers and I would like excel to tell me how many of each part number I have. let's say P/N 11222= 1 P/N 11333= 2 ... 28 Apr 2010 17:29

'07 Large Operation Error (Delete / Insert Rows and/or Columns)
Help! I was so excited to have '07 until... I have a very simple worksheet in a work book - This very simple worksheet takes up 78 rows and 16 columns. Minimals formats / formulas etc. I would like to insert additional rows but I get the error message which says "Large Operation. The operation you are about ... 28 Apr 2010 16:20

How do you link list boxes
I'm trying to create a schedule which allows the user to select a state, and based on the state selected, to choose a county or city within that state. Can this be done, if so how? -- Henry ... 28 Apr 2010 16:20