Hi People,

I have Columns A and B full of data and I would like to be able to
Write a function (might have to be a Macro), to find how many times the
exact value 5.3 occurs occurs in column A.

I also want to be able to write a function or Macro that will search
for all the instances of 5.3 in column A and when it finds an instance,
take the value in the same row, but in column B and add it. So I will
end up with the total of the values in column B that are in same rows
as values of 5.3 in column A.

Any suggestions as to how I could do this?

All help will be much appreciated


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=520503