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 / December 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how do i insert a code bar or link to a adobe designer file19 Dec 2005 02:10 GMT1
i am wondering how do i insert a UPC into a excel file or make a link into a
adobe designer to obtain the information of a read of code bars directly from
the scanner. Thank you for your time.
Luis
how do i create a macro for putting a check in a box?19 Dec 2005 02:05 GMT1
I am trying to create a worksheet that contains a yes/no option by inserting
a check mark in a box.
Totalling Collumns19 Dec 2005 01:45 GMT1
I work on Bids and Proposals and use the AUTOSUM key to total columns. But
when I then edit the bid by adding/inserting an additional item, sometimes
Excel adds the addtional amount to 'Total', sometimes it doesn't. Has
resulted in some embarrassing situations. What am I doing ...
Importing External Data function19 Dec 2005 01:34 GMT1
I would appreciate help and advice for my problem. I want to import a data
set into excel using Data -> Import External Data -> Import Data. My data
(which is saved as text file) looks like this:
Belgium (1999)    22/31    5/232
merge19 Dec 2005 01:21 GMT1
I have 2 list of phone numbers in 2 different workshhet.
How can I merge them in one list eliminating the repetitions
count and display unique values19 Dec 2005 01:11 GMT2
I need to count and display unique values
a
a
b
getting value 1 column to right of cell selected in pulldown19 Dec 2005 00:59 GMT2
I have a chart that has in the one column (N) a list of sheet metal gage
numbers and in the previous column (M) the gage number represented in numeric
form. The user will select the desired gage size via a drop down menu that
references the values in column N.
How can I  sort a group of numbers automatically as data is entere19 Dec 2005 00:56 GMT4
I'm designing a spreadsheet to record the World Cup football scores. I've got
the leagues to take scores from the match results but I now want the leagues
to sort by points/goal diff/goals scored as match socres are entered.
Is this possible?
Hlookup/max value?19 Dec 2005 00:45 GMT4
What I am trying to do is look for the max value in a row and return
the relevant column header
Example:
1-----2-----3-----4------5-----6-----7----
Cant Get IF(ISBLANK) to work19 Dec 2005 00:40 GMT3
This is driving me crazy!! I am sure it is somehting simple, but I can't get
it.
On several parts of my spreadsheet I have used the following formula
In Cell4 I have this:
Can i move scanned jpeg text to excel spreadsheets19 Dec 2005 00:14 GMT4
I scanned a price list into a JPEG format now i would like to move it to a
excel spreadsheet that i can edit and make changes. If not, how can i copy
this printed text price sheets from a booklet onto a excel speadsheet without
typing all the text.
UDF's using other UDF's18 Dec 2005 20:38 GMT9
Is there any problem with using one UDF within another because I am
having problems:
I am trying to input times as 4 digit integers then use the function
"TimeDiff" to work out the difference between times.  Timediff works
I am trying to match 2 lists18 Dec 2005 20:27 GMT1
What I am trying to do is match 2 lists to get a value. In other words in
sheet1 I have this:
            a
1 address anywhere
IIF issue18 Dec 2005 19:55 GMT6
I need to do the calculation according to the availability of data as
following example.
1.    Provision of both cell A1 and A2, perform formula 1.
2.    Provision of all cell A1, A2, A3 & A4, perform formula 2.
Pivot tables18 Dec 2005 16:56 GMT3
Hi,
I have a pivot table and and a pivot graph that I have to update regularly.
Can I add lines to the dataset (if I dont change to columns) and make the
table read the new data?
 
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.