|
|
Formula in Pivot Table by
Mouimet
Hi,
When I select Calculated Item in Pivot table formula I received an error
message saying Multiple data field on the same field are not supported when a...
|
November 23rd, 2009 03:58 PM
by Mouimet
|
0 |
98 |
|
|
|
|
1 |
148 |
|
|
Sum items occurring in a month and year by
Saylindara
I've got the following formula to sum referrals received in a particular month.
Is it possible to make it specific to the year as well as the...
|
|
3 |
154 |
|
|
Office 2003 to 2007 by
gab1972
My office will soon be migrating from Office 2k3 to 2k7. I have a
workbook we use A LOT and it is macro filled. It communicates with
Access, starts emails in...
|
|
2 |
176 |
|
|
|
November 23rd, 2009 01:19 PM
by JLatham
|
2 |
129 |
|
|
Removing Query Definition by
Nigel
In Excel 2003, I was able to remove the query definition once I had imported
data from an Access database, by de-selecting the Save Query Definition from...
|
November 23rd, 2009 11:38 AM
by Nigel
|
0 |
190 |
|
|
Please Help! by
Elaine0203
Hi, hopefully someone can help me with this as I have drawn a blank. I have
the following rental costs options on excel
A B C D
E
1 Street Monthly...
|
|
2 |
155 |
|
|
|
|
0 |
135 |
|
|
FORMULA TO DEDUCT LUNCH AND TEA TIMES by
DJRHUTCH
Please could you assist with a formula to calculate actual time worked for an
individual technician? I have a technician time sheet whereby i have a start...
|
November 23rd, 2009 10:43 AM
by DJRHUTCH
|
2 |
185 |
|
|
Font changed by Conditional Formatting by
Hugh
I have created conditional formatting in Excel 2007 to change the colour of
text under certain conditions, but the colour AND font change. The font of
the...
|
November 23rd, 2009 09:10 AM
by Hugh
|
0 |
134 |
|
|
SUM ON BASIS OF FORAMAT by
OPSHARMA
Dear All,
I have exported some data From Tally in which format shows Dr & Cr now
i want total seperately of Dr and Cr ( file is attached for
reference...
|
|
1 |
106 |
|
|
Macro for shared workbook by
puiuluipui
Hi, i have a shared workbook. I want to work with another user, at the same
time. But if i enter some datas on the same row as the other user, i receive
an...
|
|
0 |
117 |
|
|
|
|
1 |
151 |
|
|
Combo Box Showing Date Selections by
TiredAlison
Hi
I have a spreadsheet with a combo box setup. I want it to display in the
pull down dates in the format dd/mm/yy from todays date - 5 days to todays
date +...
|
|
4 |
164 |
|
|
Cell Merging by
Sudipta Sen[_2_]
If I entry Data in A1 & B1 on sheet 1
I want to get Meging data of A1 & B1 in A1 on Sheet 2, eg.
Sheet 1
A1 B1
Kolkata 700...
|
|
1 |
127 |
|
|
Bulk Discount Formula by
dgold82
I am looking for a business formula: Basically, I am trying to figure out the
best bulk discount per unit as possible to maximize profit.
For example: 10...
|
November 23rd, 2009 05:46 AM
by eksh
|
3 |
143 |
|
|
|
|
1 |
186 |
|
|
Cursor cell selection "won't release" by
nitewowl
This is happening within an open spreadsheet. Somehow I have accidentally
hit something or some combination of keys that makes the cursor "stuck" in...
|
|
5 |
114 |
|
|
Trends by
Wendy
Having had not much to do - actually nothing with showing a trend on a chart
I would like some help.
Have setup a chart that shows
Name Annual leave...
|
November 22nd, 2009 11:40 PM
by Wendy
|
0 |
112 |
|
|
Replace entire cell content by
Steve C
I have a bunch of names on a spreadsheet and i'm looking for an easy way to
replace the names in each cell with a single character, 1, x, etc.
|
|
1 |
176 |