friends, experts and excel pros!

i have the following:

column D ( 300 values representing the average of three cells, A1:A300 & B1:B300 & C1:C300)
column H ( 50 values )
column E & column F & Column G; they are to be filled

What i want is:

To compare the values of column H with the ones in column D for matches.

I know there's a formula for this in Excel but I can't get it right.
I've got a list of 7000+ names in column A, and a list of 4000+ names in column B. Some are duplicates, appearing on both column A and column B.
I want to filter and display the result in column C of those names that ONLY appear in column A.

I need to look up names from column 1 then sum numbers from column 2. Some names in column one appear more then once. (The spread sheet I am working on has 7400 rows!!!)

Example:

Column A ColumnB

Nad 10
Baz 15
Nad 50
Nad 5
Baz 45
Baz 10
Ash 15
Ash 25

How many total numbers for each name.

How can I sum the whole column without freeze head?

I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, so I only know the start of the column is A3, but i dont know where it ends.

Hi,

I am required to arrange columns of a file i.e make the 15th column into the 1st column.

I am doing

Code:
awk 'begin {fs=ofs=","} {print $15,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14}' ad.data>ad.csv
the problem is that column 15 gets to column 1 but it is not comma separated with the initial column 1 ...i.e column 15 and column 1 are getting sort of concatenated wit

I have a .CSV file with the below format:

"column 1","column 2","column 3","column 4","column 5","column 6","column 7","column 8","column 9","column 10
"12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""
"23455","12312255564","string, with, multiple, commas","string with or, without commas","string 2","USD","433","70%

I have a couple of thousand rows of data in Excel where each logical record uses two rows, with the Job/Eqp number and the Job Name in column C on alternating rows. I want to move the Job Name data into column D and delete the unnecessary rows, leaving a more logical layout of one record per row.

i have a file which has few columns.From those columns i need to check the value of column 9 if it is 1 or not.If it is 1 then only i need to print column 4,5,7,9.

Code:

Sample input.
Column 1,Column 2,Column 3,Column 4,Column 5,Column 5,Column 6,Column 7,column 8,Column 9,Column 10.
Heading 1
value 1h,Value 2h,,value 4h,value 5h,Value 6h,Value 7h,Value 8h,1,value 10h

I'm comparing two large datasets containing strings in excel. Column A contains the numbers 1-1,000,000. Column B contains 1,000,000 strings, neatly organized in the desired order. Column C contains 100,000 randomly organized strings, that have identical values somewhere in column B.