ExcelBanter - first number in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - first number in cell (https://www.excelbanter.com/excel-worksheet-functions/109676-first-number-cell.html)

first number in cell

Hello

How can I (and can I) .. lookup a range of cell containing different
numbers, and extract number of cell begining with first number ...

example:

11120000
11000000
10000000
11300000
21000000
22000000
23000000
21200000
22200000
51000000
41000000
30000000
31000000
32100000
33300000

So i would like the function to scroll through all this value and then
tell me number of cell beggining with number "1" ... Result: 4

Thnx

Baraki0568

first number in cell

each cell in the next column would contain
=if(INT(<entry cell/10000000)=1,1,0)
then you need a cell
=SUM(<range of second column)
to add up the number of true cases

there is probably a more elegant method, but that should work.

" wrote:

Hello

How can I (and can I) .. lookup a range of cell containing different
numbers, and extract number of cell begining with first number ...

example:

11120000
11000000
10000000
11300000
21000000
22000000
23000000
21200000
22200000
51000000
41000000
30000000
31000000
32100000
33300000

So i would like the function to scroll through all this value and then
tell me number of cell beggining with number "1" ... Result: 4

Thnx

Biff

first number in cell

Try this:

=SUMPRODUCT(--(LEFT(A1:A15)="1"))

Biff

wrote in message
ups.com...
Hello

How can I (and can I) .. lookup a range of cell containing different
numbers, and extract number of cell begining with first number ...

example:

11120000
11000000
10000000
11300000
21000000
22000000
23000000
21200000
22200000
51000000
41000000
30000000
31000000
32100000
33300000

So i would like the function to scroll through all this value and then
tell me number of cell beggining with number "1" ... Result: 4

Thnx

All times are GMT +1. The time now is 05:19 AM.