All Questions
693
questions
61
votes
2
answers
8k
views
Excel - can I set a cell to equal a certain value, no matter what is typed in it?
This is to play a joke on someone...not sure if it's possible to do what I want. We are circulating an Excel file among friends to select players for a golf tournament. I would like to set a cell (...
40
votes
17
answers
398k
views
How to get the current column name in Excel?
What is the function to get the current line number and the current column name for a cell in Excel?
21
votes
4
answers
165k
views
Dynamically reference a Named Table Column (via cell content) in Excel
How do I reference an Excel table column dynamically in Excel 2007?
I want to reference a named column of a named table
and the referenced column will vary with the value of a cell.
I have a table in ...
20
votes
5
answers
18k
views
How do I get the =LEFT function in excel, to also take the number zero as the first number?
My data contains a column of room numbers. Each room number's first 2 digits is the floor number where the room is located. The =LEFT function works well for data that does not start with zero. The =...
18
votes
7
answers
123k
views
Microsoft-excel newlines and tab
Current I use "CONCATENATE" to join string in Excel, but I want insert character newlines and tab in string joined by "CONCATENATE".
Example:
I've string below when I completed join string.
"Today ...
15
votes
5
answers
432k
views
How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?
I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
12
votes
2
answers
27k
views
How to generate random string from a set of available strings in Excel?
I want to generate a column which will have random string values in any order. Those string values have to be from ('New', 'Mint', 'Very Good', 'Good', 'Acceptable', 'Poor') strings? Can anyone let me ...
11
votes
5
answers
214k
views
How to combine values from multiple rows into a single row in Excel?
I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this:
...
10
votes
4
answers
189k
views
When I copy table data into excel, it ONLY pastes it into column A! How to fix this?
If I use the following link:
http://web.utk.edu/~dhouston/excel/exam1.pdf
to copy the table and paste it into excel, it will only paste the values into one long column in Column A (and each row has ...
9
votes
6
answers
65k
views
Convert Text Value to Time Value in excel
I am trying to convert text to time. Basically I copy and pasted the total time of employees but it pastes as text value and then in order to add the time I have to convert it to time and I have to ...
9
votes
2
answers
24k
views
How can I turn a Calculated Column back into a data column in an Excel Table?
I have a large Excel Table (44 columns, 1000+ rows), but one of the columns has been accidentally turned into a Calculated Column (See Here). The result being that now when the users try to add new ...
9
votes
3
answers
146k
views
Subtracting cells only if they have a value in Excel
I want to subtract two cells in excel but only if both cells have a value. More specifiaclly in my case the formula in cell E2 is currently =D2-C2 but I only want this to be calculated when D2 has a ...
7
votes
1
answer
221k
views
Need a formula that looks at the first digit or letter in a cell
I have a column of numbers. Some begin with the digit 8 and the rest begin with other digits. I want to write a formula that will return "2" if the number in column A starts with 8, and "1" if the ...
7
votes
3
answers
30k
views
Exclude outliers from average calculation
I want to calculate the average of numbers given in Column A as shown in the figure below. But I want to base the average on values equal to or greater than 15 and equal to or less than 25, via the ...
7
votes
2
answers
87k
views
Conditional Formatting in excel based on another column
I have an excel worksheet and two columns. I highlight the first column if the value of the cells are less than 0.
Now how can I highlight the second column cells based on the first columns that are ...