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

**-2**

votes

**1**answer

19 views

### IF formula to compare several cells

Having problems with "IF" in Excel.
I want to compare Cell A2 with cells B2, B4, (...), B100 from another sheet.
How do I write the formula?

**0**

votes

**0**answers

13 views

### Finding a way to auto update a formula based on real dates in excel

I'd like to track my employees vacation time with Excel. I'd like to be able to develop a formula that "gives" each employee 8 hours of vacation time once a month, based on their start date, and then ...

**0**

votes

**0**answers

9 views

### Count values in another table matching a cell value in row of current table

In excel 2010 I have a table of projects, and a table of initiatives (one project to many initiatives). I would like to create a "total initiatives" column in the project table that counts initiatives ...

**0**

votes

**1**answer

43 views

### Index match on 2 conditionals?

Data:
I could use some help coming up with an index match formula based on 2 conditional items. For the attached data set, I need to set up a formula (and make it repeatable for other stores and ...

**6**

votes

**2**answers

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

**0**

votes

**1**answer

21 views

### Read last known value in a Excel data table

I'm working on something but can't figure out a formula and wondered if anyone out there has any suggestions?
I'm looking for a formula which will tell me the last status of a job.
In the example ...

**0**

votes

**1**answer

25 views

### Need to transfer a column's data. I have 2 sheets with same data and need to move corresponding data from one to another

I have 2 excel sheets and both have one column that has matching data. However Sheet2 has a column of data that Sheet1 does not have and I need to input the corresponding data from Sheet2 into Sheet1 ...

**0**

votes

**2**answers

25 views

### The IF function in Excel is not working?

For example:
D1=3, D2=5, D3=3.5
I type the formula D1<=D3<=D2 which is obviously true but excel keeps telling me its false and then proceeds to mess up all my other formulas.
But if I ...

**1**

vote

**1**answer

57 views

### Excel.. using INDEX and MATCH to find a string in duplicate values?

I need a formula in Sheet1!C2, maybe a combination of INDEX and MATCH to find out, using ID field as a key, if a certain ID bought screws (sheet 2).
My problems are: ID is duplicated in sheet 2, ...

**0**

votes

**0**answers

25 views

### MS Excel - Match match index?

Sorry in advance if my formatting or question is hard to follow.
I'm kind of new at this. And couldn't figure out how to do table format...
I have an Excel table laid out kind of like this:
(ID#) ...

**2**

votes

**2**answers

54 views

### How to flag rows with the pattern non-blank, blank, non-blank using Excel

I would like your help with something I have been trying to figure out for the past two days.
I have data with 1000's of rows and several columns. I want to insert a column with a (array) formula ...

**0**

votes

**0**answers

25 views

### Excel drop-down list formulas

I'm trying to create a smart Stats sheet in Excel 2013 (PC) using drop-down lists.
In Sheet 1, Column B contains similar drop-down lists with the following two choices: Project and Regular Work.
...

**0**

votes

**2**answers

56 views

### Combining numeric values that have been converted from text

I built a survey tool that our customer service agents use to track survey results. For ease, the agent simply chooses a survey value (text) from a drop down menu. There is data being collected from 5 ...

**0**

votes

**0**answers

6 views

### excel sheet updating / copied sheet isn't

my excel spreadsheet is set on auto calc. The original sheet is updating when I make corrections. The sheet I have copied into my financial workbook (with the same formulas in it) is not updating ...

**2**

votes

**2**answers

39 views

### Deleting specific rows/columns from excel

I want to delete specific rows from Microsoft excel. My data set has around 900,000 rows, I want to get ride of rows/columns that are for example, from b325890-b500000 without dragging my mouse down ...

**0**

votes

**1**answer

37 views

### Formula Logic Woes

Trying to calculate the ROI of the lighting equipment I'm renting, but I can't seem to figure the formula out.
As it stands, a single rental is calculated by:
...

**1**

vote

**1**answer

32 views

### How to embed numeric string in text in Excel?

I need to copy and paste thousands of numeric values, from A2-A10000 to B2-B10000, with some text around it. Here is one example:
A2:
5047612445
B2 then needs to be:
...

**0**

votes

**1**answer

38 views

### Duplicate rows based on its data

I have an excel file which I'll use to import hundreds of products in an e-shop. The excel have columns like this
Title | SKU | Size | Price | etc
I asked my clients to make the excel in very ...

**1**

vote

**2**answers

38 views

### How do I delete/ignore error-producing results in an Excel named range?

I have two ranges, RangeA and RangeB. I would like to essentially do the following:
=SUMPRODUCT(RangeA, 1/RangeB) / TotalItems
To get an average percentage. However, both of the ranges may have ...

**-2**

votes

**1**answer

27 views

### Formula within Excel 2010 [closed]

I want to copy contents of cell A2 ("SE0001") to paste into cell A3 to result ("SE0002"). Please help with formula.

**0**

votes

**1**answer

30 views

### Show current workbook name in a cell

I am trying to view the name of the file that I am working on in Excel. I would like to use a formula to return the file name to a cell on the spreadsheet. For example, if the file was called ...

**1**

vote

**1**answer

37 views

### OpenOffice Calc “if” formula for currencies

I have a spreadsheet that has many different currencies in it ($, euro, shekel). I want to display the actual price in the original currency and then show the converted price (in this case to ...

**0**

votes

**1**answer

86 views

### How to find matching cell values between 2 columns but return the value of another cell. Excel 2010

Image of the excel file is above/attached.
I have data in Column D that are matching in Column A
What I need is for Column C to output the value in Column B same row
So in an essence:
D2 has a ...

**2**

votes

**2**answers

42 views

### How to convert a string referencing another worksheet to an equation?

I have this cell:
="='C:\Daily Reports\" & A1 & "\" & B1 &"\[Report " & C1 & ".xls]Report'!K4
which creates a string like so:
='C:\Daily Reports\2015\11\[Report ...

**1**

vote

**0**answers

11 views

### Removing duplicate values in a cell

I found a great post answering ALMOST what I need.
I want to list values as such; (so that the true line is the only one I want)
Product A Cyan Cyan FALSE
Product A ...

**0**

votes

**0**answers

25 views

### Excel 2010 - multiple sheet error

I have a problem with multiple sheets: every time I try make a change in more than 1 sheet at a time it doesn't work properly.
The problem: If I select 2 or more sheets and write anything in cell A1 ...

**0**

votes

**1**answer

21 views

### Date range for jobs & conversions SUMPRODUCT

I'm trying to run a report within Excel that shows the total number of jobs completed by employees within a date range and also a count of the number of conversions per employee within the same date ...

**0**

votes

**1**answer

22 views

### how to concatenate the output of vlookups in one step

I'm trying to run two vlookup operations and concatenate the results in one formula as such:
=CONCATENATE(
VLOOKUP($A$6,'TRP'!$A$7:$D$655,2,FALSE),
"/",
VLOOKUP($A$6,'HCP'!A5:B655,2,FALSE)
)
The ...

**0**

votes

**1**answer

18 views

### Can a function be used to alert if values are present in a table more than twice or not at all?

I am trying to help someone in my office with a surgery schedule spreadsheet. She would like a formula that will check a group of cells for a set of initials, and be alerted if the initials are ...

**0**

votes

**2**answers

26 views

### Excel: count unique instances across two columns

I have a spreadsheet that has a column for cell sites and another column for frequency like this:
SITE FREQUENCY
MA1084 687
MA1084 687
MA1084 687
MA1084 4382
MA1084 4382
MA1084 ...

**-2**

votes

**0**answers

15 views

### VBA - have a base in common and separates each sheet

I am a beginner with VBA, still trying to figure out this great tool.
I have a file wwith 30 sheets I need to save separately, but two needs to be always there.
For example
Sheet A - Needs to be ...

**0**

votes

**1**answer

19 views

### Excel Extreme Average Values?

I have encountered this error multiple times. What is even more out of place that it does not do it for the E column only for the other columns, and as I am showing you in the picture I know and ...

**0**

votes

**0**answers

35 views

### Excel MOD function doesn't work properly if the value is 12AM (00.00)

so I sorted out with the MOD function to calculate my worked hours where I used to start at XX PM/AM and finish at XX AM/PM where without the MOD function I could not calculate properly if I was ...

**0**

votes

**0**answers

26 views

### Looking for nearest value in multi-row / multi-column data

For my bachelors-paper I need to look up a value for the area (AE) of a rail given the current it must be withstand (Iz). So, I need to search for the value or the value closest to it. Also I must ...

**0**

votes

**2**answers

37 views

### Excel formulas&subtotals

I have this excel sheet and I have to calculate into the G column the sum of sales until a date ( in G1 the sum until 01.10.2015, in G2 until 02.10.2015, G3 until 03.10.2015 and so on). Can I make it ...

**0**

votes

**0**answers

44 views

### Condensing a Formula checking numerous Countifs across rows and columns

I am trying to find a way to turn the below equation into something less cumbersome. Basically I have an array of Countifs which are checking table data to see if the selected person is taking 10 mg ...

**0**

votes

**1**answer

31 views

### Insert formula if blank if next cell in row within range, but freeze data from previous cell/ remove formula

I have some users that are manually entering data from one excel generated from a reporting system and entering in that data into hundreds of cells per day. The format of the report generated excel is ...

**0**

votes

**1**answer

53 views

### How can I calculate distance between coordinates on multiple matching rows in Excel?

I have a sheet with 20,000 rows. Each row has an object ID, which can occur multiple times throughout the sheet. Each row also contains coordinates, as they are real world points. Each object can ...

**0**

votes

**1**answer

16 views

### Searching a column for a set of values and listing missing values

I have a column of 45 spaces that will have letters and numbers. I want to write a formula that will search the column for the values 1-10 and list the values found more than once or not found. I ...

**1**

vote

**2**answers

57 views

### =IF(VLOOKUP(…)…) formula returning error

I am attempting to write a formula to return a Y or N after it looks something up.
The formula I have is: =IF(VLOOKUP(B6,HIRES!A:A,1,FALSE)>"","Y","N")
I need it to return Y if it finds the ...

**0**

votes

**1**answer

46 views

### Return value with if and vlookup

I'm trying to create a formula that can help me maintain a list.
I have drawing numbers and revisions on one sheet. I need to like bring that to the main sheet for each drawing number that is on the ...

**1**

vote

**1**answer

35 views

### Separating character string in Excel 2010

Is there a way to split a string of characters from one cell into separate characters in seperate cells?
For example, the text is 154322JW01. I want to split this into 10 cells with one character ...

**0**

votes

**0**answers

33 views

### Need a formula to match two criteria and return multiple results

I am trying to return a list of items that meet two criteria.
Using an array formula I was able to get the list for one of the criteria, can a second field criteria be used in an array? (Since ...

**1**

vote

**2**answers

50 views

### Excel Help - Is it possible to return the column number of the 2nd match within a horizontal array?

I'm trying to return the column number that corresponds to the 2nd occurrence of zero in the following table:
B C D E F G
2 0 0 3 4 9
For ...

**0**

votes

**2**answers

52 views

### How can I index an exact value repeated in multiple columns in Excel

This application is to list what racks a item would be located in a warehouse.
For example if an item was stored on a few different racks. I don't need a total of how many times the item is repeated, ...

**0**

votes

**2**answers

34 views

### How to sum sales for a set month Excel

I have an excel sheet where im tracking sales, I would like to have an overview of sales each month in another sheet so I can graph it.
my raw dater is below
17/06/2015 4
22/06/2015 8
35/06/2015 ...

**0**

votes

**2**answers

97 views

### Excel array functions — how to count non-blank cells over multiple worksheets?

I have an Excel workbook with numerous worksheets, some of them containing a numeric value in cell A1:
'DATA_1' 'DATA_2' 'DATA_3'
A A A ...

**0**

votes

**1**answer

43 views

### In excel 2010, substitute any number corresponding to pattern with look-up value

I'm trying to figure out a way to replace/substitute/regex a specific pattern in an Excel table with the corresponding value from another table.
The pattern, which appears x times inside a text block, ...

**0**

votes

**0**answers

43 views

### How to select random people for a match depending on many criteria?

I am stuck in a situation where I need to organize fight match in my school.
I was doing it manually but now thinking to automate it via excel. Automation will reduce my work & also the random ...

**0**

votes

**1**answer

55 views

### Reverse vlookup

I have a list of descriptions and I want to add a code column as shown below. The descriptions in the list are neither unique nor sorted.
I have an index table with substrings and the codes in ...