Hlookup?

C

coa01gsb

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
 
C

coa01gsb

Cheers Max, that sounds simple will try it out.

Managed to do the first bit myself using COUNTIF
 
C

coa01gsb

Similar to the above:

I would also like to Know the max value of the values in column B in
rows for which the value in column A of the row is 5.3.

I would like to do similarly with calculating the 90th Percentile

And if possible a formula for use in a line graph that would only plot
the values in column B, that had a corresponding value of 5.3 in column
A

Any ideas?
 
M

Max

coa01gsb said:
.. I would also like to know the max value of the values in column B in
rows for which the value in column A of the row is 5.3.
Click to expand...

Some thoughts for the above part:

Try in say C2, array-entered (press CTRL+SHIFT+ENTER):
=MAX(IF(A1:A100=5.3,B1:B100))

Adapt the ranges to suit, but we can't use entire col refs

I'm not sure about your other parts
Hang around awhile for insights from others
 
Top