Hlookup?
 

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

Hlookup?
 

One way, in say, C1: =SUMIF(A:A,5.3,B:B)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"coa01gsb" wrote in
message ...

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

Hlookup?
 

Cheers Max, that sounds simple will try it out.

Managed to do the first bit myself using COUNTIF


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

Hlookup?
 

"coa01gsb" wrote:
Cheers Max, that sounds simple will try it out.

You're welcome !

Managed to do the first bit myself using COUNTIF

Glad to hear that. I missed the first bit, sorry <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hlookup?
 

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?


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

Hlookup?
 

"coa01gsb" wrote:
.. 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.

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---