Extract/Count a records that containing a digits, numbers in a cell

[mmr1]

Hi,

Required a formula help to extract a records (at least which contains one number in a cell) contains a numeric values in data set Column A:C,as well same values (at least which contains one number in a cell) to be count their actual quantity from the total data set.


Thanks,

Book1
	A	B	C	D
1	lab12	PEN1	polo	KVF
2	albc	alg5	KIK	HQX5
3	defq	CJIo	YMI3	STC5
4	a21b	oplo	lopo	gbh
5	cdes	qwre	GLT5	GST
6
7
8	Count
9
10
11	Records are Containing Numbers
12
13
14
15
Sheet1

 

[Peter_SSs]

Can you post the sample data again but include the expected results (entered manually) and add any further explanation that you can as to why they are the required results?

Can you also clarify that you mentioned columns A:C but you have shown us columns A:D. Does column D have anything to do with it?

 

[mmr1]

Thank you for your valuable response

It was typing error A:C,actual data set is column A:D.

In a cell A9 required answer is count of total digit numbers contains in a cells of total data set is about=08

Starting from cell A12 desired answers like

A12-lab12, B12-PEN

B13-alg5, D13-HQX5

C14-YMI3,D14-STC5

A15-a21b

C16-GLT5.

thanks,

 

[sandy666]

FYI:
a record (also called a structure, struct, or compound data) is a basic data structure. Records in a database or spreadsheet are usually called "rows".
A record is a collection of fields (cells), possibly of different data types, typically in a fixed number and sequence.

 

[navic]

It would be good if you set the expected results
If I understood you well, give it a try

In the 'F1' cell formula below (copy from F1 to I5 ). This is helper columns

=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A1))>0

In the 'A9' cell formula below

=COUNTIF(F1:I5,TRUE)

In the 'A12' cell formula below (copy from A12 to D16)

=IF(F1=TRUE,A1,"")

 

[Peter_SSs]

.. or perhaps like this?

mmr1.xlsm
	A	B	C	D
1	lab12	PEN1	polo	KVF
2	albc	alg5	KIK	HQX5
3	defq	CJIo	YMI3	STC5
4	a21b	oplo	lopo	gbh
5	cdes	qwre	GLT5	GST
6
7
8	Count
9	8
10
11	Records are Containing Numbers
12	lab12	PEN1
13		alg5		HQX5
14			YMI3	STC5
15	a21b
16			GLT5
Sheet1

Cell Formulas
Range	Formula
A9	A9	=COUNTIF(A12:D16,"?*")
A12:D16	A12	=IF(COUNT(FIND(SEQUENCE(,10,0),A1)),A1,"")

 

[mmr1]

Many thanks Peter and all of you for your valuable solutions.

 

[Peter_SSs]

You're welcome. Glad to help.