Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
results table dilemma12 May 2008 07:17 GMT9
hi there everyone,
I'm hopeful that someone can help me with my excel problem. Here's my
dilemma: I'm trying to do a results table where results will come from a
worksheet that has different columns, one of which is a date column(let's
0100 (24 hour) time - Which format??12 May 2008 06:52 GMT3
I wish to type in the cells 0100, 0200, 0300 etc  but cannot see the format
type that retains these numbers as four digits (allows me to go to 2400) .
Which format is it - I have tried several and it drops the first zero(0) off.
Cheers
test value between range, and month12 May 2008 04:28 GMT5
I cant get the condA or condB to execute if value of A1 fall within range 1
to 10
if(and(A1 >= 1, A1 <= 10), condA, condB)
How to get the month with a increment value as below
average of a range, but only for the cells that contain values12 May 2008 03:47 GMT1
Hello - Anyone familiar with a way to take an average of a range of
cells, but only for the cells that contain values.
So for example:
9
using a map to fill in a textbox11 May 2008 23:53 GMT1
I have created a geographical map with different provinces in Excel 2003. I
have assigned a macro to each province and it works well.
I have also created a userform.
When the province textbox is prompting for input, I want the map to appear
Formula needed please...11 May 2008 22:43 GMT4
This is probably simple to you guys, but I can't seem to get it to work. I
need a formula that will add together the sum of A1, A2, & A3 cells, then
display (in A4) 20% of the total?
Hope this makes sense.
How do I find formula to calculate a year's salery11 May 2008 22:34 GMT1
How do I find a formula to get a year's salary
pivot table macro11 May 2008 20:30 GMT-
I want to create a pivot table using the pivot table wizzard from a worksheet
into a worksheet with the name table by running a macro. when I record the
macro I create the pivot table using the wizzard and it works fine but when I
try to run the macro again it errors "unable to ...
Insert row in Office 200711 May 2008 18:22 GMT3
Can someone advise me how to insert more than 1 row a time.
Thanks,
Scott
The macros in this project are disabled.11 May 2008 18:16 GMT2
From the ControlBox when clicking on the Exit Design Mode button, I
get a message:
The macros in this project are disabled.
This is preventing me from running my project.
Pivot Table Formatting11 May 2008 18:07 GMT1
I have read past posts on Pivot Table formatting and have achieved some
success with the formatting problem.  
My current problem is that on one spreadsheet I have used AutoFormat to get
the look I want for the Pivot Table.  On this table I expanded the width of
Filter question11 May 2008 17:55 GMT2
I have a Pivot Table in Excel 2007 with data. I have a Date column. I need
to filter the data so it shows me the data from 01-01-2008 and today date
minus 1 day. I would like to have the data filtered automatically (without
having to go everyday manually and change the filter ...
pivot table11 May 2008 15:13 GMT2
I have been tasked with putting together a pivot table for my group that will
highlight if a persons vacation falls within blackout dates. Right now I have
a list of names and a start and end date for there vacations. I also have a
list of blackout dates set up with start and end ...
delete blanks cells11 May 2008 13:55 GMT1
Sir,
How to delete filtered Blanks Cells
Thanks
Hardeep kanwar
combine sheets11 May 2008 12:26 GMT3
I have a workbook with 50 worksheets. And i want to combine 50 sheets
into one sheet
Is it possible?
If yes then how
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 April, 2008
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.