Questions about using in-cell functions/formulas in spreadsheet software.

**0**

votes

**1**answer

37 views

### Search Excel price grid with variable values

WIDTH
DROP 1150 1550 1850 2160 2360 2750 3000 3480 3980 4450
1200 338 348 378 413 431 450 467 513 ...

**-1**

votes

**1**answer

37 views

### How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ?
So, this...
A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB
...should split as below,
B1 ...

**0**

votes

**1**answer

92 views

### Excel formula to sum all entries in a row if value of adjacent cell is equal to third cell [duplicate]

I need to build a formula that will sum the numbers in a series of cells only if the value of an adjacent cell is equal to the value of a third cell.
The latter two values are text.
In plain ...

**0**

votes

**2**answers

44 views

### Excel 2007 IF AND function calculation not copying across

I'm using an IF AND function, which is:
...

**0**

votes

**1**answer

30 views

### How to lock a cell with formula in excel after the referred cell is filled?

I'm using "CONCATENATE" formula in excel and I would like to lock (or turn the formula into value in) the cell which contains the formula after the last referred cell is filled. Some of the referred ...

**0**

votes

**1**answer

56 views

### SUMIF with multiple match criteria in Excel

I'm trying to create a formula so that if in cell E2 it says "Market", "Limit", or "Stop" it adds the numbers in cells L2 and M2.
=SUMIF(E2, "Market" "Limit" "Stop", L2+M2)
These expressions are ...

**0**

votes

**2**answers

61 views

### Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF

Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS.
There is a mistake in my formula but I can't find a way to have it since ...

**0**

votes

**2**answers

162 views

### Excel compare two columns and list a third column

I have an Excel sheet which has 3 Columns:
A B C D
1 A 1
2 B 3
3 C 4
6
5 D
7 E
I want to check column C for values present in column A and list corresponding values of ...

**0**

votes

**1**answer

45 views

### Conditional formatting in Excel 2013 for C8=blue and bold if C5>C2

This is part of a problem for college for which I can't find a solution.
Q: Use conditional formatting to format, in blue and bold, the value in column 8 for which the value in column 5 is greater ...

**-2**

votes

**3**answers

58 views

### How to decrease the number of sheets in a workbook [closed]

In a new Microsoft Excel workbook (2010) I have three sheets by default. Suppose that I suddenly press the Insert worksheet button next to the Sheet3, so the forth sheet will become added to the list ...

**3**

votes

**2**answers

95 views

### Sum of N-highest number in a series excluding duplicates

I had gone through the thread Sum up to N-highest value of series and it's not exactly what I need. e.g.
=SUM(LARGE(Range;1); LARGE(Range;2); …; LARGE(Range;N))
The question is if the data set has ...

**0**

votes

**1**answer

43 views

### Excel - sumproduct/sumif

I am able to look up single values that meet multiple criterion; but I would like to do more, I want to sum up values that meet two conditions - year and country like in my example. I tried it in my ...

**0**

votes

**1**answer

20 views

### Formula that looks at value in a cell and depending on what the value is

I'm using Excel 2010
I have a number in cell A1.
In Cell B1 i need a formula that says if the number in cell A1 is 25 then put 'account1', if the number in cell A1 is 58 then put 'account2', if the ...

**1**

vote

**1**answer

60 views

### Excel - Change cell colour based on a date in the comment or mixed in with text

I am using excel 2010 and I am trying to set up a rule that will change the colour of a cell based on a date within that cell.
For example the cell may contain Site meeting - 11.05.14
I would like ...

**-1**

votes

**2**answers

41 views

### Excel - comparison of text between two columns [closed]

How do I compare two or more columns in an Excel worksheet to identify the difference. The comparison of two columns is related to text and not the numbers. Please advise.

**0**

votes

**4**answers

128 views

### Excel COUNTIF Slow

I'm having an odd issue in excel that I haven't run into before. I have an excel sheet that I'm attempting to pull some specific records from, requiring that I know of duplicates. I am using a COUNTIF ...

**0**

votes

**1**answer

24 views

### Excel 2010 Countif Formula

