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

**1**

vote

**2**answers

64 views

### Is there an excel function which displays a string but outputs a value when referenced?

Let's say if the function called "LABEL".
Then in cell A1 I would enter =LABEL(4,"Four Apples") and it would render as:
Four Apples
But if I performed a calculation, say =A1+2 I would get 6, not ...

**-2**

votes

**1**answer

25 views

### Need to sum values associated with specific words, in Excel [duplicate]

I want to sum values associated with specific words. For example, calculate Sum for Food:
Column A Column B
Food $8.50
Food $5.10
Maintenance $12.00
Laundry ...

**0**

votes

**0**answers

24 views

### Microsoft Excel 2011 concatenate each row in a cell

I am trying to use an if function for each row for a result in a single/destination cell. The if function checks if a row meets a criteria, if it does, it adds the row details to the destination cell ...

**0**

votes

**1**answer

36 views

### VBA Code Isn't “holding” ThisWorksheet Parameter

I want to retrieve one column of values from another workbook and populate a tab in my current workbook. This will ultimately go into a much longer module I've written that works great. I just wanted ...

**0**

votes

**1**answer

37 views

### Excel 2013 - Referencing multiple checkboxes on a different sheet

Good morning, Superuser! I am facing a pretty tough problem at work this morning...my supervisor wants me to do something I have never done before, nor can I find a solution online.
The spreadsheet ...

**0**

votes

**1**answer

36 views

### What formula would you use to add up a column based on results from two drop down menus? [duplicate]

I would like to calculate a column based on selections from two other columns with drop down menus.
For example :
In one column, "C" you have 3 options (A team,B team,C team), In column "F" you ...

**0**

votes

**1**answer

42 views

### Want to get the unique combination of data for dynamic number of rows/columns

I have a few rows (the number of rows should be dynamic) of data that I would like to combine, and get each unique combination. I am able to do that for a specific number of rows of data, but when the ...

**0**

votes

**1**answer

58 views

### Excel not adding decimal numbers correctly

If I have a cell (A1) with a constant of -1.1 and then 11 subsequent cells referring to the first A1, and then to each previous one consecutively, after 11 cells, I'm expecting an answer of 0. ...

**1**

vote

**1**answer

37 views

### Excel SUMIFS based on two criteria

I would like to total a list of minutes based on two criteria to make a graph after the data is calculated.
The item "Department" (Column C) and "Day of Week" (Column F) are both drop down menus.
I ...

**1**

vote

**2**answers

52 views

### Excel formula daily average of weight

I am looking to set up an excel spreadsheet to calculate cattle weight gain per day. We weigh our cattle once a week so column A will be a date and Column B will be the weight on that day(day of the ...

**0**

votes

**1**answer

59 views

### Excel Run Length Encoding

If I have a column of data in Excel that looks like:
1
1
1
0
1
0
0
1
1
Is there an easy way to convert it into a run length list that looks like this instead:
3 1
1 0
1 1
2 0
2 1
(Three 1's, ...

**0**

votes

**1**answer

43 views

### Finding Common and uncommon values in excel 2010 [closed]

I have some values/numbers from A2 thru F8, I need the common values in 1 column (i.e the values which are common in A,B,C,D,E & F)-THIS CAN BE IN COLUMN H
I also need values uncommon only in A, ...

**2**

votes

**1**answer

48 views

### Excel formula sum multiple rows/column once on cell has reached it's max number and continue to sum

I am trying to come up with a formula that will split three rows of numbers evenly until one cell reaches a max number and then continue to sum the same three rows but split all the new values in two ...

**0**

votes

**1**answer

19 views

### I want to take two columns of cells (not the whole columns) and copy them and sort them into different cells

My Table:
I want to copy the names and scores from the desirability score area into the "Most to least desired rooms area but place them in descending order. How do I do this? Edit: I want the ...

**0**

votes

**2**answers

51 views

### How can I return the second last text value from a row?

Could anyone tell me the Excel formula to return the second last text value in a row?
I managed to find this formula for last text value: =INDEX(U2:Y2,MATCH(REPT("z",255),U2:Y2)), but not sure how I ...

**1**

vote

**1**answer

71 views

### Find the previous Row with a specific value at in column A

Given the above sample sheet, which has semantic 'header', 'subheader' and 'subtotal' rows, I am trying to determine a formula to locate the previous subheader row relative the current cell. For ...

**0**

votes

**1**answer

15 views

### Find missing values on spreadsheet 1 when compared to spreadsheet 2

I have the following scenario:
I have a list of ID's on a spreadsheet generated from a web app that has to be compared to our internal system. Any missing values from SP1 have to be alerted since ...

**0**

votes

**1**answer

30 views

### MS Excel UDF - Time series difference

I'd like some help with manipulating some data please. Given:
i) A range "oRng" of say "MaxR" rows and "MaxC" columns;
ii) and an integer i such that 1
I'd like to figure out the easiest way to ...

