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 / Worksheet Functions / August 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Problems with Copy and Paste in Excel19 Aug 2005 12:27 GMT1
When I try to copy a range of cells the resulting paste gives a bitmap of the
whole spreadsheet. I do not want this. How do I resolve this problem so that
I paste the cells that I have copied only ?
Using Vlookup to compare and validate data19 Aug 2005 12:15 GMT1
I have the following
2 worksheets - named "results" & "Motors"
Results sheet has 2 comboboxes, one sits on cell C5 in column "motorsize"
the other sits on D5 in column "motorname"
woorkbook19 Aug 2005 12:14 GMT1
Imam 14 radnih knjiga sa istim listovima . željelia bih u 15 knjigu da mi se
zbroje svih 14 knjiga svaki list u svoj.
sumif on 2 criteria with worksheetprotection enabled19 Aug 2005 12:01 GMT2
read other posts, don't seem connect it with my little problem:
flat table filled by low-users, passwordprotection enabled, so VBA, macro or
pivot is out of the Q.
column1: project (XXX, YYY, ZZZ) (A)
HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT19 Aug 2005 11:50 GMT2
I WOULD LIKE KNOW THE SYNTAX OF IN EXCEL FOR THE FOLLOWING:
'HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT'
Presently this is availble for Bhat text and not for English.
PLEASE  SUGGEST.
Triple occurence formula19 Aug 2005 10:43 GMT1
Anyone knows how to make a triple occurence formula ?
Example:
Cell A1 = 2356789
Cell A2 = 01345
Formatting Subtotals19 Aug 2005 07:17 GMT2
I have  a worksheet that has 102 departments.  Is there anyway that when I
subtotal by department I can have it automatically add color to that line.  
For example, could I have it bold and highlight in yellow all subtotalled
lines?  I'd also like to add formats around the ...
how do i copy rows using critera in a formula?19 Aug 2005 07:06 GMT1
i need to know how to copy whole rows on to a diffrent sheet using critera in
a column  for a formula so i dont have to look through 55 pages of data and
copy what i want.
Validation for a cell19 Aug 2005 06:12 GMT2
Dear expert,
I want to set a cell (for example : A1) with validation so that the value in
it will not appear twice in a row, say A1:M1. My formula is:
=COUNTIF($A$1:$M$1,A1)<=1.
Visible rows and functions that work19 Aug 2005 05:26 GMT2
I understand from some other posts that there is a way I can get some
functions to work when using the auto filter feature on a spreadsheet
filled with data. I have such a spreadsheet, a number of them actually,
that I'd like to be able to see the filtered rows and have statistics
Counting weeks19 Aug 2005 03:18 GMT6
Hi, need a bit of help on this one.
I need to be able to count weeks. (Mon-Fri).
I also have to be able to count part weeks (Thur-Fri)
Now i am guessing that i am gonna need to use 2 formlae to do this. but
links to same files in different folders19 Aug 2005 02:48 GMT2
Hi,   I have a group of files that are being updated separately, but all
reside in the same folder.  There is 1 consolidated file in that same folder.
I need to create an update every week for the same set of files, which I do
by copying the entire folder to a new folder and ...
Column Headers Not Fixed19 Aug 2005 02:41 GMT2
I have a 650-line sheet with columns A-P. When I use the sort feature for
different columns (such as sorting by last name, or zip code), the headers
keep sorting into the sheet. Anyone out there know a way to fix the column
headers? I use Excel regularly and have never had this ...
Please help!!  Vacation Accrual Formula19 Aug 2005 02:33 GMT1
OK, I actually created this formula several years ago at my old job bu
since I am no longer there, I have no access to it. My boss helped m
with it and I just can't remember the formula.
Basically, I need to create a spreadsheet showing number of accumulate
mailing labels19 Aug 2005 02:13 GMT1
I have a list of names, adressses, etc in excel.  I want to print mailing
labels. Need the easiest and fastest way to accomplish this printing.
 
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.