Excel Question

cooperguy

I posted up an excel question here before and ye were a great help. Im hoping ye might be able to help out again! Iv tried to figure this out myself but with no luck.

Here's my problem. I have a table between F2 and FF80. In this table I have serial numbers in various random cells and more of these cells are blank. These serial numbers can also be repeated a number of times throughout the table. What I want to be able to do is count how many unique serial numbers are in the table and display that value in a cell.

Any help you could give would get me out of a hole!! Thanks.

majestic0110

Hi CooperGuy, I hope you are well. I am no excel pro myself but I did a quick google for you and came up with this :

here

I hope this is useful, it seems to be a possible solution !

cooperguy

My problem with that solution is that it only seems to work on one column. It wont work over multiple rows and columns at the same time

majestic0110

cooperguy wrote: »

My problem with that solution is that it only seems to work on one column. It wont work over multiple rows and columns at the same time

My apologies, I misread your query! I am not sure how well you know macros but take a look at this thread I found, I think it will help:

here

mark renton

hey - cool site majestic

majestic0110

Cheers, I find it useful!

cooperguy

Thanks for the help. I know VERY little about macros but ill give it a shot.

majestic0110

Great, if you need further help don't hesitate to ask!