All Questions
Tagged with microsoft-excel worksheet-function
7,324
questions
10
votes
2
answers
231k
views
What is the difference between function and formula in Excel?
What is the difference between those two when speaking of Microsoft Excel?
0
votes
1
answer
128
views
How do I ensure only integers and with no duplicated values can appear in a column in Excel 2007?
How do I ensure
only integers
with no duplicated values
can appear in a column in Excel 2007?
1
vote
3
answers
6k
views
How to input only unique values in a column in Excel 2007
I'd like to know the easiest way to make sure that only unique strings are entered in a particular column in MS Excel 2007? I know I have to put a formula in the Data > Data Validation, but I don't ...
-1
votes
1
answer
1k
views
How to make this formula to work in Excel 2007?
How would one make this formula =MAX(LEN(A2:A9)) work in Excel 2007?
I want the value of the longest field in A2:A9 range.
I found this link: http://www.mrexcel.com/td0021.html, but it's old now.
1
vote
4
answers
13k
views
Does Excel have a row filtering function (more general version of SUMIF/COUNTIF)
SUMIF and COUNTIF functions are handy for simple SUM and COUNT operations on only some of the values in a range, but is there a more general version that would allow me to plug in any other function I ...
3
votes
5
answers
42k
views
Excel - Delete specific word in each row?
Is there a way to have Excel delete a sepcific word in every row? For example, each row says Mr. and Mrs. {first name} {last name}, and I want to delete the {first name} from each one. (Or ...
0
votes
1
answer
267
views
Excel formula - sometimes array formula, sometimes not
I want to write some data to an Excel file, and I want the first page to show a summary of the data that are spread all over the sheets. The individual data items on a sheet can be included or ...
0
votes
3
answers
533
views
Formula in Excel
Below is the data:
A B C
xxx 2 5
xxx 3 4
bbb 2 3
bbb 2.5 2
nnn 1.5 2
nnn 2 1
I want to ...
11
votes
1
answer
43k
views
Shortest Method To Reference A Single Row/Column of a Named Range in Excel?
I have a named range (NamedRange1) and I need to reference the first row and first column of that range within a formula. I came up with the following:
First row:
INDIRECT("R" & ROW(...
5
votes
2
answers
16k
views
Excel row-wise multiplication
I would like to multiply, row-by-row, two columns in an Excel sheet (in order to take the median of the resulting column).
1 3
2 5
4 2
Should become
3
10
8
How can I do that in a formula (i.e. ...
1
vote
1
answer
233
views
Replicating common Excel Functions
I am always curious how some of the functions I use in excel were written, and think it would help at times to see how it was done.
Does anyone know where there is example vba that replicates what ...
0
votes
2
answers
3k
views
excel - merge cells including a zip code
I have the need to merge a bunch of cells that comprise an address (street, city, state, zip) into a single cell. No problem except with the zip code.
The zip cell has only 4 digits for any zip ...
0
votes
1
answer
798
views
Excel, Lookup special characters and spaces
I have an excel, spreadsheet that has multiple sheets.
The first sheet is an index of files, I am using the following forumla to look up a value in column A, references against the index sheet, if it ...
5
votes
4
answers
35k
views
How to calculate hours and minutes between two time periods?
I’m working on a very simple time sheet for my work in Excel 2007, but I have run into trouble about calculate the hours and minutes between two time periods.
I have a field: timestart which could be ...
1
vote
2
answers
541
views
Conditional Lookup in Excel
I want to use excel to compare pairs of numbers from the "Pre/Post" column of the following data:
Student Course Pre/Post Score
K300997203 FHS120100417 Pre 3
L286197217 ...