Well, I'm looking at this one in IE and no little green checks on any post.
Oh well, we can just hope that one of us gave a response they could use.
They seem to be kind of far and few between all in all. I just looked at my
stats:
Posts 3087 (and I know I participated in over 1200 separate threads this year)
Users that marked some as Helpful: 304
Users that said I came up with 'the' answer: 318
That works out to roughly 1 in 4 on these boards if you assume I was at
least helpful in the 1200 I posted in? I know I wasn't always there with the
answer, several times I totally misinterpreted the question and gave a
totally wrong response.
But enough do say Thanks to keep me going.

"Peo Sjoblom" wrote:

I always wondered about that, they get advice for millions of dollars yet a
minority post back with a thank you? Maybe they use the CDO and rate the
answers there which obviously nobody with a newsreader can spot?



--


Regards,


Peo Sjoblom


"RagDyeR" wrote in message
...
Too bad a lot of OPs aren't as gracious as we are.<g
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I was trying to come up with an array formula (not my strong suit at all),
thinking it would be more concise - thanks for putting that up and letting
me
see it. Nice and tidy.

"RagDyer" wrote:

Try this *array* formula:

Enter number to find in E1, then:

=INDEX(A1:D1,MAX(IF(A2:D3=E1,COLUMN(A:D))))

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead
of
the regular <Enter, which will *automatically* enclose the formula in
curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lisa" wrote in message
...
How do i do a reverse lookup to show the heading in the first row.
Example:
Say I want to now which month the value 29 show up in the below table?
All
I
want the answer is "MAR" or value of 32 is in "Apr". Many thanks



1 A B C D
2 Jan Feb Mar Apr
3 25 27 29 31
4 26 28 30 32