All Questions
35
questions
-2
votes
2
answers
991
views
Nested IF formula
I have:
in *Column F* in *Column S*
F2 Monday S2 Orange
F3 Tuesday S3 Mango
F4 Wednesday S4 Grape
F5 Thursday S5 Pawpaw
F6 Friday ...
0
votes
1
answer
3k
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 ...
5
votes
2
answers
27k
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 ...
0
votes
2
answers
1k
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 ...
0
votes
2
answers
835
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
2
answers
7k
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.
2
votes
3
answers
210
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
2
answers
2k
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 ...
2
votes
1
answer
171
views
In Excel, how do I highlight all rows that do not contain “,2”?
I'm verifying the FormatCurrency function is written properly in ASP code and I put everything in Excel from "find results".
I want to highlight only the ones that do not contain ",2" in them.
Don'...
0
votes
2
answers
243
views
Excel Multiple Conditions Summing
I have Column A to A1600. In that column I have two project names "CP" and "GFI", in column B I have Project Phase 1-8, in column C I have the hours worked in each phase. The projects intertwine so ...
1
vote
1
answer
557
views
How to calculate the total sum of hours with automatic filter
I have an Excel sheet where I sum hours to get the total amount of my work.
It works without problems, but if I add an automatic filter I'd like the calculations to be done only on the portion of ...
3
votes
1
answer
5k
views
Random Excel bug when referencing a different sheet
I am getting a very strange error anytime I try to use a formula pointing to a cell in a different sheet from the active one (even as simple as "=Sheet2!A1"). This started happening all of a sudden, ...
2
votes
5
answers
2k
views
Excel not properly recalculating values
I have an Excel sheet with values in it (this sheet is generated by a custom perl script, but I don't think that's where the problem lies). In it, I have a formula:
=sum(indirect(concatenate(address(...
1
vote
1
answer
20k
views
Excel: Calculating working hours between two dates
Summary:
I know that the function NETWORKDAYS can be used to find the number of business days (=excluding weekends and holidays) between two dates. But what if I want to know the number of business ...
27
votes
1
answer
124k
views
How do I put logical operators in an Excel =IF Formula?
I'm trying to enter a formula to display text according to an IF condition. The best I can manage is something like...
=IF(myval>=minval & myval <= maxval, "OK", "Not OK")
But this appears ...