relational

  1. W

    Stuck with Relational Database

    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...
  2. G

    Data Analysis - Related Open Ended Questions with a yes/no response

    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...
  3. kpasa

    Relational Database for linking data in Excel and a userform

    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...
  4. K

    Show blank combinations in Pivot Table based on MS SQL

    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...
  5. S

    Relative Postion of previous value in array

    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...
  6. R

    Macro to copy cells in sh 2 triggered by an entry in one of them and pasted in sh1 into a row with same log no.

    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...
  7. Z

    Creating a 2-way relationship between two tables in PowerPivot

    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...
  8. S

    SUMPRODUCT using relational reference?

    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"...
  9. L

    Help with Excel VBA project using a folder of text files as relational database

    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...
  10. E

    Relational Lookup

    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...

Some videos you may like

This Week's Hot Topics

Top