| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of different items in an entire column without knowing if some of the cells are blank
Hi all:
i posted similar question before but i would like to expand on it. i have marks(J1,J2,J3,.....) that might repeat in column A, but i would not know the extent of how many cells in the entire column (65536)cells will have marks in them. on some projects i might have every cell of that column has a mark in it,and on some other projects i might have marks in 10000 cells of that column. it depends on the project. is there a macro that will tell me how many different marks in that column, becuse that number will determine the number of my loops. the way the marks are in column A is J1 J1 J1 .. .. .. J2 J2 J2 J2 .. .. J3 J3 .. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Knowing the number | Excel Discussion (Misc queries) | |||
| How do I count the items in one column if another column is blank | Excel Worksheet Functions | |||
| how to calculate the number of non blank cells from any column? | Excel Worksheet Functions | |||
| Easiest way to delete blank cells in column (not entire row) | Excel Discussion (Misc queries) | |||
| Delete Entire Row If Column C is Blank | Excel Programming | |||
Threaded Mode
