| View previous topic :: View next topic |
| Author |
Message |
ds.sundar
General User
Joined: 25 Oct 2005
Posts: 34
|
 Posted: Sat Dec 17, 2005 12:24 am Post subject: find the values in a particular column. |
 |
|
Hello Guys
I am new it Open office.
I have a problem.
Suppose I have a very large file with some 1000 rows of data.
In column B some five values comes again and again. (Sundar, Muthu, Rajeah, Ram, & Arun )
Now I have to find what are all the values found in Column B
How Can i do this.
Thanks
SUNDAR |
|
| Back to top |
|
 |
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
| Posted: Sat Dec 17, 2005 2:13 am Post subject: |
|
|
I'm not sure what you are asking:
maybe it's the (Data>Filter...Autofilter?)
Does this help?
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Sat Dec 17, 2005 8:34 am Post subject: Re: find the values in a particular column. |
|
|
| ds.sundar wrote: | Hello Guys
I am new it Open office.
I have a problem.
Suppose I have a very large file with some 1000 rows of data.
In column B some five values comes again and again. (Sundar, Muthu, Rajeah, Ram, & Arun )
Now I have to find what are all the values found in Column B
How Can i do this.
Thanks
SUNDAR |
If I understand you correctly, you want to know the number of times Sundar occurs in the 1000 row, Muthu occurs and so on. Let's say your rows are in column A
Enter Sundar in Cell D1 and in another cell enter
| Code: | | =COUNTIF(A1:A1000;D1) |
Repeat for the other names.
There may be an easier way but I believe this will work
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
