Fellow Freelancer.com-er Kher78 built this lovely sheet for us but it needs some tweaks:
Accessibility codes are coming through incorrectly. Here's what we need for output from the Churches table, listed by column letter:
L = if "yes" include "1", if "Partially" include 1 but 1 wrapped with the Special Conditions rule you made.
(Ignore columns N-R)
S - if "1" include "6"
T - if "1" include "2"
U - if "1" include "3"
V - if "1" include "4"
W - if "1" include "5"
(For all, if cell includes "0", include nothing)
If set up correctly, the first church, "Abbotsford, BC - Gateway Community CRC" should be "1 3 4 6" with the numbers in order from smallest to largest.
I'm a computer engineer from Turkey. As part of my work at Flarion (later acquired by Qualcomm) I was programming 4G base stations in C & C++. For the last 15 years I have been working as a programmer and project manager.
I have a MS degree from Northeastern University, Boston, a BS degree from Boğaziçi University, Istanbul.
I am having lot experience working in excel, worked in 46 major projects in excel only even made some of project to MNC company's too which is working live and delivering results too. In comparison to those i believe i can deliver the required results.