|
Analysis of data
Hello
I have 52 sheets in the same workbook.
Sheet 51 is a summary sheet, sheets 1 - 50 are detail sheets.
I would like sheet 52 to be an analysis sheet.
In the top corner of sheet 52 I would like to be able to put a code
reference on and below it, it then lists all of the sheets that contain that
code and what value the codes has next to it.
What is the easiest way of doing this?
...
|
2 |
22.09.2006 13:31:01 |
|
|
How do I update links from a file that hasn't yet been updated?
I am currently working for a bank. I have several branches entering
information that is linked and collected in one district file. Then several
district files are linked and collected at the division level. My question
is: How do I get the current data from the branch level to show up at the
division level if the district file has not been opened and saved with the
updated information?...
|
1 |
22.09.2006 13:28:01 |
|
|
Combining two reports into one
Report 1
Prod a 7 am - 10 am
Prod b 10 am - 11 am
Prod a 11 am - 3 pm
Report 2
Prod a, type 1
Prod a, type 2
Prod a, type 3
Prod b, type 1
Prod a, type 1
Report 3 (combines hours, delay, and wet waste from report 1 and the
specifics of report 2)
Prod a, type 1, 7 am - 10 am
Prod a, type 2
Prod a, type 3
Prod b, type 1, 10 am - 11 am
Prod a, type 1, 11 am - 3 pm
Is there a...
|
1 |
22.09.2006 13:27:02 |
|
|
print preview
The print preview icon is not pworking properly:
I am trying to preview a worksheet within a workbook (its always worked but
just suddenly stopped) .. heres whats happening ...
1) When click on pp the printing pop up box appears
2) when you clilck on preview in this pop up box it shows you the whole
workbook not the worksheet you want to preview.
I use this a lot. Thanks ...
|
1 |
22.09.2006 13:27:02 |
|
|
formatting issues
I am trying to copy data from excel that has colour in the cell, when I
paste special as an enhanced metafile I loose all the colour that was
in the cells. Any ideas on how to fix this?
--
Olive...
|
1 |
22.09.2006 13:22:22 |
|
|
Sheet Name in Cell
It's useful to show the sheet name or workbook title in a cell within the
workbook. What formula works best for this. It's important that the sheet
name not change when I'm active on another sheet (i.e., active on the first
sheet, but printing several grouped sheets). Thanks.
--
Jay...
|
3 |
22.09.2006 13:13:16 |
|
|
counta - from 7th cell of a column to the last cell of that column
Hi all,
Would you show me how to use counta to find the height of a range. The
range is from the 7th row of a column to the last cell of the same column
(the column may not be the longest).
Thanks,
...
|
5 |
22.09.2006 13:11:02 |
|
|
help with setting up dynamic name ranges
Hi all,
Please help me with defining a name range using offset.
I need to set up a name per column using dynamic range. Each Column
starts at row 7. Data are appended to row (and it will grow and I don't know
how many rows before hand, and the column does not contain empty cell.
Thanks,
...
|
6 |
22.09.2006 13:07:39 |
|
|
find numbers in a list which sum a total
i have a list of figures, both + and - , some of which i know when added
together give a specific total. how do i find which figures from my list are
the relvant ones?...
|
2 |
22.09.2006 13:06:21 |
|
|
Complicated Problem
I have my advanced Excel ECDL assessment in the next few days and I can't
figure out how to do something. I have to add a function to calculate the
projected sales increase using specific conditions, does anyone know how to
do this? This probably isn't a hugely complicated problem but I am having
real problems with it....
|
4 |
22.09.2006 12:56:05 |
|
|
Total and summarise data
Hello
I have 51 sheets in the same workbook.
The front sheet is a summary sheet of the 50 behind.
Each sheet has a list of codes with a value next to it, but the same code is
not on the same line in each sheet.
On the summary sheet I would like to add up all the values inline with a
specific code
What is the easiest way of doing this?
Thanks
--
Cheers...
|
2 |
22.09.2006 12:53:27 |
|
|
Summary counting
I have the need to create a quantity summary of information from two types of
text
It is as follows: (all columns have a list of information from which a word
can be choosen - no text can be inputted)
(A1) (B1)
happy D
sad A
tired A
Awake D
happy A
etc.
So the summary should read
(c1)=COUNTIF(A1:...
|
3 |
22.09.2006 12:10:02 |
|
|
How do I evaluate a row of cells for a character in each cell?
In a row of 52 cells, each cell contains an X or a P or an N. I want to
calculate the number of cells that contain an X and divide by 52 (or COUNTA
of the cell range)....
|
3 |
22.09.2006 11:53:02 |
|
|
Auto control number
Dear all,
I've a form with a control number in cell G3. Suppose the control number
starting from "PR 00001" and every time I'll print 100 sheets. I want the
form to be printed out in consecutive numbers, such as PR 00001, PR 00002, PR
00003 and so forth. What will the VBA code be so that I can get the above
result?
Thanks in advance. ...
|
2 |
22.09.2006 11:40:02 |
|
|
How do i sort values like: #103 / 4 / 23, need to sort by 2nd #
i have hundreds of cells containing: (Example:#103 / 4 / 23) or (#105 / 3 /
17 ) ... how can I convert these cells to sort by the second number value;
the 3 or 4 in the example ... Much Thanks !!...
|
3 |
22.09.2006 08:34:33 |
|
|
the difference about formula in two accounts
I have two accounts A and B. When I log in user A, I use my excel to do
function RANK, it has a struture: RANK(number; ref ; [order]). But when I
When I log in user B, I use my excel to do function RANK, it has a struture:
RANK(number, ref , [order]).
Why it is different between ";" and "," in my excel. Is there something
wrong about your software?...
|
3 |
22.09.2006 07:16:01 |
|
|
SUM(INDEX(MATCH) for a range returns different result than SUM!
Hi.
Thanks to previous posters of this group I've learnt that in order to
have a sum in Sheet1 of the Sheet2 column that matches some expression
I must use this construct:
=SUM(INDEX(DATA,MATCH(D2,APPS,0)))
DATA:Sheet2!$B$1:$O$560, Data will not normally go beyond 200 rows, 560
is just for "security"
APPS:Sheet2!$B$1:$O$1 Headers are in B1 through O1
Now, the aforementioned ...
|
3 |
22.09.2006 07:07:01 |
|
|
Select the last value from a list
Column A contains a list of numbers. This list will vary in length. Cell C1
needs a formula to display the last (but not necessary largest/smallest)
figure in this list.
Any help would be appreciated...
|
8 |
22.09.2006 06:18:02 |
|
|
swapping column info between 2 columns
i have a listing of music and i have several rows that need to be swapped
between the 2 columns. ie. artist and title listing but on some lines the
title is in the artist place and the artist place is in the tittle place is
there an easy way to do the whole excel document queick , not line by line
,,,thank you
Rosy...
|
2 |
22.09.2006 05:49:02 |
|
|
Multi-criteria lookup with Multiple results
I am using the following array-entered formula to retrieve data from another
sheet's column E when the data in columns A and B equal some parameters in my
current sheet:
=INDEX('Meetings List'!$E$1:$E$1000,MATCH(1,('Meetings
List'$A$1:$A$1000=C$1)*('Meetings List'!$B$1:$B$1000=$A4),0),1)
All fine there, but what I need to do is tweak the formula and copy it down
3 more rows so that t...
|
4 |
22.09.2006 02:40:14 |
|
|
How do I link information from a large table into new table
Hi, i hope I can explain this correctly in words.
What i'm trying to do is create a report that draws information from a large
table. The report will only be drawing on some of the aspects of the larger
table. I have tried the LOOKUP functions and they are not working in this
case. Maybe there are too many values?
For example there are many oranges, apples, and pears listed in the rep...
|
3 |
22.09.2006 02:34:02 |
|
|
Re: Calculating only non-empty cells...
Guru's
I have a question which may be a brain buster! "Can I have Excel devide a
resulting value by only the number of cells containing data? Examle, I have
row/cells "H5" - "S5" values being calculted in a =Sum() function in cell
"U5", however, the total value is now looked at using a "VLookUp" function on
another sheet to see what the Tax liability is and places that value in cell
"...
|
10 |
22.09.2006 02:20:01 |
|
|
Pivot table with added columns for evaluating results
I have added an extra column to a pivot table to analyze the results. The
pivot table is set up with a page filter for separate users. Each user can
select their data to review without having to look at the entire data set
which is 240 pages. I have used if statements so that the formula rin the
added column runs only if there is data. However if the user selects page
preview they s...
|
6 |
22.09.2006 01:56:19 |
|
|
Concatenate
When I concatenate text from two cells, the texts get joined together. i want
to insert a space between the two text strings. Any ideas?...
|
4 |
22.09.2006 01:53:02 |
|
|
Formula Error
Hi Someone Help me please
IF(L3=M3+(N3=900),N3,"Backorder", IF(l3<>m3+(n3=900,"Future Order No Stock
Available",N3)
I keep getting the message the formula you typed contains an error, I 've
been lookibg at it for the past 1/2 hour and I don't see it. ...
|
9 |
22.09.2006 01:44:57 |