If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
i WANT TO CALCULATE THE NO IN A SINGLE COLUMN WHICH ARE NOT SAME.
pls tell me i am using excel and i have a problem, first i am working on
worksheet and in a single column i have 200 entries. It contains many nos. same. e.g. 16533,16533...... and 16622... and 16223.... now i want to calculate only the nos. (16533, 166622,16223,..................) means if the one no. comes again, ignore the no. do not calculate. 20 different nos.(16533,16533,16622..........) in 200 entries. no i want to answer that it should be 20. not 200. pls tell me how and what formula i used to do this. |
#2
|
|||
|
|||
i WANT TO CALCULATE THE NO IN A SINGLE COLUMN WHICH ARE NOT SAME.
"thakur" wrote in message
... pls tell me i am using excel and i have a problem, first i am working on worksheet and in a single column i have 200 entries. It contains many nos. same. e.g. 16533,16533...... and 16622... and 16223.... now i want to calculate only the nos. (16533, 166622,16223,..................) means if the one no. comes again, ignore the no. do not calculate. 20 different nos.(16533,16533,16622..........) in 200 entries. no i want to answer that it should be 20. not 200. pls tell me how and what formula i used to do this. Take a look here for information about duplicates (counting, highlighting, etc.): http://www.cpearson.com/excel/Duplicates.aspx |
Thread Tools | |
Display Modes | |
|
|