|
Creating summary table from detail table
Using Win XP and Excel 2002
This is a simplification of a problem that I'm trying to solve...
I have a Detail Table as shown in ...
www.gillandroy.com/odds/excel/summarytable
from this table I want to create a Summary Table - also shown
in the above link.
The Detail Table is actually created line by line from some
Access VBA and can contain a variable numbers of lines.
There may ...
|
3 |
18.09.2006 07:57:36 |
|
|
Editing scenarios
Hello.....
I did post this question a few days ago but didn't get a reply so I'm really
hoping somebody can help me......
I have created 3 scenarios, all containing details of various bank loans,
interest rates etc.
I have produced the scenario summary report and it worked fine, however, I
have now gone to one of the scenarios and changed some of the figures. When
I then
reprod...
|
3 |
18.09.2006 07:56:02 |
|
|
Pivot table grouping
I'm trying to group columns in a pivot table according to
4-4.49
4.50 - 4.99
5.0 - 5.49
5.50 - 6
In the grouping box I enter 4 as my start at and 6 as my end, with .49 as
the By. Doing so causes the following column heads to appear:
4-4.49
4.49-4.98
4.98-5.47
5.47-5.96
I'm sure it's something obvious that I'm missing. Any ideas?
Much appreciated,
Susan
...
|
7 |
18.09.2006 07:52:35 |
|
|
Date Wont Change in Excel??!
Hi, I have been trying to formate a list of cells to display in the
dd/mmm/yy format when you type a date in the 9/6/04 format, I have
tried applying this as a formula and also right clicking and changing
the format date to dd/mmm/yy and it wont change. In the greyed bar it
just leaves it as what ever i have typed, and if you click on different
formats in the date list it still stays the sam...
|
2 |
18.09.2006 06:46:01 |
|
|
Function Arguments
Is there any way of having more than one scenario in an arguement so that the
"TRUE" answer will depend on more than one "IF"...
|
5 |
18.09.2006 02:05:26 |
|
|
one cell does not reflect a sum
cell b 87 has the formula =sum(c87:n87); cell c87 has the formula
=sum(c88:c99). both cells are reflecting a sum of "0". b87 s/b $7227.33 and
cell c87 s/b $343. Why are these cells not providing the right sums?...
|
5 |
18.09.2006 01:56:08 |
|
|
Excel: have add'l rows entered in sheet 1 always show up in sheet
Using Excel for a database of names & addr: want to use the 2nd sheet of same
workbook to track contributions, so want additions to 1st sheet to show up in
2nd sheet in the correct alpha location.
Thanks!...
|
1 |
18.09.2006 00:33:01 |
|
|
IF or Lookup
I am trying to tell the cell to display the proper Quarter for the Month typed.
Jan-Mar = Q1
Apr-Jun = Q2
Jul-Sep = Q3
Oct-Dec = Q4
The probelm is IF functions only allow 7 itmes to be added & I would need at
least 8 to properly work. and I tried Lookup & haven't been able to properly
work either.
Any suggestions?...
|
3 |
17.09.2006 23:52:02 |
|
|
Not listing more than a range of rows
I have two sheets, one has my equipment database and the other is the results
"Quote sheet". in my Quote sheet I am using the:
=IF(ROW()-1>MAX('Equip Database'!A:A),"",ROW()-7)
in the first colum and row 8 (A8), then use the:
=IF($A8="","",VLOOKUP($A8,'Equip Database'!A7:L1000,COLUMN(),0))
in the rest of the cells on the same row (B8, C8, D8 etc.)
if I enter a qty in the Equ...
|
3 |
17.09.2006 23:43:01 |
|
|
trying to add up disparate transaction data
Hi All,
This is my first post to the Excel help forum, so hopefully I am at the
right place. I was perusing it, and it seemed so!
I am a small biz owner and have uploaded a bunch of data out of my Point of
Sales system, which is based on an Oracle db. The data is proprietary and 'I
get what I get'.
I have a bunch of transaction data sorted by each individual product that I
sold,...
|
3 |
17.09.2006 22:59:54 |
|
|
Adding rows?
Hello everyone!
I have a spreadsheet full of data (560x15) and I would like to add one new
row bellow each one existing (1120x15).
Can I do it? (I can manually select rows one by one having CTRL pressed and
then insert Insert Row, but it takes a lot...)
Thanks
...
|
4 |
17.09.2006 21:48:11 |
|
|
Projected annual percentage return on investment question.
--
JJB...
|
1 |
17.09.2006 20:47:02 |
|
|
Help with Excel
There are 100 students and their grades are calculated by (example:
factor (5.9) x score (3). The factors range from 5.9 to 6.9 and the
score from 1-5. The factor could be based on analytical writing,
Quantative, Verbal, so on. There must be a way to calculate these
scores with a lookup function instead of typing in a formula like the
example above.
Another example: Quantative factor: 6....
|
4 |
17.09.2006 20:35:02 |
|
|
Convert 2 digit month to 4 digit years and months
How can i convert a 2 digit number of months to a four digit showing years
and months?
35 = 0211
24 = 0200
05 = 0005
I have a series of numbers containg months, like 35. I want it to come out
to years and months 0211. 35 months is 2 years and 11 months. I want it to
show 0211.
Thanks,...
|
3 |
17.09.2006 20:33:02 |
|
|
Find and Count Frequency of Numeric Value in Non-Contiguous Rows
Hi All,
My Numeric Data spans 61 columns and many rows. The Data comprises Numeric
Values and Numeric Labels. The Numeric Labels and Numeric Values are in 2
separate consecutive rows of data, a blank row and then a new set of Numeric
Labels and Values in 2 separate consecutive rows, a blank row etc.
I would like the total count of a specific Numeric Value (will vary). My Data
spans row...
|
3 |
17.09.2006 20:17:47 |
|
|
Match duplicate data in 2 columns
I am trying to find a faster way to complete my variance reports. Up until
this time I have been manually marking out the duplicates and at times there
could be 30 or more pages of information. Too time consuming.
Recently, I was given the below formula to format a worksheet with 2 columns
of numbers and I need to highlight the duplicate entries and then delete the
highlighted numbers ...
|
2 |
17.09.2006 20:15:04 |
|
|
FIND PERCENTAGE AMOUNT FOR 5 DEPT. FROM ONE WHOLE AMT XCL
I AM TRYING TO SET UP A FORMULA ON BREAKDOWN PERCENTAG, EXAMPLE
4550.60 IS THE FU LL AMOUNT , BREAKDOWN 20% TO DIV. ONE, 67% TO DIV2
ETC. HOW DO I SET UP EACH CELL FROM ONE AMOUNT 4550.60...
|
2 |
17.09.2006 18:11:20 |
|
|
Shading alternate "groups" of rows?
I know how to use e.g. MOD functions to conditionally format alternate rows
with shading, but what is the best way to do this if your data is in groups
so that you rather than have alternate rows of grey and white shading, you
might have 5 items in one group that you want grey, then 3 in white, then 7
of grey etc, based on the value in a cell
eg
Column 1, Column 2
[GREY SHADING]ca...
|
7 |
17.09.2006 14:43:02 |
|
|
Progressive numbering of Excel worksheets
Is it possible to print multiple copies of an Excel worksheet with progressive
numbers...
|
2 |
17.09.2006 14:20:06 |
|
|
Macro Modification - Bob Philips Are You Out There ?
I use this macro on one of my workbooks and it worked awesome - it creates
tables from selected worksheets and names them according to a list of names.
Asuming that the list is named SheetNames, then
Sub maketable2()
Dim SheetList As Sheets
Dim RngToName As Range
Dim LastRow As Long
Dim LastCol As Long
Dim NameToUse As String
Dim sh As Worksheet
Dim i As ...
|
3 |
17.09.2006 12:56:02 |
|
|
TimeSheet! Working PM to AM
I'm making a timesheet and it's working good.
But I can't work out how to calculate mu working time from ex: 15:00 to
18:30 lunchbreak and then 19:20 to 02:00. The calculated anser I get is
"-13.83"
I hope somebody can help me
Thanx...
|
7 |
17.09.2006 12:51:59 |
|
|
Make a cell show the name of the sheet tab
Is there a formula to make cell A5 show the name of the tab for that sheet
automatically?
Thank you for any help...
|
6 |
17.09.2006 12:29:03 |
|
|
If statement
I need a statement that (+IF (j2) < today etc) that if this is true will copy
that cell from one sheet to another sheet can anyone help please....
|
2 |
17.09.2006 11:49:46 |
|
|
Cells are selected but aren't displayed as selected
Hi,
Usually when I select a block of cells, they are highlighted to show that
they are selected. For some unknown reason they now won't show the
highlighting even though they are selected. I have obviously clicked
somewhere I shouldn't have and turned it off!
Can anybody please tell me how to turn the highlighting ON again!
...
|
1 |
17.09.2006 10:34:01 |
|
|
can a1 reference style and r1c1 style be used in same formula?
I need to use a formula like sum(c1.c5)/r[4]c[-1].
Since as and when I add any rows between row 1 & 5 the formula should
automatically change to sum(c1.c6) but the cell as a divison should always be
the value in the cell 4 rows down in B column....
|
2 |
17.09.2006 09:58:19 |