relational

I wonder if someone can help please? I'm trying to create a Relational database to record sightings I have made of railway locomotives on different dates and at different places. I've worked my way thro' some Youtube videos and also looked into how some other relational databases are related...

Hi, I've searched multiple different queries with google about how to accomplish this with excel but have had no luck. I have a question on a survey which reads: Q1. What advice was given during call? I plan on grouping the responses into themes/categories which I have found out how to...

I have a table that is acts functionally as a database. Each line is a customer/project and each column is a checkpoint in my workflow for the customer/project. What i would like to do is have a second table of tasks or To-Dos and link the tables by the customer name. I would like to be able...

Hi, I am using a relational star scheme with fact and dimension tables (facts containing sales, product table contains product details etc.). Based on that I would like to use a pivot table that shows all products in rows or columns even if there is no record in the underlying fact table for...

Hi There, I'm sure I must be over thinking what is a simple problem but the solution I came up with originally is a bit of a work around! Basically I need a formula for calling up the row in which the previous value in column A resides. The solutions should look like the those in column B...

Hello: can someone help me with VBA Code to do the following: On Sheet 2, after an entry is made in Cell P an event is triggered that will copy cells P and Q (in the same row) only if Cell C in that row = "Task Summary" (note on sheet 2 there is a log no. in cell A) then on Sheet 1 this info...

Hi Everyone, I am having problems finding information around this (perhaps I am not searching with the right keywords), but it seems like it would be a common function of PowerPivot so I came here. I'd like to create a relationship where I can find a value in table A only when it is not...

I have a mapping of persons to groups, in the form: <table border="0" cellpadding="0" cellspacing="0" width="128"><colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody><tr style="height:12.75pt"...

This is a bit complicated...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Basically I have recaps (excel based reports) which run every wednesday. They are typically approx 1000 rows x 70 columns. One of the columns is usually "ID#" which...

Hi all, If anyone can help me I'd be very grateful. I'm trying to link a lookup formula to another cell in the name range section, formula is.... =if(iserror(vlookup($b$4,L4,3,false)),0,(vlookup($b$4,L4,3,false))) Where B4 is the week number and L4 contains the name range to look up...