To any expert out the
I have 10 cells with 4 digit numbers each example : a1=4598, a2=5741 and so
on until you get to a10=7125 Ok?
What function do I use to reteieve the largest of the first digit of each
entry? obviously I am dealing with thousands of cells.
In the above example the largest first digit of the three cells is 7 how do
I automate this for thousands of cells.

Hey thank you!!!!!!!!!!!!

I have 10 cells with 4 digit numbers each example : a1=4598, a2=5741
and so on until you get to a10=7125 Ok?
What function do I use to reteieve the largest of the first digit of
each entry? obviously I am dealing with thousands of cells.
In the above example the largest first digit of the three cells is 7
how do I automate this for thousands of cells.

Maybe this'll help:
=INT(MAX(A1:J1)/1000)

Try this *array* formula:

=MAX(--LEFT(A1:A10))
--
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.
You *must also* use CSE when revising the formula.


--
HTH,

RD

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

"joseph robert" wrote in message
...
To any expert out the
I have 10 cells with 4 digit numbers each example : a1=4598, a2=5741 and
so
on until you get to a10=7125 Ok?
What function do I use to reteieve the largest of the first digit of each
entry? obviously I am dealing with thousands of cells.
In the above example the largest first digit of the three cells is 7 how
do
I automate this for thousands of cells.

Hey thank you!!!!!!!!!!!!

Mr. Ragdyer your formula or function is the correct one for what I need I
laso want however to thank MyVeryonwself, and Mr. Gary student for their
input.
I have another question on the same topic:
Mr. Ragdyer: on the same example what formula do I use this time to
determine the frequency of that first highest digit in so many cells?


thx again
Joseph robert,



"Ragdyer" wrote:

Try this *array* formula:

=MAX(--LEFT(A1:A10))
--
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.
You *must also* use CSE when revising the formula.


--
HTH,

RD

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

"joseph robert" wrote in message
...
To any expert out the
I have 10 cells with 4 digit numbers each example : a1=4598, a2=5741 and
so
on until you get to a10=7125 Ok?
What function do I use to reteieve the largest of the first digit of each
entry? obviously I am dealing with thousands of cells.
In the above example the largest first digit of the three cells is 7 how
do
I automate this for thousands of cells.

Hey thank you!!!!!!!!!!!!

Try this *array* formula to count the number of occurrences of that max left
digit:

=SUMPRODUCT(--(--LEFT(A1:A10)=MAX(--LEFT(A1:A10))))

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

--

HTH,

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

"joseph robert" wrote in message
...


Mr. Ragdyer your formula or function is the correct one for what I need I
laso want however to thank MyVeryonwself, and Mr. Gary student for their
input.
I have another question on the same topic:
Mr. Ragdyer: on the same example what formula do I use this time to
determine the frequency of that first highest digit in so many cells?


thx again
Joseph robert,



"Ragdyer" wrote:

Try this *array* formula:

=MAX(--LEFT(A1:A10))
--
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.
You *must also* use CSE when revising the formula.


--
HTH,

RD

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

"joseph robert" wrote in message
...
To any expert out the
I have 10 cells with 4 digit numbers each example : a1=4598, a2=5741 and
so
on until you get to a10=7125 Ok?
What function do I use to reteieve the largest of the first digit of
each
entry? obviously I am dealing with thousands of cells.
In the above example the largest first digit of the three cells is 7 how
do
I automate this for thousands of cells.

Hey thank you!!!!!!!!!!!!

If you numbers were in cells A1 thru A1000 then:

=INT(MAX(A1:A1000)/1000)
--
Gary''s Student
gsnu200711


"joseph robert" wrote:

To any expert out the
I have 10 cells with 4 digit numbers each example : a1=4598, a2=5741 and so
on until you get to a10=7125 Ok?
What function do I use to reteieve the largest of the first digit of each
entry? obviously I am dealing with thousands of cells.
In the above example the largest first digit of the three cells is 7 how do
I automate this for thousands of cells.

Hey thank you!!!!!!!!!!!!