Excel formula help !

MehulLakhani · 27 May 2010 at 19:37

Hi All

I have been asked to work on a spreadsheet at work, and need some help ! Essentially, I need to count up the number of unique address from a spreadsheet, like the one below.

So what I need is a forumla that will count the number of unique entries in one column only, if that makes sense, to work out the number of househols that we need to mailshot. There are blank rows inbetween , and I need to make sure that they are not counted.

Any forumla ideas gratefully recieved !

Thanks

mehul

MehulLakhani · 27 May 2010 at 19:48

Oh, by the way, forgot to mention - there are approx 3000 addresses in the list !

MehulLakhani · 27 May 2010 at 21:09

I have looked into VLOOKUP- but looks like I would need to create a formula for each address ? Unless I am reading the instructions wrong ?

With 3000 addresses , that is going to be difficult !

Any other ideas ?

R

Mehul

MehulLakhani · 27 May 2010 at 21:21

PeterNem said:
Use the advanced filter to create unique addresses in another column. Then use a CountIf forumula against each of these using the original column of data as the range to tell you how many of each you have.

Thank you ! I did this and it worked perfectly !

R

Mehul