Ubuntu
openoffice.org package

office.org

Asked by PPaul

may i have the formula to distinct all duplicate data from a column???

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Bhavani Shankar (bhavi) said : 		#1

Hello

This link might help you out

http://www.oooforum.org/forum/viewtopic.phtml?t=38890

In general:

One relatively easy way is to do a filter and copy to another sheet. On the menu bar, go Data > Filter > Standard Filter and click on the More >> button. You should see a 'No Duplication' check box. Then setup the filter, specify the sheet/cells where you want the results to go and press ok.

Regards

Revision history for this message
Harvey Muller (hlmuller) said : 		#2

PPaul,

I am checking to see if the information provided previously resolved your question. If so, please mark this question Solved.

Thanks!

Harvey

Revision history for this message
Harvey Muller (hlmuller) said : 		#3

PPaul,

I am checking to see if the information provided previously resolved your question. If so, please mark this question Solved.

Thanks!

Harvey

Can you help with this problem?

Provide an answer of your own, or ask PPaul for more information if necessary.

To post a message you must log in.