| Thread | Last Post | Replies |
|
| formula to convert decimal feet to feet inch sixteenths | 20 Feb 2008 22:58 GMT | 23 |
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 worksheets | 20 Feb 2008 22:57 GMT | 9 |
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 applicatio | 20 Feb 2008 22:48 GMT | 2 |
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 GMT | 2 |
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 rows | 20 Feb 2008 22:43 GMT | 2 |
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 button | 20 Feb 2008 22:42 GMT | 1 |
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 cells | 20 Feb 2008 22:42 GMT | 1 |
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 Tabs | 20 Feb 2008 22:36 GMT | 3 |
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 column | 20 Feb 2008 22:22 GMT | 3 |
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 GMT | 2 |
I have a column of text but one item only will not automatically repeat, any suggestions as to why?
|
| Simple Inventory | 20 Feb 2008 22:16 GMT | 2 |
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 values | 20 Feb 2008 22:13 GMT | 2 |
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 Word | 20 Feb 2008 22:07 GMT | 4 |
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 answer | 20 Feb 2008 22:06 GMT | 1 |
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 merge | 20 Feb 2008 22:05 GMT | 3 |
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?
|