Search:
Type: Posts; User: mdosh01
Search:
Search took 0.00 seconds.
-
Good point. I'm out of ideas.
-
I did a search and didn't come up with anyone having this specific problem. If it's just one PC experiencing this, I would try reinstalling Word or the Office Suite. I believe it will give you the...
-
What model PC do you have and what OS are you running? Do any of the other toolbar icons work or is it just save and save as that stop working? Have you installed any updates recently? Do you get...
-
Sorry, I didn't check that. Where is the data coming from? What kind of database or file? Or is it pulled from a web site.
Here is information that may be useful: ...
-
It will depend on the source of the data. Is it a database or flat files of some type?
Here is some information on importing from a database:
Mac ODBC: Importing ODBC data into Excel
-
OK. My wife was using the older version of Yahoo Mail. I switched it to the upgraded version and now it is printing fine. So either this was a Yahoo Classic Mail issue or Vista Security had a...
-
Thanks. That resolved general IE printing. However, Yahoo mail still won't print which is where she was when she answered the security question incorrectly.
Any other suggestions?
-
My wife has a new computer with Vista Home Premium. We're still learning the nuances of Vista. At one point, she wanted to print an email in Yahoo. Vista generated a pop up about if she recognized...
-
Thanks. I was able to repair the part. It's a poor design of the original part, but my fix seems to be holding.
-
:) Never occurred to me to check the date.
-
Display the screen you want to upload. Press the "Print Screen" key. Then open MS Word and press CTRL+V or right-click and click paste. Save the document and upload it to Ask Me.
-
I have a Dell E207WFP LCD monitor that is out of warranty. There is a rubber/plastic pad that you press to turn on the monitor, change contrast, etc. The nub for the power button is broken so I...
-
Have you tried the "Print Layout" view, or one of the other views to see if it shows up in edit mode? Otherwise, can you attach the document? If you don't want to share the text, save a second...
-
There are also language settings in Microsoft Office that need to be changed (assuming you have more than just Word):
http://office.microsoft.com/en-us/word/HP030845661033.aspx
-
OK. The attached method requires a second table with the days total accumulated in Sheet 2. Then HLOOKUP is used to find the specified day's total.
-
See the attached. In Sheet1 you will enter =Sum(Sheet2!C3:e3) for example for product K, 3 day total. Just copy that formula down the column to fill in the rest of the cells. Then do the same for...
-
In your formula, just insert the target spreadsheet name followed by an exclamation point in front of the target cell. For example, is the time sheet name is "Sam" and you want cell B4 from Sam in...
-
Careful. It wasn't Junaid169, who asked the original question, that questioned your response.
-
Check the following link from Microsoft:
How to compare data in two columns to find duplicates in Excel
To use this method, you will need to concatenate the two columns of data and then do the...
-
I would agree with JB, but with the following caveats:
1) 62.5% failure rate overall is calculated or "assumed." That is, statistically, if we were to evaluate all 25 jobs, statistics would say...
-
I suspect this will take some macro coding, but let's get some more information.
What type of files are in each member's folders? Spreadsheets, Word documents?
Where do you want the results? ...
-
Have you successfully attached files before with either account? Due to the file size, you might try a test with a very small file and send it to yourself. If that works, then you may want to...
-
Check this out. It will do exactly what you asked.
Run a Macro depending on the value selected from the drop-down list : Visual Basic for Applications (VBA) : Microsoft ISV Community Center :...
-
The Microsoft web site also has free templates. Check the following URL for Excel invoice templates:
http://office.microsoft.com/en-us/templates/results.aspx?qu=excel+invoice&av=TPL000
-
Just to throw in another option, if by "text" you mean cells that are not empty, you can use:
=counta(Callsign)
Assuming "Callsign" is the range in question.
-
If I understand correctly, this would take some significant macro coding to accomplish. However, you would have to provide someone a copy of the spreadsheet and spend a little time with them showing...
-
Assuming the dropdown list is created the same in Excel 2003, it exists somewhere in your workbook. In the menu bar, go to "Data" then "Validation...". Click on the "Settings" tab. In the "Source"...
-
Thanks Scott. I forgot the obvious issue.
-
OK, so this is the array syntax. Your array is C2:C5 in Sheet1. The row number is determined by the Match statement and the column is 0. Since it is 0, INDEX will return the entire column.
The...
-
I'm not sure I understand the question. In most formulas you use parenthesis "(" and ")", not "{".
For INDEX, the syntax is:
INDEX(array,row_num,column_num) returns the value of a specified...
-
With Excel 2003 and IE 7, links open in new tabs but not new windows. If you want a new window, it looks like you'll have to create a VB script per the following:
Hyperlink in Excel Viewed in...
-
:) Thanks. It is interesting what you can find in Help sometimes. Unfortunately, usually not what I need!
-
Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
-
That is what ScottGem has given you. If column A has your zip codes (assuming you are starting in row 2 of the spreadsheet), then enter his formula in cell B2: =B2 & "-0000" and press enter. You...
-
Interesting. I haven't done much with dual displays so here's a stab in the dark. I'm not sure of the exact order you do things, so I would switch it up a bit. If you open both files and then...
-
Custom formatting only applies to numbers, not text. I have to assume the reason it works some times and other times not, is because if the entry is "0021e96c4183" contains text. Whereas if the...
-
If I understand correctly, the formula you are looking for would be as follows. Assume the salary is in cell A1. Then the deduction is:
...
-
The Microsoft Office web site has a number of budget spreadsheet templates:
http://office.microsoft.com/en-us/templates/CT101172321033.aspx
You could also try a Google search on "Excel budget...
-
Alternatively, Enter the value "1" in cell A1.
Then select Edit, Fill, Series from the menu. Change "Series In" to "Columns". Enter a stop value, say "100".
-
Be aware that if you use VLOOKUP, the list must be sorted. In this case, the data in column A would have to be in sort order.
-
We're still guessing what you are trying to accomplish here. The lookup formula for an unsorted list, which I assume we could have here, is:
=INDEX(A1:B4,MATCH(4,A1:A4,0),2)
This will find the...
-
I'd need more information. First, you are evaluating whether the cells in column A are greater than 0. In this case they all are since column A contains the values 1 through 8. Assuming you meant...
-
The only way I can think of doing this is with a template. Search on "Create a template" in Excel help. Save the template with the desired setting and follow the instructions. This template will...
-
I believe the answer is to use the ROUND function in your calculations.
=ROUND(C3*.03,2)
You may want to round the product as well:
=ROUND(C3-D3,2)
-
Enter "Count unique values" in Excel help and you will get two different methods. One is to use a filter, but I'll assume you prefer to use a function. Their example is for comparing two lists. In...
-
This is easy to do. Enter the price on the first worksheet (or any desired worksheet). Go to the next worksheet that is to contain the price. Enter an equal sign ("=") in the cell and then click...
-
Found this posted by mky517 back in Feb. of 2006:
If you do not have the installation cd and want to solve
this issue follow these steps: (works most of the time with
all sku.cab files)
1....
-
Conditional formatting is one answer. You have 3 columns, one for debits, one for credits and one for the running balance. The running balance contains the formula subtracting the debits and adding...
-
The following is from Microsoft Excel Help (look up "Create a link to another cell":
1) Open both the workbook that will contain the link (called the destination workbook), and the workbook that...
-
I think we need more details to help you on this one. But let me take a stab at it. You have a series of numbers in one worksheet and you want the sum of those to appear in another worksheet.
...
|