ExcelBanter - Formula

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/124204-formula.html)

lccubb

Formula

I have Excel 2003 and want to search Cells B2:F800 to find how many times
four numbers are used.

Dave Peterson

Formula

=countif(b2:f800,1234)
would count the number of cells in b2:f800 that hold the value 1234.

It would not include "abcd1234xyz", though.

lccubb wrote:

I have Excel 2003 and want to search Cells B2:F800 to find how many times
four numbers are used.

--

Dave Peterson

lccubb

Formula

I have that; however, I want to search those cells for each time number 19,
21, 28, and 35 are together in a row.

"Dave Peterson" wrote:

=countif(b2:f800,1234)
would count the number of cells in b2:f800 that hold the value 1234.

It would not include "abcd1234xyz", though.

lccubb wrote:

I have Excel 2003 and want to search Cells B2:F800 to find how many times
four numbers are used.

--

Dave Peterson

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