**2**

votes

**1**answer

44 views

### Excel, Setting a cap for values that meet a criteria on a column

I'm having trouble finding a way to limit the values of a column by setting a cap, but only for some values meeting a criteria.
An example of what I have:
>Criteria | Value
>--------- + ...

**1**

vote

**1**answer

27 views

### Excel in Cell Function VALUE for Formulas

I have an excel sheet which I need to run on Android. Only problem, I used VBA for the Evaluate Function and VBA does not work on Android Apps. I was searching for an alternative and came a round the ...

**1**

vote

**1**answer

36 views

### Need to add newline(s) and space(s) inside a cell in Excel

I have data in an Excel cell which is delimited by ,.
For example: abc,bde,fgh.
I used the formula =SUBSTITUTE(A2, ",", CHAR(10) & CHAR(13)) to change the commas to line breaks. Therefore, the ...

**0**

votes

**1**answer

79 views

### Excel countif formula that will subtract from another number if cell contains certain values

I am dealing with job applications for 8 different sites. People can apply for any combination of sites i.e 1 of them, 2 of them, all of them.
Some applicants have specifically said they don't want ...

**1**

vote

**1**answer

22 views

### Summing up values from a user-defined range

I have a spreadsheet from January 1 to present. and I needed to sum up the value parallel corresponding from the range which the user defines.
For example:
in Column A are the dates January 1 - ...

**0**

votes

**2**answers

40 views

### How to combine values from multiple rows into a single row with a comma separator

I have an Excel file that lists product SKUs in one culumn and product image URLs in a another column. My problem is that the file has multiple rows for the same product...
...when the CMS I use on ...

**1**

vote

**2**answers

35 views

### Counter in Excel

My file has 50 sheet inside, which each sheet is a standard form. Lets name as Form1, Form2, Form3.
I want to create a print sheet, where I select which form I want to see, so that I don't need to ...

**7**

votes

**2**answers

120 views

### Conditional concatenate cell content across rows

I have a worksheet with thousands of rows which contain a unique ID A, and one 3 different error codes M. Each individual ID may have 1, 2 or 3 errors. They will always be in the same order.
I have ...

**0**

votes

**1**answer

25 views

### Excel Formula Is unwantedly automatically changing

I have created a product referral log and needed to have a system that automatically calculates points for those products once they are closed.
My solution for this was to make a separate sheet ...

**1**

vote

**2**answers

42 views

### How to find value of last cell in an Excel row

I have a spreadsheet with a delimited list of directories and files in rows with varying numbers of columns. I just want the filename value (e.g. 123-E-001.xls, situated in the last cell of each row) ...

**0**

votes

**2**answers

125 views

### Day of the week and Time Graphing in Microsoft Excel

I have an Microsoft Excel document with two columns, date (mm/dd/yyyy) and time HH:MM(a/p). Each row represents an order (The day it was placed and the time it was placed).
How can I graph this so ...

**2**

votes

**1**answer

18 views

### generate line graph from spreadsheet with month and category column?

Trying to generate a line graph that shows the amount a certain category happened per month. The spreadsheet has the category of an instance as well as the month it occurred. Easy way to do this?
...

**0**

votes

**1**answer

25 views

### in ms excel, is there a way to look up an array and edit data on the looked up row?

Just for a quick example, I have this table:
A B
1 student grade
2 john 90
3 paul 93
4 peter 87
5 bill 84
6
7
Range or array is A2:B5.
I ...

**0**

votes

**1**answer

49 views

### Excel - Look up list of substrings within large strings

I've been struggling with the following; might be a bit of a challenge.
I have an Excel file that was exported from an XML application.
Sheet 1 contains rows of strings like those below. Every ...

**1**

vote

**1**answer

46 views

### What exactly is this SUMPRODUCT and MID formula doing?

In an Excel spreadsheet I have text entries H23, w67, P45, etc. and I want to sum the numeric parts of these, i.e., 23,67,45.
I have the formula
...

**0**

votes

**1**answer