I'm trying to make a spreadsheet to display stock orders. I am including both executed and unexecuted orders, but I'm trying to display how many orders did or did not execute using Countif. My orders ...

**0**

votes

**2**answers

48 views

### Google Spreadsheet/Excel filtering

As you can see in this image I have spreadsheet of many athlets, that will participate in competition.
My task is using groups (or ranges) DISCIPLINAS (en. Disciplines), which contains 100m run, ...

**1**

vote

**0**answers

28 views

### How to combine data from multiple sheets into 1 main sheet in calc

I have an excel file which gets generated from various database servers on fly by executing sql. Separate sheet gets generated for each server. Now I simply want to combine data of all sheets. Each ...

**0**

votes

**1**answer

35 views

### Matching grades to names in separate sheets

I'm having some trouble with an excel formula. What I have in sheet A is a list of student names in (Fname LName) format, and then I have the same list of students in a separate sheet along with exam ...

**0**

votes

**1**answer

64 views

### Excel formula for tracking tasks and workload on two tabs

I created a spreadsheet at work to track all of the classes taught for us during the year. It helps us with scheduling and it helps us plan our budget for part time instructor payments. We have full ...

**2**

votes

**2**answers

65 views

### Can I use the Excel Match function to match on more than one type of value

In another question I posed recently I was shown how to use the Excel Match function to query my data in order to produce a summary type table:
Creating a formula that queries data in Column B based ...

**0**

votes

**2**answers

68 views

### In Excel, checking if a cell matches one item from a named constant string list

This question is an expansion on In Excel, how do I check if a cell is in a list of values (a range of cells) .
I'm trying to do =COUNTIF(name,G6) and when name refers to some cells, it works fine, ...

**0**

votes

**2**answers

50 views

### Creating a formula that queries data in Column B based on a selection from Column A in Microsoft Excel

I am reasonably familiar with Excel formulas but I need to construct a more complex query and am not having much success at the moment.
I have simplified what I am trying to achieve for the purpose ...

**3**

votes

**1**answer

294 views

### How do I download a stock price in Excel 2013? Is there an equivalent to Google Doc's GoogleFinance spreadsheet function?

In a Google Docs spreadsheet, I can use this cell formula:
=GoogleFinance("GOOG", "price")
to download the latest price of a stock. Is there an equivalent function in Excel 2013?
Earlier versions ...

**0**

votes

**2**answers

39 views

### Excel Count number of cells based on three dependent selects [duplicate]

I am looking to count the number of cells based on three dependent select statements. each select corresponds to a column.
For example,
Select nth-Day (Column A)
Select Issue Type (Column B)
...

**1**

vote

**2**answers

85 views

### Excel SUM function for whole column?

How can I sum the whole column without freeze head?
I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, ...

**0**

votes

**2**answers

97 views

### Excel Convert XML cell to columns

I have an excel spreadsheet with XML in a single column. I know that you can import XML data into Excel; but only imports the entire file. However, I need to do this on a cell by cell basis.
With ...

**-2**

votes

**2**answers

45 views

### identify the rows with the lowest values in an array based on identical values in a column of that array

I have an array of product data which includes code, description and cost. code is unique, cost is numeric and description is non-unique. Please see example. How can I select the cheapest of each ...

**0**

votes

**1**answer

25 views

### I want to map rows from Sheet one on and excel file to other sheets if they meet certain criteria

I work in sales and cover a large territory. To manage the territory, I break it up into "Zones" (i.e. Philly / Pittsburgh / etc). My organization provides an excel file with every company I call on ...

**3**

votes

**3**answers

71 views

### Custom user function without using VBA

Is it possible to create a custom user function in Excel without using VBA?
My problem is I have a long string of standard excel functions strung together to make one very long function.
This function ...

**1**

vote

**2**answers

59 views

### Vlookup across multiple columns

Within one workbook, I have two spreadsheets.
Sheet A ("Master") looks like the following - it shows a main branch with it sub branches.
Sheet B ("Query") looks like the following:
The ...

**0**

votes

**2**answers

33 views

### Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...

**0**

votes

**2**answers

40 views

