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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 09:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com