44 views

### Read one worksheet and load data into another one but not just as a reference [closed]

I have a list of equipment assets and attributes which is a raw data dump from a database. Among attributes like equipment status (like running, in standby etc.) or Oil level it also includes things ...

**0**

votes

**1**answer

47 views

### Microsoft Excel 2010 if(or(and I am confused

I am trying to query two cells by using If function but unfortunately have no luck. I will give you an example below. Please let me know how I can solve this issue.
If C2="Car" and D2="Toyota_Mazda" ...

**1**

vote

**2**answers

34 views

### How to populate a cell with values from another worksheet but increment cell address by 3?

I know how to populate a cell with values from another worksheet. But how do I skip to the 3rd cell?
Here's what I am trying to do:
A1 ='2nd Worksheet'!C4
A2 ='2nd Worksheet'!C7
A3 ='2nd ...

**0**

votes

**2**answers

29 views

### Keep same row when new rows are inserted

I have a CountA formula:
=COUNTA('0 Data Summary'!B10:B108)
and a macro that creates a new client data row in row 10 every time and all other client data shifts down by one row. It works fine but, ...

**1**

vote

**3**answers

60 views

### Subtract values only if all are numbers

I want to subtract four cells in excel from one specific cell but only if any of the four cells have a value. More specifically in my case the formula in cell L2 is currently
...

**0**

votes

**3**answers

71 views

### How do I break up a number in a single cell that doesnt have commas and put it into multiple rows?

So here is what I am looking to do. I have a spreadsheet with a cell that has a string of numbers in it (some are longer than others) I need to extract every eight numbers and put them into single ...

**-1**

votes

**1**answer

33 views

### Array formulas and Logic, checking against multiple criteria

I'm currently just troubleshooting a report spreadsheet I've written. The logic I had written isn't working, so I thought I'd see if I could ask for some help here.
Essentially, I have a list of ...

**0**

votes

**0**answers

57 views

### Average If function not returning correct value

I am trying to do an average if function, it is the average of some cells which provide a number based on a formula in that cell subtracting dates in other cells giving a number representing a span of ...

**0**

votes

**3**answers

46 views

### Excel multi table lookup, can you find a more elegant solution?

This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...

**1**

vote

**2**answers

22 views

### Excel - copying links without forumla

I have a column of hyperlinks in an excel file.
I've used formula: "=HYPERLINK(A2,A2)" and it gives me a hyperlink to a file on drive.
In column A there are text versions of alll of the links - ...

**0**

votes

**1**answer

47 views

### Count instances of letter or number in a single cell [duplicate]

I would like to count instances of numbers from a number in a cell.
For expample we have the number 78812557839. I need a formula or function to count how many instances of 7,8,1,2,5,3,9 this long ...

**1**

vote

**2**answers

48 views

### Excel Spreadsheet sheet formulas

I would like to be able to have a cell in a 2nd tab equal what was in a previous tab, then create a new tab, copy and paste and have the spreadsheet formula update to the previous tab instead of ...

**1**

vote

**2**answers

42 views

### Concatenate cells but exclude empties in Excel [duplicate]

I am wondering how I can concatenate a row of cells with comma separated values but exclude empty cells.
For Example the list would be:
A1 - Dog
B1 - "empty cell"
C1 - Cat
I am looking for a ...

**2**

votes

**1**answer

53 views

### Convert multiple unicode values to corresponding text in Excel spreadsheet

If my Unicode character contains more than one hex value in an Excel cell, how do I write a function in Excel to convert it into the corresponding character?
For example:
Unicode Hex values in Excel ...

**1**

vote

**1**answer

34 views

### How do you create a conditional nesting formula on excel 2010 with more than 3 conditions?

I have "A, B, C and D." I need " if a>0, use a, otherwise, use b. If b has the error "#N/A", use c, otherwise use b. If c=0, use d/61, otherwise use c.
So far, I have this:
...

**1**

vote

**1**answer

25 views

### Cell references in formulas keep moving with old data in Excel

When I update Excel to the latest figures my formulas keep moving with the old data. I have already tried using absolute and or relative references like $A$1, $A1, A$1, and A1. I've also tried using ...

**0**

votes

**2**answers

44 views

### Is there a way in Excel to have a formula stretch its row extent to include adjacent inserted rows?

In Microsoft Excel 2011 for Mac OS X, I have several columns of numerical figures and a final row at the bottom that shows a maximum value for each column. My data set is ordered, such that most ...