All Questions
35
questions
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 ...
- 1,955
5
votes
3
answers
38k
views
How to find the last value in a column in excel?
I am tracking rooms booked in a hotel on a daily basis in Excel. Every day I input the number of rooms booked in a column to show a trend of pick up over a period. I'd like to return the value of ...
- 51
5
votes
4
answers
15k
views
Using two conditions with a SUMIF function in Excel 2003
For a given row on Sheet1, I use the SUMIF function to see if the value from the first cell of that row is on a list of historical values in Sheet2.
That will basically summarize all the values on my ...
- 705
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 ...
- 195
4
votes
4
answers
20k
views
Excel formula to display a string of text and numbers
I need one column to show the following text: prxyz,(data1 here),0699,ABCD(data2 here),xxx
data1 is in column A and data2 is in column B.
the format of data1 needs to be 5 numbers (sometimes ...
excel gamine
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, ...
Matteo
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(...
- 373
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 (=...
- 155
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'...
- 131
2
votes
2
answers
212
views
How to extract remainder of a match of 5 digits in 9
I am trying to extract the "remainder" (the non-matching portion) of a search using Excel 2003. I tried using various combinations of functions but it seems that there's no specific function that can ...
2
votes
1
answer
550
views
how to determine which values in a given set of cells will add up to a numerical range
In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers:
1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16
26 ...
- 21
1
vote
3
answers
1k
views
Excel select column
In excel, if I want to perform a function with the column to the left, how do I go about this?
- 113
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 ...
- 1,866
1
vote
3
answers
3k
views
Sum Column, but only Filtered Rows
I have a large flat file of a bunch of ungrouped primary key values.
I want to filter on a key and populate cell A1 with the value selected from the dropdown list.
In the end, I want to see a sum of ...
- 310
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