banner_ad

Excel

This query is : Resolved 
Profile Image

Profile Image

(Querist)
23 July 2009 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.
Profile Image

Ramkrishna Mokashi

Profile Image

Ramkrishna Mokashi (Expert)
25 August 2009 Simple way is to make a pivot table out of it and finding count of the Account codes. If any code as 2 counts, that means that it is not unique.

Another way is to sort. After sorting put a formula in the adjacent cell checking whether, two cells bear same value or not.

One another way is to import into Access and defining account code field as index key. This one is the best but requires some knowledge of Access.

Hope this proves useful. In case of any doubt please email me at ramkrushna2009@aol.com
Profile Image

Anil

Profile Image

Anil (Querist)
26 August 2009 Thanks,

Anil.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details
Company
ARTICLESHIP 02 May 2026
Accounts and Audit Assistant

Kothawade and Laddha

Thane

B.Com

View Details
Company
14 May 2026
ICSI Trainees for 21 Months and Semi-Qualified CS

CMNITY HIRE

New Delhi

Others

View Details
Company
02 May 2026
Experience Audit Manager

AGGARWAL SAMIR & CO

New Delhi

CA Inter

View Details
Company
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details