Hi all
Is it possible to run a macro to count how many times number 28 is found within this rangethanks in advancePlease Login or Register to view this content.
steve
Hi all
Is it possible to run a macro to count how many times number 28 is found within this rangethanks in advancePlease Login or Register to view this content.
steve
Last edited by gadjit; 10-07-2009 at 10:31 AM.
Use the Countif function.
=COUNTIF(A2:F1443,28)
Use MODE function to find the most frequently occuring number.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks