Questions tagged [microsoft-excel-2003]
The 2003 version of Microsoft's spreadsheet application.
277
questions
1
vote
1
answer
40
views
Conditional concatenation Excel 2003: if text TRUE, add asterisk
=CONCATENATE(A1)=IF(ISBLANK(F1),"","*")
If there is text in column F (not just a blank space), I want to add an asterisk to the value in column A. I only want to see TRUE for H3 ...
0
votes
1
answer
288
views
Count how often value occurs in groups in excel
I have a list of values and want to count how many times values exceeds 400, but if next row values also match this criteria this should not be in counting.
COUNTIF formula is of no use in this case I ...
0
votes
1
answer
7k
views
How to conditionally format if not on list?
Every tip online about conditional formatting and a list is about highlighting cells that match on the list. How can I highlight cells that don't match (ignoring blank cells).
For example, a list of ...
- 5
0
votes
1
answer
112
views
Excel macro to highlight common values between two different sheets
I'm having list of account numbers(AA, AAB, AAC, ADC) in column A in sheet 1 and also I'm having some common account number in sheet 2 (AAB,ADC)which is already available in sheet 1. Now i need a ...
- 11
0
votes
1
answer
182
views
Display (or get at least) certain cell last modification date in Excel 2003 file (file extension is *.xls)
I have some Excel table which I filled with values since 2004.
To sad I didn't include each row add date in extra cell. Now I want to know that...
Maybe it still possible? Maybe *.xls file store that ...
- 205
1
vote
2
answers
2k
views
How to insert a line break in a concatenated cell in Excel 2003
In Microsoft Excel 2003, I use the following formula [in cell A2 in a sheet named (Allocation)] to refer to several cells from a sheet named (02Mis)
='02Mis'!$A$4&"/"&'02Mis'!$A$11&"/"&...
- 249
0
votes
2
answers
244
views
Excel 2003 in Windows 10 - single instance/dde?
I'm running Windows 10 and Excel 2003 (it runs much faster than newer versions of excel).
The problem is that I generally prefer most files to open in the same instance of excel.
Is there any way to ...
- 21
2
votes
1
answer
170
views
Calculating the cost of the electricity consumption
in Excel 2003, I use the following equations to calculate the cost of the electricity consumption.
I have to use different equations for different consumption slice situations.
The next figure shows ...
- 249
1
vote
0
answers
394
views
Difference between VBA for Excel 2003 running on Windows 10 and Windows 7
Okay, I have an oddly specific situation: I made a bunch of macros and Visual Basic code in an Excel 2003 Spreadsheet running on Windows 7. The product has been working perfectly for one and a half ...
- 11
-2
votes
2
answers
1k
views
Condense column data with many blanks
I've seen this and similar methods posted here and elsewhere:
How can I condense a list that has missing data to a new list without the cells with missing data?
I have patient data, basically like ...
- 11
0
votes
1
answer
276
views
Fixed cells width and height in Excel 2003
In Excel 2003, I want all the cells have width and height fixed to 2cm by 2cm; How can this be done?
- 249
1
vote
1
answer
672
views
How do I add 1 month to a specific date once that date has passed?
I have an excel sheet that lists our current due date. The due dates are the same day of each month (9/2, 10/2, etc) and I want the due date to update once the old date passes so I don't have to do ...
- 23
1
vote
1
answer
175
views
Worksheet limit in Excel 2003 (BIFF8)
Is there a limit in the number of worksheets ("tabs") allowed by the Excel 2003 format (aka BIFF8)?
I can find plenty of information about rows and columns but not worksheets.
- 1,571
0
votes
4
answers
17k
views
Need excel function to filter alpha characters
I have a column in excel file which is mix of set alphanumeric,number and alpha character , I want to filter out alpha character only. Need advise..
Column 1
100054
Mk1568
Un10008
Dngh
34677
Gopro
0
votes
3
answers
124
views
Joining 3 Excel IF Statements
I'm trying to join the following 3 IF statements in Excel but every time i try i get an argument error or else it reverts back to displaying "True" or "False" instead of "Miss Window", "Hit", "Not ...
- 55