| Thread | Last Post | Replies |
|
| date formatting won't work Excel 2003 | 06 Oct 2007 00:35 GMT | 8 |
I am fairly new to Excel 2003. Here is my problem. I am inputting names and birthdates in my worksheet. I have a column for each.
|
| ExcelMedic.com | 05 Oct 2007 16:18 GMT | 1 |
ExcelMedic.com can provide a full range of Excel solutions to fit your needs. ExcelMedic.com charges an hourly rate that is guaranteed to be 15 percent less than other
|
| Shortcut keys | 05 Oct 2007 15:34 GMT | 1 |
All of a sudden I came in Monday and many of my shortcut keys do not work.such as: CTRL Shift Home or End or Up or Down CTRL Shift Home goes to the beginning of the row
|
| Calculations based on 4 possible text strings? | 05 Oct 2007 14:39 GMT | 11 |
I have this formula that goes into E2 in the first line: =IF(C2<>"",IF(D2="PST+GST",SUMPRODUCT(C2*0.13),"")) which works if the text string PST+GST is found in D2. But I don't know how to branch out from there. There are 4 possible answers to go into D2 which
|
| Sum with conditions | 05 Oct 2007 14:02 GMT | 7 |
I've read a lot of posts in this group about this issue, but I can't find a solution. I am using this array formula: {=SUMA(((ConsultaPosiciones!E2:E100)=B1)*(ConsultaPosiciones!J2:J100);
|
| unable to record (and save) macro in XL97 | 05 Oct 2007 10:44 GMT | 3 |
Hi, sorry for my bad english :-| Excel 97 in Windows 2000pro sp4 + if i use a standard user to record a macro (and link it to a button or a bar) when i exit and then re-enter in excel, my macro, the button and the
|
| annoying flcker as macro copies from one sheet to another | 05 Oct 2007 09:07 GMT | 2 |
I have a macro in excel 2003 that 1. Reads the contents of a cell on one sheet 2. processes the value 3. Writes the new value to a cell on another sheet
|
| SQL query from one excel worksheer to another one in the same book | 05 Oct 2007 07:46 GMT | 3 |
I have an Excel book with 2 sheets. One of them is just a copy & paste table from Access (I mean, just columns with a header). The other one is a dynamic sheet that must be filled from the first sheet. I need to fill it with several conditions, say I want all data from
|
| 25th percentile error | 05 Oct 2007 05:43 GMT | 10 |
I don't know if anyone has run into this problem yet or not, but I took a list with a bunch of 0, and Excel did not calculate the 25th percentile correctly. Here is the list of numbers, and the result that excel gave, along with what Google Spreadsheet says:
|
| Incompatible Excel 97-2000 and 2007 | 05 Oct 2007 01:24 GMT | 1 |
1. Created Excel file in 97-2000 version with links (copy paste links) 2. Another user opens the file sitting in a network drive, amends it and try to save it. Gets an error message that say something like "Some formulas in this workbook is linked to other workbooks that are ...
|
| Im New - DSS | 05 Oct 2007 01:14 GMT | 3 |
I got DSS that I done in excel for my assignment, and I like someone to check it for me if Im right, if there is any errors, before handing it up to the lecture. Can anyone help me with this?
|
| need cell appeat blank if no data in that row | 04 Oct 2007 23:52 GMT | 3 |
I have a data in columns, I want data to be shown only if there is data in that row if no data then leave it blank (here is what I am asking for) Stock trade Gain/Loss Gain/Loss all trades
|
| pivot table grand totals not showing for all columns... | 04 Oct 2007 22:09 GMT | 1 |
i have a pivot table that shows the grand total for some columns, but not for others... there are no differences in the data layout, yet this happens? any clues as to why? and how I can get the grand totals to show for
|
| Worksheet versions | 04 Oct 2007 21:54 GMT | 1 |
[Excel 2003] I can find nothing in the Help file, the online Help service, or through Google on how to create versions of a worksheet in Excel. I have a worksheet with data; I want to creat--in the same file--the same worksheet, but with some changes to several elements.
|
| Adding third lookup value to index/match | 04 Oct 2007 21:48 GMT | 7 |
I understand how Index/Match works with double lookups... But I cant quite get the third lookup down. Looking to add a third lookup value and range to this formula (range z)
|