hello
having some trouble or rather logic approach
i have 3 drop down list (region, district, branch), all dependent on on another *although im having some trouble showing branch*
-i would like:
in column E *see attached* for all zip codes to show for the corresponding branches
i.e. chicago-milwaukee is a district, if i select D "chicago"...colum N *red cell - formula not working* shows all zip codes, but when all zip codes have been shown for chicago, i want it to show milwaukee
formula in column E:
{=INDEX(Zip,SMALL(IF(_Branch='Master assignment sheet'!$D15,ROW(_Branch)-ROW(BranchStart)+1),COUNTIF('Master assignment sheet'!$E$15:$E15,$E15)),3)}
that is the logic errror im having....can someone pls help!!!!
Last edited by jw01; 01-10-2012 at 11:15 AM.
any suggestions guys!!?? pls and thx u
Replace COUNTIF with ROWS,
=INDEX(Zip,SMALL(IF(_Branch=D$15,ROW(_Branch)-ROW(BranchStart)+1),ROWS(E$15:E15)),3)
Note: Your file has more 32000 rows data, So Array formula will slow down the calculation.
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
hello haseeb
thxs alot for your help.
question, how can i make it on the last row ie. if chicago has listed all the possible zip code, so it to list milwaukee as it is paried with it inthe district (chicago-milwaukee)? can u pls help....and i cant seem to get the branch drop down to be dependent or at least show both the branch. let me know . thank you.
would it be possible to write a macro for it to dump the zip codes for the selected district by showing the branch? pls and thx u for your help
Hello Jw01,
I don't know about VBA. It is better to move your thread to Programming section. Send a request to a moderator to move it to programming section.
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
Haseeb
thx u so much.
do you know how i can fix the branch issue taht im having with the drop down?
currently in column D, if i select a district, it only shows on branch i.e. new york-long island...it show new york. not both.
can u possible help? thx u sir!
You have already District & Branches in Col_M:N so define a name as Dist on refers to,
Then in the DV list use =Dist=INDEX('Zip codes'!$N:$N,MATCH('Master assignment sheet'!$C$15,'Zip codes'!$M:$M,0)):INDEX('Zip codes'!$N:$N,MATCH('Master assignment sheet'!$C$15,'Zip codes'!$M:$M,0)+COUNTIF('Zip codes'!$M:$M,'Master assignment sheet'!$C$15)-1)
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
hello haseeb
sory for the confusion
Column D should be the branches that show in column C
i.e.
i just dont get the formula thxs
Last edited by jw01; 01-10-2012 at 11:16 AM.
See the attached for dependent DV. You can add/delete region, dist, entries etc...
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks