Search : in
By :

Excel Cell Value count

Last answer on Aug 9, 2009 5:33:56 am BST Dinesh, on Aug 8, 2009 9:43:02 am BST 
 Report this message to moderators

I have questions

Can Cell determined by delimeter ?

I want to count the cell values how many 111 occurs ? pls refer the below example

ColumA Column B
111,222,333 222,333,444
666,333,111

Best answers for « Excel Cell Value count » in :
Can vba return excel cell value with formats Show
Excel - Send value of cell to target Show Excel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Copy numbers of cell values in a single row Show
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

venkat1926, on Aug 9, 2009 1:18:07 am BST

I do not kow whether there are horizontal (in one row) A1 to G1 or in 7 rows from A1 to A7

if its former
=COUNTIF(A1:G1,"111")
will give you 2
if itis vertical
=COUNTIF(A1:A7,"111")

read excel help on "countif"

   
Reply to venkat1926

2

Dinesh, on Aug 9, 2009 2:46:11 am BST

Thanks Venkat.My requirement was column will have values like this " 111,222,333" and other column will have "444,555,333".I need to count how many 333 available in the two columns!!!!???

Is there a way ? Can you or any can help me ?

   
Reply to Dinesh

3

Dinesh, on Aug 9, 2009 2:47:49 am BST

Is there way to get the values from cell with delimeter?

   
Reply to Dinesh

4

 venkat1926, on Aug 9, 2009 5:33:56 am BST

Supposse the entries are in A1 and B1 try this formula

=(LEN(A1)-LEN(SUBSTITUTE(A1,"333",""))+LEN(B1)-LEN(SUBSTITUTE(B1,"333","")))/LEN("333")

now if there are more cells then it would be ccumbrsome. in that case use a macro

the macro is like this

Sub test()
Dim j As Integer, rng As Range, c As Range
j = 0
Set rng = Range(Range("a1"), Range("a1").End(xlToRight))
For Each c In rng
j = j + UBound(Split(c, "333", , 1))
Next c
MsgBox j

End Sub


This was suggested recently by Peter_SSs an expert in one of the newsgroups

   
Reply to venkat1926
Ask your question Reply
They need your help