FUNCTION QUESTION

[Guest]

To any expert out there:
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!!!!!!!!!!!!

 

[MyVeryOwnSelf]

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)

 

[Guest]

If you numbers were in cells A1 thru A1000 then:

=INT(MAX(A1:A1000)/1000)

 

[Guest]

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]

Try this *array* formula:

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

 

[RagDyeR]

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!
=====================================================



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,