# Tagged Questions

**0**

votes

**1**answer

42 views

### Excel 2010 offset function returns #VALUE! error

I'm trying to use the offset function in excel 2010, but it gives me a #VALUE! error.
The function works perfectly, if it's like this:
...

**0**

votes

**0**answers

34 views

### Excel function with the same name as cell reference

I'm using an add-in to Microsoft Excel called Isoplot, it's used for analysing and processing radiometric data for dating geological materials etc.
One of the user defined functions is intended to ...

**0**

votes

**1**answer

37 views

### =randombetween with a certain percentage between a narrower range

I want to randomly generate dates (within a four-year period) for 32 different records/rows in excel.
Additionally, I want 75% of those dates to be during one year in particular (within that four ...

**0**

votes

**1**answer

54 views

### Excel - Concatenate words separated by “_”

I need help with the following problem:
My column in A2 in Excel has the value: TB_PLACES_NAMES
But I need to separate the "_" from the others words in the same column.
I've tried this function:
...

**0**

votes

**1**answer

262 views

### Converting Monthly data to Daily data on EXCEL for MAC

I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular ...

**4**

votes

**1**answer

345 views

### ms excel find and replace @ symbol results in broken formula

I'm trying to search and replace in excel, the column is formatted as 'Text'.
Find: [@
replace with: @
Whenever this finds a match at the start of a cell i.e the cell contents start with [@
and ...

**0**

votes

**3**answers

100 views

### Excel - Referring to a certain cell based off of data in another

I have a spreadsheet where there is one table with the headings:
Coordinate, Lat, Long
Another with headings
Triangle, Coordinate 1, Coordinate 2, Coordinate 3, Area
What this is for, is taking ...

**0**

votes

**2**answers

171 views

### Excel VBA Right Function Error

I'm trying to automatically update the date range on the top of my report in Excel based on the date range from data I download from a text database. In the below listed macro I get a Run-time error ...

**0**

votes

**1**answer

412 views

### Ignore “[Value_if_false]” when value is true

In Excel, I am using an IF function and using the OFFSET function to assign a value in the [value_if_true] and using a 0 for the [value_if_false]. The true OFFSET function was occasionally returning ...

**2**

votes

**1**answer

807 views

### Excel formula for one cell to repeat across a different column (perhaps IF command)

I'm wanting to look up if a series of values (Column N) fall within a specified range.
Currently trying this:
=IF(AND(N:N<=C2,N:N >=L2),"YES","NO")
This does not properly work. I want to ...

**3**

votes

**1**answer

3k views

### Combining two IF functions in one cell using Excel 2010

I have these two IF functions that work correctly on their own. I need to combine the two into one cell but can't seem to get them to work. Any help would be appreciated. And thanks in advance.
...

**1**

vote

**2**answers

4k views

### Excel- If multiple cells in a range are blank, return an answer

In Excel (365 edition), I want to have a formula determine whether in a range of 5 cells, 3 of those cells are blank. If there are 3 cells, I want it to display INELIGIBLE, if there are fewer than 3 ...

**2**

votes

**1**answer

787 views

### Excel: Reverse VLOOKUP with comparaison

I have an original table (the value column is sorted):
name | id | value
--------+-------+-------
abc | 1 | 12
def | 2 | 15
ghi | 3 | 23
jkl | 4 | 29
...

**0**

votes

**0**answers

30 views

### Excel String compare [duplicate]

I am trying to compare string and then display the what doesn't match between the two of them, for example:
take A1 which contains [alpha:beta] and then B1 which contains [alpha] and it will match ...

**1**

vote

**1**answer

323 views

### Call on a cell in Excel up to the first semi-colon

I am using the =CONCATENATE function, and one of the cells I'm calling on I only want to take the value in the cell up to the first semi-colon. Is this possible, and if so how?

**0**

votes

**1**answer

173 views

### Easy MS Excel - MIN column with IF condition checking another column

I'm analyzing some personal expenditures for somebody on Excel.
I have a column for calendar dates and a column for expenditures on that date.
Of course, there are days when there are no expenditures ...

**0**

votes

**1**answer

114 views

### How to get the data from one cell to alter the function of other cells

I have 10+ worksheets, with the same layouts, all containing data from different days jobs. I am trying to create a "SimpleSheet" that only pulls specific data from one days sheet in a nice layout. So ...

**1**

vote

**0**answers

33 views

### Custom function COUNTIFUNIQUES in Excel [duplicate]

Possible Duplicate:
Excel: how to count number of distinct values in a range?
I would like to create a custom function COUNTIFUNIQUES that extends the functionality of COUNTIFS.
Here is an ...

**0**

votes

**2**answers

2k views

### How to divide the sum of cells by 7 and then transpose them in Excel

I need to take a vertical row of numbers in excel and add them all and divide by seven. I then need to transpose the result into 7 equal rows (one for each day of the week.)
I have tried the ...

**1**

vote

**1**answer

866 views

### Returning The Name of the highest value field

I have 4 field of Numeric Values, I want Excel To pick the highest value of them and show me the name of the field that is related to the highest one, for example:
Option 1 (J10) Option2 (K10) ...

**0**

votes

**2**answers

180 views

### How do I add a value to a cell in Excel if it's an int?

I have an Excel table with some cells that are numbers and some cells that are strings. I want a function that can add search through the table, and if the cell is a number, add it(+) and if it's a ...

**1**

vote

**2**answers

2k views

### How to generate a round-numbers graph in Excel?

folks!
Now, I have an Excel file with measurements I made of some color patches (I work at a Press company), with a device called spectrophotometer.
Here it is:
...

**0**

votes

**1**answer

801 views

### IF function that refers to another cell if true

Can someone please help?
I am using the IF function to find cells within certain ranges, but want the cell to contain the value if it falls within that specific range.
for example:
=IF (AA3 is ...

**1**

vote

**3**answers

503 views

### Using a pre-existing function for a new row

I have an Excel document that contains X columns and N number of rows.
The very last column of a row performs a SUM of the first X-1 columns. The problem I have is, the user of this Excel document ...

**3**

votes

**2**answers

6k views

### Excel - define a formula in one cell to be used in other cells with different inputs like a function

I use excel 2010.
I want to use a formula defined in one cell as if it was a user-defined function.
Example:
In A1 I put something like (I know it's not a real syntax):
= 3 * Input + 15
And then ...

**0**

votes

**1**answer

1k views

### split a large excel into smaller files but include the header in all files

I have a macro that I use to break large excel spreadsheets into smaller files. It works perfectly, except, it only uses the header row in the first file created and this header row (row 1) needs to ...

**1**

vote

**2**answers

490 views

### Excel macro date parser cannot handle single-digit days

From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function:
Function GetDate(strInput As String) As Date
...

**0**

votes

**2**answers

915 views

### Multiple IF Then Function

I know this shouldn't be this difficult, but what I am looking to do is
I want a total in A5 based on a running total in A1 through A4.
For example, if A4 is blank then input A5=A3, if A3 is ...

**5**

votes

**4**answers

11k views

### Excel VBA Function runtime error 1004: Application-defined or object-defined error

I'm trying to learn functions for the purpose of simplifying and reusing code whenever necessary.
I began by turning something I use pretty often into a function: Returning the integer value of the ...

**0**

votes

**1**answer

287 views

### When switching to another doc, Function Argument window disappears?

I have problem with Excel 2007 when using VLOOKUP function. After switching to another document for referencing value in "Table_array" field, window dissapears.
Google finds some results about the ...

**1**

vote

**3**answers

6k 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 ...

**1**

vote

**1**answer

172 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 ...

**1**

vote

**2**answers

322 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 ...

**1**

vote

**3**answers

9k views

### How do I assign a number value to a non-numerical value in Excel

I have some survey responses with values like "VU" for "Very Unlikely" and "S" for Sometimes. Each survey response occupies a cell. For each cell containing a survey response, I want to fill another ...

**0**

votes

**2**answers

292 views

### EXCEL generate a character in one column of a row, only if other columns in the same row are not blank

My speadsheet keeps track of when patients leave a specific floor of the hospital. There are columns in which where each patient goes is documented (1 column for "home", another column for "rehab ...

**2**

votes

**2**answers

1k views

### Excel Table lookup with indexes in multiple columns

I have a Table in Excel the looks about like this:
Test1 100 test2 200
Test3 110 test4 210
Test5 120 test6 220
I want a function that, given test 1 as input, will return 100 AND given ...

**1**

vote

**1**answer

122 views

### Return the date of the day under an if formula with Excel or VBA

I have two columns A and B and many lines with some specific tasks to be done. In column B, I have a drop-down list with the name of people who are scheduled for the task . And in column A, I want the ...