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 / General Excel Questions / February 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
formula to convert decimal feet to feet inch sixteenths20 Feb 2008 22:58 GMT23
I would like to write a formula in excel, without using macros, to convert
decimal feet to feet-inch-sixteenths.
Can someone help me ?
Vlookup on mutiple worksheets20 Feb 2008 22:57 GMT9
I have a worksheet (sheet1) where I would like to do a vlookup in col b1,
from data that is in worksheet 2 (sheet2, a1:d100), and worksheet 3 ( sheet 3,
a1:d100). the output for the vlookup in sheet 1 is in either sheet 2 or sheet
3.
Compress file to a smaller size without using 3rd party applicatio20 Feb 2008 22:48 GMT2
My purpose is to send a very large Excel file via email (about 10MB), but it
takes to way too long to send it and some time it didn't even go through.
So my question is, is there a way to compress the size of the file to send
via email?  I don't really trust 3rd party online ...
trouble shooting "COUNT"20 Feb 2008 22:44 GMT2
I have a 1000 line spread sheet where one column has an entry that is a code
as follows
X YY ZZ  (Where each of the groups can be one or two characters
There are 15 or so different codes
duplicate rows20 Feb 2008 22:43 GMT2
I have a spreadsheet containing multiple tabs of names and addresses.  I
wantto have a master tab so I copied and pasted from tabs 2, 3, & 4 to tab 1.
I want to check tab 1 for duplicates and erase the duplicate lines.  How can
I first find those duplicates so I can visually ...
add or copy a sheet by button20 Feb 2008 22:42 GMT1
Greeting,
I have a worksheet and what I want to do is making 2 buttons for add new
sheet and other for copy the sheet. How to do that please??
Many thanks
Drop down boxes within cells20 Feb 2008 22:42 GMT1
I am trying to create a spreadsheet with drop down characters for people
choose from.  Just need to know how to go about this.  Any help would be
appreciated.
Missing Tabs20 Feb 2008 22:36 GMT3
I opened up a worksheet but there were no tabs (there were suppose to be 8
tabs) and when I go to Formatting Cells, there are no unhidden sheets. How do
I find these tabs?
Add up whats in a column20 Feb 2008 22:22 GMT3
I have a column that I would like to tally up how many times text has been
entered.  There are 300 rows and a number of these rows have yes entered - I
would like to know have text.  Thanks.  Using 2007.
won't automatically repeat 1 item already entered in column?20 Feb 2008 22:20 GMT2
I have a column of text but one item only will not automatically repeat, any
suggestions as to why?
Simple Inventory20 Feb 2008 22:16 GMT2
Okay, I have looked at the Inventory Templates for Access and also for Excel
and haven't found anything that quite meets my needs -- and not smart enough
to mess with what templates are there to make them work the way I want.
So this is what I am looking to do and maybe someone ...
merge two cel into ONE retaining the two values20 Feb 2008 22:13 GMT2
i need to merge into one cell (A1) the cells A1 and B1.
A1 contain the word DESCRIPTION
B1 contain the word CODE
I want to MERGE, not concatenate or use "& to join the information from A1
Compare then combine data, then mailmerge with Word20 Feb 2008 22:07 GMT4
I need to combine records that belong to "same" account number into one record.
My ultimate goal is to get data that has been exported into excel, into a
word document and do a mailmerge.  I would like all data pertaining to Acct#1
in the spreadsheet to merge into the same word ...
changing color of answer20 Feb 2008 22:06 GMT1
I'm trying to change the color of my result to a different color based on
which answer a formula brings back. all my answers are in text format. The
formula is below which is just a simple vlookup data proving type.
=IF(ISERROR(IF(C7="DDG",VLOOKUP(B7,'DDG
bolding the data and doing the mail merge20 Feb 2008 22:05 GMT3
I have a data spreadsheet with 26 separate comments (26 columns). Some of
these comments, I bolded specific words. When I do my mail merge, those
bolded words from the data spreadsheet do not transfer into the mail merge as
bolded, they come in as UNbolded. What am I doing wrong?
 
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.