I have a workbook attached with a challenging question.
Any help would be appreciated.
I have a workbook attached with a challenging question.
Any help would be appreciated.
Turn Data into Information
Turn Information into Knowledge
Turn Knowledge into Direction
Turn Direction into Leadership
Turn Leadership into Results
Stephen Druley
It's not how quickly you think
But how deeply you think
The quality of thinking is measured
by remoteness to conformance
Stephen Druley
Can you explain how do you get your numbers?
It is a Lissajous relationship that is computer generated
Will this help?
andPlease Login or Register to view this content.
Please Login or Register to view this content.
Kind regards, Harry.
An excellent contribution to the Forum and to me
More options:
=INDEX(C6:C26,MATCH(51,D6:D26,0))
and
=INDEX(E6:E26,MATCH(51,D6:D26,0))
or
=SUMIF(D6:D26,51,C6:C26)
and
=SUMIF(D6:D26,51,E6:E26)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks