Search results for query: *

Is it possible to aggregate data in Excel? I now have a table which displays: Name Paper ImpactFactor Rick Sun 1 James Star 3 Tom Guardian 6 Rick Independent 9 I want to create another spread sheet that displays Name and ImpactFactor, however, in the case where a person is...

Cheers.

This is actually the first time I've ever used Excel, so I'm as much a novice as the person who will be using it. My aim is automate things as much as possible. I was hoping to apply the formula to the whole column in the same way you might with column validation. I dont want to rely on the...

I know about the fill handle method of doing this i.e. selecting the cell and double clicking the "Fill Handle", however, this requires that the user of the spreadsheet also knows about this functionality...

I have looked - and I cant find the solution, otherwise I wouldnt be asking :)

I have the following formula on each row =SUM(N3,E3,G3,I3,K3) Is there a more gneric way of creating this formular so that it can be applied to the how column, so that I would get the equiv of: =SUM(N2,E2,G2,I2,K2) =SUM(N3,E3,G3,I3,K3) =SUM(N4,E4,G4,I4,K4) etc??

Sorted the delimination issue. Right.... In my first sheet I now have: SHEET 1 A B C Name Paper Impact Factor rick sun John sun frank Mirror Ted Telegraph The Paper columns values can be selected using a dropdown - populated from...

Cheer!! I'm considering moving the locationID to the review table. The data will no longer be normalised - but it will probably be faster??? What would you do? Keep the data normalised and take the approach you suggested, or move the locationID??

I've 4 months into developing my website. All was going well... but I've hit a brick wall. I have different types of content, all of which is quite different. The data for each type is stored in its own table.. i.e. artist table, gig table, music table. My site allows this content to be...

i.e.

I am writing a Newsletter class that will send bulk emails from my website to subscribed members. In my opinion, this should run in its own thread. Should I place the thread code within the newsletter class, or place this around the call to the class?

Re: =vlookup(b2,Sheet2!$A$1:$B$10,2,0) Is it possible to make this work for the whole column?

I'm getting the error, List must be a deliminated list!! Am I being dumb (yes!!)

My mistake - the values should be the same!! Cheers... You are a star. Okay, in my first table, is it possible for the user to be able to select the values in the Paper column from a drop down populated from the paper lookup table i.e The user enters a new row in the first table for somebody...

Right it looks like VLookup is what I after. Essentially I have a table like this@ Name Paper ImpactFactor + lots of other columns rick sun 10 John sun 11 frank Mirror 7 Ted Telegraph 9 I then have a table of papers: Paper Impact Sun 10...

Look up tables? I have a sheet which I would like to populate automatically from a couple of look up tables. Are lookup tables possible? How do I approach this?

Better yet, instead of returning an Employee object how about returning a super class of Principle continaing a modified Identity object that contained the additional user info???

I have a common task that all my applications use. We use kerberos to log the user in, but get additional user information from SQL. I was therefore thinking that a web service would be ideal for this. Pass a string name value and return the associated data. How easy would it be to get the...

I want to create a set of treenodes labeled a to z rather than manually create each node, can I iterate A-Z?

Aye - just found that myself!!! Thanks for your time though.