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

**0**

votes

**1**answer

24 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

20 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

21 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**

votes

**0**answers

3 views

### formula if a value in cell A is three or more points greater than cell B

example
Cell A contain 64 Cell B contains 68
I want my formula to return Review if cell B is at least 3 points or more greater than cell A otherwise OK
Thanks!
Maria

**1**

vote

**2**answers

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

**5**

votes

**2**answers

51 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

21 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

30 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

26 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

15 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

18 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

37 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

32 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

33 views

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

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

43 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

22 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

19 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

41 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

**0**answers

26 views

### Find and pick smallest value (date) on row based on the product name in column so that it do not pick the value twice for specific product [on hold]

I am trying to simulate full pallet order picking in warehouse so that it would be possible to pick the oldest pallet of specific product in warehouse.
Problem description:
In Excel sheet I have a ...

**-2**

votes

**0**answers

20 views

### Excel Formula Multiple If Statements with text value [on hold]

I am trying to develop a closed product log. The hope is to have a product, say "Apples" or "oranges," be selected and then once it is also selected as a closed sale, it will apply a point value for ...

**0**

votes

**3**answers

56 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

25 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

28 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

30 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

17 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

35 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

36 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

27 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

24 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

28 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

15 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

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

**0**

votes

**1**answer

33 views

### Apply Names in Excel is bugged?

I see people had this problem 10 year ago and it's still not fixed. Or maybe I just don't know how to use this feature.
In my sheet I have these named ranges:
A1 - "name1"
B1 - "name2"
C1 - "name3"
...

**-3**

votes

**1**answer

51 views

### Formula with 4 conditions (IF)

I have a hard time to figure out a formula with multiple conditions in Windows Office (Excel)
If A1<=5 or A1>=5 Then number should be "2"
If A1>=10 or A1>=-10 Then number should be ...

**-1**

votes

**1**answer

25 views

### Excel CONCATENATE function produces error when referencing a worksheet with space in name

In Microsoft Office Excel 2013 on a Windows 8.1 PC, I get an error message, #NAME?, when trying to do the following:
=CONCATENATE('Calculation Sheet'!D, "- Customer Sales")
Doing the same with an ...

**0**

votes

**1**answer

14 views

### Using ISNUMBER and SEARCH

I'm trying to use the formula =IF(ISNUMBER(SEARCH("180",A1,0),1,0) but for some reason it isn't working. I tried removing the quotes and the same problem occurred, I see entries (e.g. "it is 180 ...

**-1**

votes

**3**answers

48 views

### Formula is not working, cannot find error in the formula

I'm sure that this has an incredibly simple answer but I've looked over this formula for hours and can't figure out the error. Essentially what I want the formula to do is if F3 = "Freshman" then ...

**0**

votes

**0**answers

11 views

### How do I split a worksheet into multiple files dependent on the column values, calculate sub-totals and plot graphs?

I have a large data set and would like to split these into separate files/worksheets and perform the same analysis over each data set.
I have found a macro to split the data into separate ...

**2**

votes

**1**answer

29 views

### Replace contents of Excel column with realtional data from another column/sheet?

I have two excel sheets that have been exported from MySQL, with relational data in them, and I need to replace the reference ID's with the actual data from the relative column.
For example, in one ...

**0**

votes

**1**answer

27 views

### Excel Office Pro 2010 SUMIF

Hi Im trying to SUMIF(range;"<>#N/A";range) but the cells im selecting to sum are not in a row adjacent, its every 4th cell in the row.
But when i try it gives an argument error each time i try ...

**0**

votes

**3**answers

57 views

### calculating end times with working hours and skipping weekends

In my worksheet, I want to calculate estimated end times of processes.
However, i want to restrict this to a predetermined time constraint. So for example, when i add 4 hours to 14:00 I dont want the ...

**3**

votes

**1**answer

42 views

### Excel, how to use text functions on lookup array without putting in another column?

If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column?
Let's say I ...

**0**

votes

**1**answer

29 views

### VBA highlighting a cell if corresponding range in the same row is not blank

I am trying to enforce food name in column B of a file if column D to DX (Qty) has any value in it.
Rational is if any new request of food is received which doesnt appear in the file, the user can ...

**0**

votes

**0**answers

19 views

### Column order and names for table objects in Excel

I have a table in Excel that is connected to MS SQL Server table in the database. When I created a connection I specified a query that returns col1, col2, and col3 in this particular order. Then I can ...

**1**

vote

**2**answers

21 views

### Finding repeating digits at the end of a string of digits

I have a list of 10 digit toll free phone numbers. I would like to identify those that contain at least 3 repeating digits in the last 4 digits of the number. For example:
8xxxxx5444
8xxxxx2220

**0**

votes

**1**answer

42 views

### Excel - find multiple pieces of data in several different columns at once

I've currently got a spreadsheet on the go which lists contracts. I need to know if a contract is a renewal, new to product, or new to company. I'm currently struggling with the logic behind it and ...

**-2**

votes

**1**answer

33 views

### Attendence Points Rollover

I have an attendance worksheet where we calculate employee attendance based on points, if employee absent they get 1 point and if tardy or did not complete shift get 1/2 points also if employee has ...

**0**

votes

**1**answer

32 views

### Functions (specifically text functions) within a countif function

Is there any way to nest text operators within a countif?
I want to check if the first 4 characters of a file are in the form A**.
=Countif(Left(A1,4),"A??.") doesn't work, but I can put in a
...

**1**

vote

**0**answers

29 views

### Matching a column range based on a column label

I have written a spreadsheet for Excel 10 and am struggling with the last bit of formula.
I wrote this:
=SUMPRODUCT(--(ISNUMBER(FIND(B7,'PO SHEET'!$K$7:$K$74))),('PO SHEET'!$W$7:$W$74))
However, ...

**-1**

votes

**1**answer

27 views

### How do I isolate certain characters in cell content of an excel to new cell?

How do I isolate certain characters in cell content of an excel to new cell
Example: I have a big paragraph of information wrapped in a cell and I need to separate only few characters of that data ...