Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count text appear how many times & put in respec col??eg 1st times
Need to found out the text eg Movie appeared how many times in a worksheet.
If 1 time = 1R , 2 time = 2R, 3rd times = 3r etc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
count text appear how many times & put in respec col??eg 1st times
Piglet --
A B 1 Movie 2 Movie 3 Dog 4 Cat 5 6 =COUNTIF(A1:A4,"Movie") Brings a result of 2. HTH "Piglet" wrote: Need to found out the text eg Movie appeared how many times in a worksheet. If 1 time = 1R , 2 time = 2R, 3rd times = 3r etc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
count text appear how many times & put in respec col??eg 1st times
how the result show in the respective column? the 1st times in appeared in
the worksheet show in column A and 2nd times in column b Eg Amt A (1R) B(2R) C (3R) 1 Movie S$1000 S$1000 2 Movie S$5000 S$5000 3 Drama S$3000 S$3000 4 Drama S$500 S$500 5 Movie S$8000 S$8000 4 "Piglet" wrote: Need to found out the text eg Movie appeared how many times in a worksheet. If 1 time = 1R , 2 time = 2R, 3rd times = 3r etc |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
count text appear how many times & put in respec col??eg 1st times
Hi
With your source data in columns A and B with headings of Type and Amount, add a new heading to column C called Frequency In C2 enter =COUNTIF($A$2:A2,A2) and copy down for your entire set of data Place your cursor on the header rowdataPivot TableFinish On the new skeleton Pivot Table grid that appears, drag Type to the Row area drag Frequency to the column area drag Amount to the data area -- Regards Roger Govier "Piglet" wrote in message ... how the result show in the respective column? the 1st times in appeared in the worksheet show in column A and 2nd times in column b Eg Amt A (1R) B(2R) C (3R) 1 Movie S$1000 S$1000 2 Movie S$5000 S$5000 3 Drama S$3000 S$3000 4 Drama S$500 S$500 5 Movie S$8000 S$8000 4 "Piglet" wrote: Need to found out the text eg Movie appeared how many times in a worksheet. If 1 time = 1R , 2 time = 2R, 3rd times = 3r etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count no of times a letter occurs in a text string | Excel Discussion (Misc queries) | |||
count number of times text appears | Excel Discussion (Misc queries) | |||
how do i count text and display it as text plus the # times it hap | New Users to Excel | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
=Text(b2-A2,"h") hours between 2 times, what do I do for 10 times | New Users to Excel |