Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel function
Hi,
I am trying to see if I can find out if a value (number) occurs more than one time in a very large excel sheet is there some way to do this? -- Trudy ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel function
=COUNTIF(A:A,5)1
for number 5, adapt to fit the range and the number Don't know why the "This post is a suggestion for Microsoft" was necessary though -- Regards, Peo Sjoblom "Trudyc" wrote in message ... Hi, I am trying to see if I can find out if a value (number) occurs more than one time in a very large excel sheet is there some way to do this? -- Trudy ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel function
Hi,
There's already more than 1 way to do that, like this for example:- =COUNTIF(A1:B1000,1)1 Mike "Trudyc" wrote: Hi, I am trying to see if I can find out if a value (number) occurs more than one time in a very large excel sheet is there some way to do this? -- Trudy ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel function
Check out this site:
http://www.cpearson.com/excel/Duplicates.aspx Regards, Ryan-- -- RyGuy "Peo Sjoblom" wrote: =COUNTIF(A:A,5)1 for number 5, adapt to fit the range and the number Don't know why the "This post is a suggestion for Microsoft" was necessary though -- Regards, Peo Sjoblom "Trudyc" wrote in message ... Hi, I am trying to see if I can find out if a value (number) occurs more than one time in a very large excel sheet is there some way to do this? -- Trudy ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel function
Huh?
-- Regards, Peo Sjoblom "ryguy7272" wrote in message ... Check out this site: http://www.cpearson.com/excel/Duplicates.aspx Regards, Ryan-- -- RyGuy "Peo Sjoblom" wrote: =COUNTIF(A:A,5)1 for number 5, adapt to fit the range and the number Don't know why the "This post is a suggestion for Microsoft" was necessary though -- Regards, Peo Sjoblom "Trudyc" wrote in message ... Hi, I am trying to see if I can find out if a value (number) occurs more than one time in a very large excel sheet is there some way to do this? -- Trudy ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
Excel 2002: Auto Sum function not working in large Excel file | Excel Discussion (Misc queries) | |||
challenge! javascript function into excel function | Excel Worksheet Functions | |||
Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions |