Tagged Questions
1
vote
1answer
45 views
How do I create a list of phone numbers for people whose reference numbers appear in two columns?
I have two sets of data in columns A & B and also in columns C & D. Some of the content in column C & D does not appear in columns A & B:
A = reference numbers
00001, 00002, 00003, ...
0
votes
0answers
41 views
How to avoid sorting rows copied from other rows?
I have a payroll that contains 30 names of workers. I sort this payroll in three different ways: 1) ORDER 1; 2) ORDER 2; and 3) GROUP.
I have copied the names into another group of rows, every one ...
0
votes
1answer
29 views
Close Full Screen window does not go away in MS Excel 2003
I have a problem or bug in MS Excel 2003 where the close full screen mini window does not move or go away. No matter what I do, I cannot move the window or even click any of the options.
I'm ...
-2
votes
2answers
122 views
Nested IF formula
I want a formula that will capture the following three scenarios below. In column S, I have Orange in cell S2, Mango in cell S3, Grape in cell S4, Pawpaw in cell S5, Onion in cell S6, Apple in cell ...
0
votes
1answer
86 views
Excel Time Subtraction
I think there is a way around the time subtraction issue I have in Excel. The problem is that when the time in cell F (for example 11:29am) is less than the one in cell A (for example 11:30am), the ...
1
vote
1answer
53 views
Referencing the sheet name is not working [duplicate]
I'm trying to get the sheet name into a cell. I've tried using:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
but my Excel 2003 displays an error when I try to enter the formula. ...
2
votes
2answers
74 views
Why is this simple Excel calculation not netting Zero?
It's supposed to be zero but for some reason the result produces a peculiar series of digits at the end.
Also, here's the .xlsx of it: http://83.212.111.36/Book1.xlsx
0
votes
1answer
44 views
Unable to add, create, or remove drop downs on an Excel 2003 spreadsheet
In Excel 2003 the Validation option under Tools is grayed out for a specific workbook. The sheet is not locked or protected, but it is shared. Even the author of the sheet has the Validation grayed ...
0
votes
1answer
102 views
MS Excel 2007 Warning Significant loss of functionality
I have created a template in MS Excel 2003. In MS Excel 2007, when I save it in MS Excel 1997 - 2003 format, it gives a compatibility warning;
Significant loss of functionality
This workbook ...
0
votes
2answers
88 views
excel conditional formatting AND isnumber
I'm trying to get my format sentence to work, but it just won't
I want to format the cell green if the cell is greater than the cell before it (and that cell contains a number)
I'm trying:
...
4
votes
2answers
272 views
Restrict and validate date format in Excel
I'm trying to put together a 'Data Validation' formula which restricts the user to entering a date in the following format: dd-mm-yy.
From the research I've done, I've come across what I thought ...
-1
votes
2answers
100 views
I will need a formula showing counts, totals and sub-totals for data set from different sheet
I am using MS2003 EXCEL. I have a cell in Sheet 1 with a color value and totals, with sub-totals. On sheet 2, I have a data set with 3 columns (colors, dress, type). On Sheet 1, I will need a ...
0
votes
1answer
99 views
Macro to count the number of text strings in sheet in Excel 2003
I have a worksheet for scoring.
I have a list in the first sheet that will be for data entry starting with a2 and going down the sheet, this is for Player names.
I have a summary sheet named "Place" ...
1
vote
1answer
126 views
Automatically select last row in a set in Excel
In Excel 2003, I am trying to keep track of some petty cash, and have it set up with the denomination along the top row, along with a sub total and difference column. I want a small section that shows ...
1
vote
1answer
172 views
Create or Open an .xlsx file having >256 columns in MS Excel 2003 with compatibility pack installed
I'm using Microsoft Office 2003. I have installed 'Microsoft Office Compatibility Pack for Word, Excel, Powerpoint 2007' to support new xml based formats (.docx, .xlsx, .pptx).
Now given that I have ...
0
votes
2answers
100 views
How to clear all value cells in an entire 2003 Excel workbook by one go?
How can I clear all value cells in an entire 2003 Excel workbook by one go?
I could do one sheet by going to special functions, however, if a file is composed of many sheets, it would take a lot ...
1
vote
2answers
46 views
Hide a number that comes before the text of a column in Excel?
I have a column like this "2;#Vendor", I want to display only "Vendor".
How can I do this?
0
votes
0answers
52 views
Extract features from an Excel Workbook and reconstruct it based the exported information
I have a rather complicated Excel 2003 workbook that crashes from time to time.
I find that if I reconstruct the workbook from the ground up (it means a long painful process of export and reimport ...
5
votes
4answers
2k views
Excel's date format without a year
I'm putting in employees' birthdays, but they come without years for sensitivity reasons. But when I put the month and day in, Excel automatically adds 2012 as the year! Obviously this is not right. I ...
0
votes
2answers
386 views
Excel 2010 formula conversion to Excel 2003
I am by no means overly proficient with Excel, I know enough to do the basics.
After much forum and soul searching I had come up with the following formula, which I will discuss what it is supposed ...
0
votes
0answers
211 views
Can I convert excel 2003 addin files into Excel 2010 xlam programmatically?
I read the doc here: http://office2010.microsoft.com/en-us/excel-help/use-office-excel-2010-with-earlier-versions-of-excel-HA010342994.aspx#BM4
which says
On the File tab, click Info, and then ...
3
votes
2answers
662 views
Move to end of selection in MS Excel (2003)
I have a large set of data that I update regularly by copy/pasting and overwriting old data. I do this for 10k-15k records at a time. Once I have pasted, I manually scroll down to the last line of ...
5
votes
3answers
930 views
Converting decimal number of hours into time
I need to convert number of hours, such as 156.90 to 156:54 in excel 2003.
All of the conversions I found did this incorrectly. The number of hours shouldn't be changed, only the decimal.
0
votes
2answers
110 views
Compute the first digit of an integer in Excel
I have a spreadsheet with column B having integers. I want to get the first digit of each entry in column B in the corresponding row of column C.
1
vote
1answer
224 views
Microsoft Excel 2003 - Merge by Column
I'm trying to merge two excel files, here is the structure of the files:
[A] [B]
I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...
0
votes
2answers
129 views
How can I speed up my macro in Excel 2003?
I have a macro that copies data from one cell to another and uses a VLOOKUP formula, among other things. My spreadsheet contains nearly 2000 rows.
When I run it in Excel 2003, Excel starts to slow ...
1
vote
1answer
172 views
Why has Excel stopped offering to sort adjacent Columns?
Xp3.
Excel 2003 (11.8346.8341) Sp3
In the past, whenever I selected a columns that was next to another column and selected "sort", Excel would offer to sort the adjacent columns well. This was very ...
0
votes
1answer
66 views
Copying and pasting in Word and Excel
I recently started having problem with pasting tables between Word documents and from Excel to Word. For some reasons it pastes table without frame, just disorganized text. It is very annoying because ...
4
votes
2answers
5k views
Why is Excel removing leading leading zeros when displaying CSV data?
I have a CSV text file with the following content:
"Col1","Col2"
"01",A
"2",B
"10", C
When I open it up with Excel, it displays as shown here:
Note that Cell 2A attempts to display "01" as a ...
2
votes
3answers
1k views
To much text for an Excel cell
What do I do when I have more text in an Excel cell than I want to (was "can") show in the allocated space?
(Something making it "scrollable")
0
votes
4answers
97 views
How to resolve #NAME? error in Excel?
I'm use Excel 2003. There is numeric information in Cell AI in my Spreadsheet. The cell is formatted as numeric with 4 decimal places. In Cell AK, which is also formatted as numeric, I type =AI and ...
1
vote
1answer
940 views
COUNTIF Duplicate Detection
I have created a formula (excel 2003) to output a "1" if duplicates are found in a column.
=IF(COUNTIF(A$2:A$10750,A2)>1,"1","")
For some reason this formula does not mark the last duplicate in the ...
1
vote
1answer
160 views
Source File not updating Destination Files in Excel
I have one source file that holds all my input costs. I then have 30 to 40 destination files (costing sheets) that use links to data in this source file for their various formulae.
I was sure when I ...
0
votes
1answer
344 views
How to make Excel application load some xll files via vbs?
I need to be able to load the xlls into an instance of Excel.
It is easy to do so using the GUI. Just use 'open file' dialog box and load the xll file.
However, how I can script this behaviour ...
0
votes
2answers
293 views
Programmatically updated a cell's formula in one PC shows #Name in another PC
We have a lot of spreadsheets and there is a need to upgrade an important Addin.
The change will involve converting an old formula to a new one. It is not a straightforward change because the name ...
1
vote
1answer
6k views
How do I group rows in a spreadsheet and keep them together after sorting?
I have a spreadsheet with the information set up as such:
ORDER PLU/Recipe # Name/Desc Components
2 27905 CINNAMON CRUMB CAKE SQUARES
2.01 ...
1
vote
2answers
700 views
Can I use “Fill Down” to make a vertical series reference a horizontal series?
Say I have a data series going from A1 to E1. I would like to make a second copy of these cells going vertically, for instance from G1-G5. I can achieve what I want just by typing =A1 into G1, =B1 ...
2
votes
3answers
133 views
Convert Excel data
I've made a survey in Sharepoint and want to convert the results into something useful in Excel 2003. My problem is the format the responses are in for some questions.
An example of two responses ...
0
votes
2answers
890 views
Get all linked files to an Excel 2003 document
I want to get a list of all the linked files in an Excel 2003 document, or, better still, automatically retrieve all the files linked to the document and zip them. Is such an operation possible? I am ...
2
votes
2answers
359 views
Rearranging a 15 X 25 Excel matrix into three columns
In Excel I have data in cells from A1 to O5 (15 X 25).
I wish to rearrange things such that I have the following
[A1][B1][C1]
[D1][E1][F1]
[G1][H1][I1]
[J1][K1][L1]
...
0
votes
1answer
1k views
How to use multiple criteria with COUNTIF?
INPUT:
This is the format of the OUTPUT desired:
OUTPUT for example INPUT:
The problem is, I don't know how to use COUNTIF with several criteria.
The "dream function" [that doesn't work] ...
0
votes
2answers
176 views
Template is working for Excel2003 but not for Excel2007
I created an Excel worksheet (Book.xlt) under
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
with my own setting.
That settings are occurring only for Excel2003(.xls) ...
0
votes
2answers
325 views
Properties of cell editor in excel
How to make excel cell editor property as text by default in excel.
Actually cell property is general.How can i make that as text in excel
(Right click on excel cell editor
click on format cell
...
5
votes
3answers
37k views
How to open ods files in Excel?
What is the best way to open ods files in Excel 2003?
Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)?
The file I ...
1
vote
1answer
311 views
How to dynamically link a spreadsheet to another
I have two spreadsheets in the same workbook. Users are entering data in a table of the Sheet1 and I would like to duplicate that same table in the Sheet2 dynamically. In other words, I don't want to ...
1
vote
2answers
1k views
Link two excel workbook located in different computers
I have two excel workbook
The first one located in one computer (i.e. "\192.168.7.1\Shared\book1.xls")
The second one in another computer (i.e. "\192.168.7.2\Shared\book2.xls")
With both spreadsheet ...
0
votes
2answers
682 views
Remove duplicate rows in excel when not all the columns are the same
How can I automatically remove duplicate rows in Excel when data->filter doesn't work, because the columns aren't all the same?
I believe the picture explains what I need, but I can probably supply a ...
1
vote
2answers
235 views
How could I get the text defining an Excel formula for one cell into another cell?
In other words, if the value of a cell, say A1, is =Date(), then displayed in cell A1 I will see the date, but then I want B1 to be =FuncText(A1), then I want to see 'Date()' displayed in cell B1.
To ...
0
votes
1answer
249 views
Why is Edit->Links disabled when I open my sheet?
I want to use the function to see what other spreadsheets a particular file, says MySS.xls, is linking to. But somehow the 'Link...' is disabled.
I have unprotected MySS.xls.
Why is it so? How can ...
0
votes
1answer
32 views
Double-Click URL to Follow in Microsoft Excel 2003?
I want to automatically follow a hyperlinked cell when double-clicked, not single-clicked.
Can I configure this?
