Formula that looks at two columns
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
I am trying to determine how many times my colors are associated with
the objects --
Colors Objects
Red Square
Red Circle
Red Square
Yellow Oval
Yellow Star
Yellow Star
Blue Star
Blue Square
Blue Square
For instance, I would like to know how many times Red and Square show
up and how many times Red and Circle show up. Is there a forumula
that will take a look at both columns.
Thanks.
.
Relevant Pages
- Text box & Circles Disappear
... circle or a square it disappears when I scroll down or change the zoom ... Prev by Date: ... (microsoft.public.word.application.errors) - Re: how do I type around the edges of a triangle
... > How do I type around the edge of a triangle, circle or square? ... Prev by Date: ... (microsoft.public.publisher) - Transferring background to object
... it into an object (square, circle, etc). ... George ... Prev by Date: ... (microsoft.public.powerpoint) - how do I type around the edges of a triangle
... How do I type around the edge of a triangle, circle or square? ... Prev by Date: ... (microsoft.public.publisher) - Re: Nuclear Summer was Re: Radiation Countermeasures was Re: ATTN Walmart Shoppers was Re: Radioacti
... The inverse square law applies. ... You see as you travel in one direction around the sun, the circle is getting larger. ... The square of the orbital period of a planet is directly proportional to the cube of the semi-major axis of its orbit. ... Sir Isaac replied immediately that it would be an Ellipsis, the Doctor struck with joy & amazement asked him how he knew it, why saith he I have calculated it, whereupon Dr Halley asked him for his calculation without any farther delay, Sir Isaac looked among his papers but could not find it, but he promised him to renew it; & then to send it him, Sir Isaac in order to make good his promise fell to work again, but he could not come to that conclusion which he thought he had before examined with care, however he attempted a new way which thou longer than the first, brought him again to his former conclusion, then he examined carefully what might be the reason why the calculation he had undertaken before did not prove right, & he found that having drawn an Ellipsis coursely with his own hand, he had drawn the two Axes of the Curve, instead of drawing two Diameters somewhat inclined to one another; whereby he might have fixed his imagination to any two conjugate diameters, which was requisite he should do, that being perceived, he made both his calculations agree together. ... (sci.physics) |
|