| Thread | Last Post | Replies |
|
| how do i insert a code bar or link to a adobe designer file | 19 Dec 2005 02:10 GMT | 1 |
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 GMT | 1 |
I am trying to create a worksheet that contains a yes/no option by inserting a check mark in a box.
|
| Totalling Collumns | 19 Dec 2005 01:45 GMT | 1 |
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 function | 19 Dec 2005 01:34 GMT | 1 |
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
|
| merge | 19 Dec 2005 01:21 GMT | 1 |
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 values | 19 Dec 2005 01:11 GMT | 2 |
I need to count and display unique values a a b
|
| getting value 1 column to right of cell selected in pulldown | 19 Dec 2005 00:59 GMT | 2 |
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 entere | 19 Dec 2005 00:56 GMT | 4 |
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 GMT | 4 |
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 work | 19 Dec 2005 00:40 GMT | 3 |
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 spreadsheets | 19 Dec 2005 00:14 GMT | 4 |
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's | 18 Dec 2005 20:38 GMT | 9 |
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 lists | 18 Dec 2005 20:27 GMT | 1 |
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 issue | 18 Dec 2005 19:55 GMT | 6 |
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 tables | 18 Dec 2005 16:56 GMT | 3 |
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?
|