Sitemap

Amicuk Programming Answers

Using Numbers to sort terms rather than figures or numbers

-0001-11-30   Views:0

Advertisement

Hi folks, I am new to numbers and need a hand. I have a large table of data including company names, expertise, sector experience etc. I am trying to write a formula so that colleagues can check boxes in 2 smaller tables (expertise and sector experie

Hi folks,
I am new to numbers and need a hand. I have a large table of data including company names, expertise, sector experience etc. I am trying to write a formula so that colleagues can check boxes in 2 smaller tables (expertise and sector experience) to produce a list of all the companies that operate in those spaces and then contact them. So, in table 1, I have headings -
Company Name
Company Registration Number
Company Contact
Contact Telephone
Contact Email
Website
Capability Statement
Certifications
Turnover for last 3 years
Insurance Levels
Sector Experience
GB Geographical Experience
Non UK Geographical Experience
Main sector focus
Type
Products/Services
Reference Projects
Other Points of Interest
in table 2, I have check boxes and "sector experience" (all the terms from the same column in table 1 e.g. airports, rail, healthcare and so on)
in table 3, I have check boxes and main sector focus (again, all the terms from column of same name in table 1 e.g. civil engineering, fit out, concrete etc.)
What I would like to happen is, if a colleague checks boxes in tables 2 and 3, table 4 will pull company names and contact details through to the 4th table using info from table 1.
1st off, is this do-able and if so how do I go about doing it?

The replay answer
Advertisement
I would add the two tables as you described AND add two columns to your main table, then use the "Reorganize Panel" to filter the list.
To set this up add the two table for the check boxes:
I gave these table names:
- "Sector Experience"
- "Main Sector Focus"
then added some of the names you provided and set the second column to be formatted as check boxes
Then I added a new column in the main table (highlighted light green) titling those columns the same name with "Filter" at the end
Now enter the formula:
C2=IFERROR(VLOOKUP(B2,Sector Experience :: A:B, 2, 0), "")
select C2 and fill down as needed (I reordered the columns for viewing convenience... move the columns as needed later)
E2=IFERROR(VLOOKUP(D2,Main Sector Focus :: A:B, 2, 0), "")
select E2 and fill down as needed
Now enter names in the vaious columns and check some boxes, then select the main table and open the reorganize panel by selecting the menu item "Table > Show Reorganize Panel":

Go to See the other 9 answers

Hot
I have been trying for the last couple of days to upload a couple of new MobilMe Galleries to my account. The first 4 galleries worked fine, then a few days later I cannot get anything to publish. Aperture appears to be making progress as the "clock& [More]
Did Apple change the printing framework somehow in this recent update? All the computers in our office now cannot print properly to our Riso HC5500 printer. The same problem also with our Ricoh printer, which would suggest that something in the syste [More]
HI there, i purchased CS5 Photoshop back in 2010, and had to format my mac.  Now i need to download my CS5 again, but cannot find the download files.  Where can i find the download of CS5? I have my serial code but cannot find the download.Downloadin [More]
Im trying to bring 4 years worth of buisness contacts from Outlook (express?) on my toshiba notebook into my new macbook pro's apple mail or entourage programs, at least to my address book! I have been on the phone 3 times to mac support but none of [More]
time machine_ can I get it to just back up 1 area of my computer and not the entire network? I did not originally set this thing up and know nothing about it but I find that it fills up very quickly (1TB) and then starts dumping the earliest stuff. I [More]
Hi, What are the differences of repair permissions from Applications/utility/disk utility and from system DVD? only special permission? i think is better do it from system because is more upgrade. what do you think about?Most of the time what Malcolm [More]
Hey folks I know this question is a no brainer.. but check this out it's quite weird... so I was on tinypic.com trying to upload an image... and normally i have all my stuff listed by "last modified" because I do a lot of changes to whatever it [More]
I used to be able to look at examples of Flash, but I can't find anything on the Adobe site. Is there a Flash gallery/showcase anywhere?In addition, there is Adobe's "customer showcase", where you can choose Flash Professional as the product to [More]
Hello Why does photoshop lose a lot of quality when you save something in Png ? ( web intended ).. Even if i go through the "save for the web " or not, the result is always sloppy... I save Png-24, with transparency and interlaced. like always. [More]
Hi, Can someone tell me how to proceed with the Newyear once signoff has happened for a particular year. For example, if we have completed sign off of organisation in 2008, how to proceed with process control during the year 2009. Tnx and rgds Subhas [More]