Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Query - Excel

Anil (1638 Points)

23 July 2009

How to check whether all the numbers in a excel sheet are unique(no repetions)?

Anil

Reply
Follow
Share

4 Replies

(Guest)

Well Anil,

I didnt understand ur questio...

would have elped u in a better way had u explained it in a better way.

But from whatever I understood, I would suggest the following solution.

first, try this in a copy & not in the original.

If u ahve a file having no.s like1234 in one column/row & 34 in another......the file contains (most of the rows or columns)only numerical data, then its applicable.

First sort out all the nos in ascending or descending order.

Upgrade to CAclubindia Pro. Subscribe Now!

suman nvss y (article assitant) (147 Points)
Replied 25 July 2009

hi use exact command for knowing for same numbers in excel sheet. you can use filter command also. but write query clearly

Anil (1638 Points)
Replied 25 July 2009

Hi .Thank you both. Please let me rephrase my query clearly:

I have an excel sheet. One of the coloumns in the excel sheet has accounting code numbers which has been manually entered. Some of the cells in the coloumns are blank. I would like to know how to check that all the accounting codes entered are unique and that the person entering the accounting codes has not entered some numbers more than once in a particular coloumn.

Thanks.