How to check whether all the numbers in a excel sheet are unique(no repetions)?
Anil
Query - Excel
Anil (1638 Points)
23 July 2009
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.
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.
Ashwani Narnoli
(.)
(1843 Points)
Replied 06 August 2009
| Originally posted by :Anil | ||
| " | You can use the COUNTIF function for calculating it | " |
Live class on PF & ESI Enrollment & Returns Filing(with recording)
CAclubindia
