|
|
2003 formula for Pivot by
Rama Chandra
When I use the formula referencing the pivot table in Excel 2003 instead of
just showing the cell reference it shows the GETPIVOTDATA. How to get just
the...
|
|
1 |
162 |
|
|
I need to filter on two colums.... by
Dave Eade
but I want to look in both columns for the same value.
Column 1 has 20 different depts as 'inputs' adn column 2 has the same 20 as
outputs - I want to filter...
|
|
3 |
173 |
|
|
automatically move data to another file by
reza
Hi All,
Need your help guys...MS Excel 2007
i have data from one file and want to move it to another file.
with data like:
A1 Refill, 100 respondent, 100...
|
|
1 |
117 |
|
|
|
October 7th, 2009 01:33 PM
by JLatham
|
1 |
268 |
|
|
Create Invoice in Excel? by
Mike
Is there anyway I can input a number in excel and have excel link that number
to a invoice templete I created automatically?
I am not very familiar with...
|
|
2 |
145 |
|
|
Formula to add a row by
Jenny Gleeson Ireland
I am familiar enough with excels formula - what ifs etc but I was wondering
if it is possible to construct the following formula:
I have an excel sheet full...
|
October 7th, 2009 01:04 PM
by JLatham
|
1 |
121 |
|
|
|
|
2 |
157 |
|
|
Conditional Formatting Quartely Months by
malycom
Hi
Is there a way to conditionally format a column of dates just using the days
and months and not including the year?
For instance, the column I have is...
|
October 7th, 2009 12:22 PM
by malycom
|
2 |
102 |
|
|
Can't figure out the Function I need! by
slober
Basically..
Column A is a list of names
Column F is the total amount of hours practice the named person has done
I want a Fuction which automatically tells...
|
|
4 |
121 |
|
|
|
October 7th, 2009 10:38 AM
by wauer
|
0 |
138 |
|
|
Time Format by
Cheekie975
Hi. I want to create a time sheet where a user logs in at a time then logs
out at a time, I want Excel to then calculate the number hours and minutes.
I...
|
|
2 |
97 |
|
|
How do I delete multiple cell styles? by
SierraMike
I have a large spreadsheet that someone must have attempted to past into
without using text or unicode text options. As a result it added hundreds of...
|
|
5 |
108 |
|
|
|
|
1 |
128 |
|
|
Errors when using named ranges by
Deina
I'm attempting to use VLookup() to access data in the 7th column of a
different sheet in the same workbook.
I have named the range that I want as "Have",...
|
|
1 |
114 |
|
|
Subtracting Dates by
Shannan
Hi,
I have the following formula to subtract the dates from two different
columns:
=IF(DATEDIF(Z11,AD11,"m")=0,"",DATEDIF(Z11,AD11,"m"))
What i want the...
|
|
2 |
150 |
|
|
Copy to another worksheet by
Clinton W[_2_]
I would like to copy particular cells from nine different worksheets and
paste (value only) to another sheet named “Print”. All the sheets are within
one...
|
|
3 |
145 |
|
|
Exporting data in excel to word by
SKMSOffice
I have a list of email addresses in excel. I need to be able to paste those
addresses into an email so I need to export the column of email addresses to...
|
|
1 |
133 |
|
|
|
October 7th, 2009 01:39 AM
by FSt1
|
1 |
100 |
|
|
Linking cells from the previous sheet by
Ed Davis[_2_]
Is it possible to link a cell from the "Previous Sheet" without giving it a
name.
I need to link about 400 cells on a sheet and need to copy it to another 30...
( 1 2)
|
|
10 |
258 |
|
|
Countif by
Katy
Hello all, could someone please help... I work in a school and am trying to
create a tracking grid to map pupil progress.
I need to count the number of times...
|
|
3 |
120 |