Counting unique visitors by ward, counting monthly visits by status, editing existing workbook

JaxV · #7 11-06-2014, 11:14 AM

As stated in the OP:

Firstly, I am attempting to make a count of visitors to a site by postcode/ward. At the moment, I have Sheet 1 column A to enter postcode. I have on another sheet (same workbook) 3 coloums of all the postcodes within the 3 wards I want to check against. In sheet 1, I have added a column B using drop down boxes to manually choose the ward after searching for the postcode in sheet 2 and noting which column this falls under.

Now, this is fine for new entries, but I have over 600 unique visitors already on the worksheet.

Is there a way to get column B to auto check against sheet 2 and auto-enter the ward based on which column the postcode is found under on sheet 2?

So, something that would like;

User manually enters postcode in sheet 1 cell A1
If postcode entered matches entry in sheet2 column A, enter "ward A" in sheet1 cell B1
If postcode entered matches entry in sheet2 column B, enter "ward B" in sheet 1 cell B1
If postcode entered matches entry in sheet2 column C, enter "ward C" in sheet 1 cell B1
If postcode entered does NOT match any entry in sheet2, enter "other" in sheet 1 cell B1

And so on from sheet1 cell A1 down to A600 and beyond for new entries.

I attached a sample in the second post.

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting colours	not_dave	Excel	1	12-29-2013 01:27 AM
various data needs counting	apples	Excel	2	09-16-2012 04:52 AM
Counting Formula	Karen615	Excel	6	06-20-2011 07:19 PM
Counting Colors	g48dd	Excel	2	03-13-2011 09:28 PM
Counting Weeks	leroytrolley	Excel	1	08-18-2008 11:12 AM