### Excel: deleting duplicate records based on an int value

In a sheet that has two columns, the first represents a string and the second represents some field value associated to that string as shown below. I roughly have 30,000 rows like that.
My Question ...

**1**

vote

**1**answer

52 views

### Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...

**0**

votes

**3**answers

46 views

### In Excel need to copy a range of cells based on single criteria

I am trying to copy/insert a range of cells based on a single criteria. I have tried using the IF function as follows
=IF(B6="RHH1",Sheet2!A4:J15,Sheet2!A18)
The FALSE statement works and the ...

**0**

votes

**2**answers

77 views

### Excel if/then formula

I am wondering if there is an if/then formula for the following situation. I am trying to populate a monthly calendar. I want the calendar to show the value in A1 if the value in B1:B100 is equal to a ...

**0**

votes

**1**answer

22 views

### Extracting multiple numerical values from mixed characters in excel worksheet

I have a column containing cells with two numerical values, separated by an asterix...
e.g. 12.5*3.4
How can i extract the smaller number of the two into one new column, and the larger of the two ...

**0**

votes

**0**answers

48 views

### =VLOOKUP() function performed on dollar value displays value without “$”

I'm not entirely sure how to present pleasant-looking spreadsheet representations on SE, so I would appreciate any advice on that issue given on the side.
I want the B2 cell to display the salary ...

**1**

vote

**1**answer

45 views

### Excel - How do I make the text in a cell flow over into the cell below

I want the text in a cell to flow vertically, that is, flow over into the cell below. When writing in a simple text that is longer than the column width the text flows over automatically into the ...

**0**

votes

**2**answers

28 views

### Two columns (pounds, kilos) convert and fill opposite column depending on which data is entered.

I'm trying to keep two columns of data. One in Pounds and one in Kilos. (1 kilo = 2.204 lbs)
The problem is that when I add a row, it might be in kilos, it might be in pounds. Is there a formula I ...

**1**

vote

**1**answer

46 views

### Countifs array with number of days

I'm looking to see how many days people are around between certain blocks.
e.g. with people and the days they are around for listed in the first table (A1:C5) and the blocks in the second table ...

**0**

votes

**2**answers

175 views

### Cannot delete created excel table

I have created an excel table. However, I now want to delete or change it because my range changed.
However I can't delete it in the excel Name Manager:
Any suggestion why I cannot delete it?
...

**0**

votes

**2**answers

27 views

### Understanding IF() statement

I am trying to update a spreadsheet that was created by an employee that is no longer with the company. I have been successful in decoding and update all but 1 formula.
ROUND(C6,0)*IF($D$3="Y", 42, ...

**0**

votes

**1**answer

91 views

### Compare two spreadsheets in a workbook, find the differences and record the differences on the first spreadsheet

I need a way to compare two spreadsheets in a workbook, find the differences, then write those differences on the spreadsheet in sequential order in the same column below the existing numbers.
Sheet1 ...

**0**

votes

**1**answer

61 views

### Defined Name to give text or date value instead of numeric value

I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank.
But when I use this defined name in another cell, the second ...

**0**

votes

**1**answer

172 views

### Nesting multiple IFERRORS with Index and Match

I feel like a dummy. I basically need a column that says - If column a2=0 then index and match column C, if that returns an error index and match column e, else index and match column a
Current ...

**1**

vote

**2**answers

39 views

### Simple, Excel, =LOOKUP(xxxxx), not returning the correct value

OK this is infuriating as I know this should work...
I have certain traits in column A. Each trait has a corresponding value in column B and a numeric indicator of that value in column C. Like ...

**0**

votes

**1**answer

49 views

### Excel, how to subtract time to span before midnight

I am trying to subtract hours to a time that is close to midnight, but excel is outputting all hash (#) symbols complaining of the operation.
Adding time is easy and possible, as described by this ...

**2**

votes

**1**answer

105 views

### Excel - sum values based on a column that match another column in another table

I've been working my head around this, but haven't figured it out yet, and I'm sure it's dead simple.
Suppose the following example:
There are two tables, one containing animals, and the other one ...