Microsoft Office Forums - View Single Post - [Solved] Trying to count the number of cells ending with 001 or 002

Thread: [Solved] Trying to count the number of cells ending with 001 or 002

View Single Post

Old

07-25-2019, 09:14 PM

Kenneth Hobson Kenneth Hobson is offline

Kenneth Hobson is offline

Kenneth Hobson uses Windows 10

Windows 10 Kenneth Hobson uses Office 2016

Kenneth Hobson uses Office 2016

Office 2016

Advanced Beginner

Join Date: Jun 2018

Posts: 37

Kenneth Hobson is on a distinguished road

Default

Welcome to the forum!

One method would be to use a helper column. Then count the number of Trues.

=IF(AND(LEN(A2)>=3,VALUE(RIGHT(A2,3))>=1,VALUE(RIG HT(A2,3))<=2),TRUE,FALSE)

Reply With Quote