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 / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do I get my Quattro Pro 10 files to open with Office Excel?07 Sep 2006 03:55 GMT1
My .qpw files will not open in Office Excel 2003; file format is not valid.  
I did find a fix for Quattro Pro 7 to Excel 2000, but did not try that for
obvious reasons.  Also, is the best way to move spreadsheet files from one
computer to another via cd? Thank you all in advance.
cell in row has highest value and rtrns col hdr07 Sep 2006 03:00 GMT11
can anyone advise as to which formula would be able to find the highest
("=MAX(A$:T$)")value in a row of cells and once identified return the column
header?  thanks for any help!
calculate taxes07 Sep 2006 01:58 GMT4
I have columns of sale items that need to have two taxes 7% & 6% added to
them. I can do one by but not sure how to combine them. ie 100+7+6=113. What
is the formula for this. I am relatively new to this.
In Excel formula to calculate the date someone will hit 6507 Sep 2006 01:56 GMT3
Using a formula, calculate from birthdate what date a person will turn 65.
How to mix up digits into a new number?07 Sep 2006 01:27 GMT3
I can put single digits into separate columns and concatenate them into one
number.  Is there a worksheet function or formula that will randomly mix up
those same digits into a different concatenated numbers?  EX: turning "123"
into "231"?
Formula reference to a cell instead of inputing06 Sep 2006 23:49 GMT2
I need the following formula to point to cell (I.e. A3) for the name
(John Doe) instead of me putting the
name itself.
Any advice?
Rename Columns06 Sep 2006 23:31 GMT6
Hi I need to know how to rename a column from the default A,B,C etc to
specific names
Amazing 40% rule06 Sep 2006 22:53 GMT8
I have recently come across a statement called " The Amazing 40% rule" in
excel, tried to search in google, but got no information on this yet...
Can anyone help me to understand this? May be a link to the site where its
explained in detail?
Need a macro06 Sep 2006 22:12 GMT7
Ihave data in col A & B
Theamount of data can be only 10 lines or could be 100 lines
lets assume I have 99 entries in col A & B
I would like the macro to copy lines 33 to 66 to start at d1 & d1
Preserving lock on cells even when copied and pasted within a sheet06 Sep 2006 22:12 GMT4
(Sorry for repeating this post from another group; I inadvertently
neglected adding both groups in my original post in
microsoft.public.excel.misc.  In any case, I found a couple of minor
errors and omissions that I have corrected :-P.)
Is it possible to...06 Sep 2006 21:52 GMT1
export 1 or more macros automaticlly tather manually? Thanks
collect data from the same row in multiple spreadsheets06 Sep 2006 21:30 GMT2
I have 140 employees with a separate workbook for each.The workbooks contains
their by-weekly timesheets.  Each workbook has 26 sheets (one for each pay
period).
I need to start a workbook that will contain the total line for each
summing cells based on "like" value and cell color06 Sep 2006 20:30 GMT7
Is there a way to look at a column and if the cell begins with
01,02,03....98 and the cell color is either yellow or pink to sum those
just those cells?
So what I'd like to do is sum all the cells starting with 01 that the
Unique text count with multiple criteria?06 Sep 2006 20:01 GMT4
This formula is working but what it's doing right now is giving me a
total unique count of names PER QUEUE.  Sometimes agents work in two or
more queues per day, so what I need it to do is give me a total unique
number of names even if the same name shows up under multiple queues.
determine if date range falls within date06 Sep 2006 19:35 GMT1
Ok, this one is driving me crazy!  Seems like it should be simple, but
no luck so far.
Here is what I've got:
a2 start date  2/10/06
 
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.