|
| 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
June 14th, 2009, 11:51 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
repeated numbers or value
I have data in 45 coulmns and 3000 rows. I want to know which numbers are
repeated in each row or coulmn.Please help me to solve this problem. 
|
|
#2
June 14th, 2009, 02:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
repeated numbers or value
If you have an index of the numbers you need to check then use the below
formula to return the number of instances. The below will return the number of instances 100 is present from columns A to J. =COUNTIF(A:J,100) If this post helps click Yes --------------- Jacob Skaria "soodddddddddd" wrote: I have data in 45 coulmns and 3000 rows. I want to know which numbers are repeated in each row or coulmn.Please help me to solve this problem.
|
|
#3
June 15th, 2009, 03:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
repeated numbers or value
how does this work please explain in detail as i have little working
experience in excel. I put this formula in a blank cell but no result came. I have CDRs of multiple numbers in excel sheet and I want to know which number is commonly used by different users. The data I have in this form e.g. a1 9418745645, A212345678,a3236598654.................. B1 12345678, etc. There are lots of telephone numbers in different columns and rows some of theme may be common numbers. I want to identify all those repeated numbers which are in coulmn A to Z. Please help me to solve this problem and please explain step by step in deatil as I am not good computer literate. I shall be highly grateful to you. "Jacob Skaria" wrote: If you have an index of the numbers you need to check then use the below formula to return the number of instances. The below will return the number of instances 100 is present from columns A to J. =COUNTIF(A:J,100) If this post helps click Yes --------------- Jacob Skaria "soodddddddddd" wrote: I have data in 45 coulmns and 3000 rows. I want to know which numbers are repeated in each row or coulmn.Please help me to solve this problem.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
