counting data from a series
I have from a suvey in a 3 column table, where COL1=survey number,
COL2=question number, and COL3=response, as such:
COL1 COL2 COL3
a Q1 2
b Q1 3
c Q1 1
a Q2 3
b Q2 3
c Q2 1
a Q3 2
b Q3 3
c Q3 1
How can I calculate all the "3" responses for all Q2s?
For example, based on the above sample table, I would expect the formula to
Hope this helps!
In article ...Deleting Data in Sample database Northwind traders
I would like to use the sample database Northwindtraders that comes with the
software for my business but i need to delete all the data from all the
connected templates especially the Inventory so i can enter my own data. Is
this possible? or is thier others like it that don't come with the sample
I don't have months to learn how to use it
Create a brand new blank database. Then import all objects from the Northwind
database into yours. On the import objects screen for tables make sure that
you import "definition only."
I need to backup my data and need to select the path...I am not even sure
where to look for it...Help appreciated
DJE <DJE@discussions.microsoft.com> wrote:
> I need to backup my data and need to select the path...I am not even
> sure where to look for it...Help appreciated
...negative values causing column title problem
How do I get the Column titles x axis lables at he bottom
of the chart field when have negative values
It s friday and this is killing me.
Select the axis
Choose Format>Selected axis
On the Patterns tab, for Tick Mark Labels, select Low
> How do I get the Column titles x axis lables at he bottom
> of the chart field when have negative values
> It s friday and this is killing me.
Excel FAQ, Tips & Book List
hey thanks - boy was thaqt annoying
>Select th...Data Migration Framework Error
Hi All, Im having trouble importing email activites into MS CRM. When
running the migration tool , Im getting the following error in the logs for
every email I've set up as an activity.
I've checked the guids for the owninguser and the objectid (contact), and
they all exist. Im not creating any associated records in the
cdf_ActivityParty table, as I only want to store the link for the "regarding"
item so to speak.
21/10/2004 - 8:43:18 AM -- [ERROR] Failed to migrate object:
21/10/2004 - 8:43:18 AM --
<a...Print Current Page Only Macro
I am trying to come up with a macro with the ability to print th
current page. It has become a big need within my company and will b
a real time saver. Is there a way to search for the active cell an
then print the current page it is in? In other words, by placin
your cursor on the page you want to print, you could then run th
print current page macro
But why don't you sue the print icon in the toolbar. AFAIK this only
prints the current selected sheet(s)
> I am trying to come up with a macro with t...data entry
I want to send a template to a customer which they fill in with ease. here
what i want it to do....any help is appreciated.
Trader Name Operating System Software Version
options e.g. Joe Bloggs XP 18.104.22.168
check box check box
22.214.171.124 check box check box
126.96.36.199 check box check box
188.8.131.52 check box check box
when ...using common data in multiple sapreadsheets
I would like to copy the results from one range of cells
in one worksheet of one workbook, to another cell in
another worksheet in another workbook, can this be done?
Sure if both workbooks are open:
If you paste to one cell, then the copy|paste command will react just like you
did it manually. It'll expand the destination range to be the same shape as the
...Add a goal line to a column chart
I have several column charts which I need to add different goal lines. Any
suggestions? The goal has to be represented as a line and not as a column.
Thanks for your help!
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Brandy" <Brandy @discussions.microsoft.com> wrote in message
>I have several column charts which I need to add different goal lines. Any
> sugg...SELECT large amount of data in a worksheet
I have my mathematical model results in excel format every times I run my
Huge amount of data --10,000 rows, with 10 columns.
Now I like to copy certain portion of data into a new workbook for further
And the data I wish to select is from F10:F10010 to P10:P10010.
I can always select F10, scroll down and select P10010. This is a bit
cumbersome and takes time.
I cannot assign NAME to these data because every time I run my model, my
range of data that I am interested in could differ -- meaning sometimes it
could be ranging from H5:Q5 to H5000:Q5000.
Is that a way for...Re: Comparing Data Need to Include & Exclude
Well i tried it, i cant make it work.
Did you try it to see if it worked??? and you got the Results i need
as shown in list3 ??
What dioes E1 & E2 mean?
Try something like this:
With your data in columns A and B
E1: Missing (or any text other than the Col_B column title)
(Notice the dollar sign ($) plaement in the formula AND that it refers to
the FIRST DATA ITEM in Col_B)
Select the Col_B data from B1 to the end of the list
From the Excel main menu:
Check: Copy to another...Calculating time #3
I know this question has been asked before, but the answers that I have found
do not seem to work for me for some reason. I am probably doing something
wrong. What I need to do is calculate hours worked for the day. I have set
up a spreadsheet to include the following:
C3 is the time in
D3 is the time out
E3 is .5 hours (this is lunch)
F3 is the total number hours worked for the day. The formula I have put in
this cell is: =HOUR(D3-C3)-E3 [this is exactly how the formula is typed in]
Now, if someone put their time in as 7:30 a.m. and their time out at 4:00
Is there a way to get the Business Unit the current user belongs to in the
onLoad JScript on a form?
"Hrvoje" <firstname.lastname@example.org> wrote in message
> Hello everybody,
> Is there a way to get the Business Unit the current user belongs to in the
> onLoad JScript on a form?
> Thank you,
...Charts & Hidden Data
If I hide the row/columns containing the source data of a chart the
respective series disappears from the chart.
Is there any way to hide chart source data without affecting the chart?
In XL2003 (and before) with chart selected: Tools | Options |Chart and
uncheck the box "Plot visible cells only"
In XL 2007: Follow this path: click the chart; use Chart
Tools|Design|Selected Data; look for button
labelled "Hidden and Empty Cells"; complete dialog box as needed.
Bernard V Liengme
remove caps from ema...Using an Object from a Current form for Criteria in a Query
I am using Access 2000.
I have a Command Button on a form that is designed to preview or print that
I use a Pop-Up Dialog Box. The end user will supply 2 pieces of data in this
Dialog Box. This data, together with the Customer ID from the current form.
will provide the 3 necessary pieces of info to pass on to the query, and
eventually the report, that creates the invoice.
I suspect that the "Me." or "Me!" "command" or "action" must be used, but am
not clear about how to use it.
Perhaps someone can give me so...Unhiding Protected Rows and Columns? is it possible?
I have a workbook with a number of worksheets that all interlink.
I have protected a number of cells in one of the sheets.
the problem arrises in that the unprotected cells cannot be hidden or
indeed unhidden when the sheet is protected. Is there a way I can
protect cells whilst still keeping the formatting ability to widen /
hide rows etc.
guilf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25608
View this thread: http://www.excelforum.com/showthread.php?threadid=39...Gridlines on Column Chart
I am trying to create a stacked column chart with gridlines that only appear
for every 2 columns. How can I do this in Excel 2007? All I can find is how
to insert a major gridline between every column.
Format the X axis, on the Axis Options section set 'Interval between
tickmarks' to 2.
Andy Pope, Microsoft MVP - Excel
"SeanF74" <SeanF74@discussions.microsoft.com> wrote in message
> I am trying to create a stacked ...Control for displaying Data
I want to create an active control that will be having a dialog. On this
dialog I want to show a table consisting of set of records. The data to this
table will be coming from the web and will be refreshing again and again.
Could you suggest, which control should I use to have the things done.
I did not find Datagrid control suitable at this place. What are the other
FYI: Iam using VC++ 6.0
THANKS IN ADVANCE,
You can use a list control (listview). But the popular one with a lot
of features is: http://www.codeproject.com/miscctrl/gridctrl.asp
--------------...Time calculations for Scheduled Time vs. Actual Time Worked
I am trying to make a simple schedule worksheet for a manger to use to
calculate the time he schedules an employee to clock in and out and what it
will cost him in regards to his allocated budget and then to be able to
compare it after the job is completed. BUT time calculations have thrown me
for loop and I am stuck for hours on trying to calculate time fields.
PLEASE DEAR GOD can someone help me.
Below is a simple example of my worksheet.
A2 (Time IN) = 1:00 PM
A3 (Time OUT) = 5:00 PM
A4 (Time Worked) = 4:00 (h:mm format) Formula A3...Time line in excel graph
I need a vertical line in my graph to show that the graph information after
the line is the future predicted outcomes. I've tried countless different
options and cant seem to find how to do this!
There are various ways of addressing this problem.
See the following for examples of adding lines to charts.
> I need a vertical line in my graph to show that the graph information after
> th...accidentally entered #'s as %s
i have a hugh spread sheet. the numbers were accidentally
entered as percentages. how can i get rid of the
percentage formatting w/o the decimal point changing position.
ie. i want -0.251% to read -.251. when i undo the
percentage formatting it ='s -0.002514568.
sorry:( i know it's a basic question, but i can figure
this out for the life of me.
put 100 in a cell somewhere, and copy this cell, select the region o
your values, and paste special, multiply, and reformat to numbe
duane's...Variable Column Lookup
I have three columns to the left column K each has a header with the year
number. 2008, 2009 and 2010. Underneath each of the three columns I have
numerical data. On the same header row I have a drop down list in K1. So
when I pick 2009, I want the calculations in K2, K3 downward to use the
corresponding data in column that has the matching year.
2008 2009 2010 2009 (drop down)
2 3 6 3*10
If I choose the drop down of 2008 then the formula should be 2*10
If I choose the drop down of 2010 then the formula should be 6*10
The actual formula is much more complic...Stacked Column Charting
Has anyone tried the following?
From the data set below, I would like to have the data to the right of the
Hrs. avail data be a stacked bar for each day. Along with this the Hrs. avail
data would be a bar next to the remaing row of data.
I tried placing the Hrs. avail on its own axis but that did not seem to work.
In short I want to show the number of hours availabe in a day and actual
hours used by the verious other data.
Day Hrs. avail EM's PM's Cal's Projects Other Idle
1 14 4 2.5 2 4 0 1.5
2 14 5 1 1 3 0 4
3 14 0 2 2 6 0 4
4 7 2 0 0 3 0 2
5 14 2 0 0 10 0...excel 2004 column sorting
Operating System: Mac OS X 10.4 (Tiger)
I've read up a bit on others' sorting issues, but haven't come across exactly the same problem as mine. I used to be able to sort the info in one column and the corresponding info in the other columns would sort along with whichever column I chose at the first. Now, my corresponding columns don't sort along with my first sort, resulting in inaccurate info. Also, the workbook I am working with contains macros; the workbook contained macros when I first began using using it, i.e. when sorting was no prob....insert number in column #2
I have a column with threedigits for telephone extensions. I want to insert
a digit before the three throughout the column as the extension has been
increased to 4 digits. Any easy way.../
In a blank column (say column H), enter
H1: =1 & A1
or, if you want them as numbers rather than text:
copy down as far as necessary. Select the column and copy it. Select the
original column and choose Edit/Paste Special/Values.
In article <Om6vrJpEIHA.3548@TK2MSFTNGP06.phx.gbl>,
"afdmello" <email@example.com> wrote: