Hi all,
I have included an attachment to this thread. I have a master tab, which contains all the contact information for a database.
I want to auto index each contact to other tabs (US, Asia, Europe) based on the geographical location (column D). Seems my formula shown in the US tab correctly is showing the number of US names I aim to have, but it is only the first US email address repeatedly.
Would really appreciate if someone can help me with this.
Thanks!
What's the end goal of this? Why not just use Autofilter?
The reason I ask is that the easiest way of doing this that I can think of is a batch process and not continual
Hello
In A4 and copy down try this ARRAY formula.
Formula:
Please Login or Register to view this content.
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
FWIW I'd do it with a Pivot Table
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks