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

learn more… | top users | synonyms (3)

0
votes
0answers
34 views

Creating automated Microsoft Excel filtered list

I have the following situation in one of my Excel sheets: I have a table with some values, particularly "date", "stock" and "cost" among other data. The table may contain values from various ...
0
votes
0answers
47 views

Google sheets formula reference cell data in another sheet

I need help with formatting a sheet. My sheet that I need to format is an attendance list. I want the names of the students in column A that have a certain teacher. I want to pull those names from ...
0
votes
1answer
51 views

How can I sort data that is organized in 4-row chunks?

I have an Excel document with six columns and 57,000 total rows. Each record comprises four rows, that is, each set of four rows goes together. How can I sort this data by one field while keeping the ...
0
votes
1answer
32 views

Excel - Four returnable values, given two crieteria

I need excel to return one of four possible values given two criteria. The two criteria are: Is the value in cell A1 >= to 10 OR A1 < 10 (two possibilities) and Is the value in cell B1 > ...
0
votes
1answer
26 views

Windows 7 Enterprise, Service Pack 1. Software MS Office Excel 2010

In Excel I understand there is no mechanism to customise & re-label the Rows & Columns (i.e. Renaming Col. A to some text like "Item Number" and so on. My question is regarding if it's ...
0
votes
2answers
45 views

How to dynamically populate a filter list with “first match” on a row, using excel 2007

The image is an example of what I am working with. I am trying to write a formula in my leftmost column, just under the listbox cell that you can see, which will find a string/value match in that ...
0
votes
2answers
89 views

Excel: AVERAGEIF on multiple work sheets (via 3D Reference)

I have a question when using excel averageif functions: I have a workbook containing monthly information (stored as numerical values) in 12 different worksheets (named Jan, Feb,..., Dec). In each ...
0
votes
1answer
54 views

Excel - Sum certain range from pivot table

I have an excel pivot table that looks like the following: Is there any way I can create a formula that will calculate the sales$ for a particular product at a particular store for a particular ...
0
votes
1answer
45 views

In Excel selecting an item from row when cell matches the first item in that row

I have a LIST of 5 optional sizes. There are several numbered mating parts that coincide with each of the sizes forming a pair. Any 1 of the mating parts can go with a chosen size, but only 1. Some ...
0
votes
1answer
126 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
1answer
52 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 ...
0
votes
2answers
50 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, ...
0
votes
1answer
79 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 ...
0
votes
2answers
84 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
2answers
41 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) ...
0
votes
2answers
129 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 ...
0
votes
1answer
26 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 ...
0
votes
2answers
41 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 ...
0
votes
0answers
54 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 ...
0
votes
1answer
24 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
1answer
58 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 ...
0
votes
3answers
47 views

In Excel replacing a column with another column

I have a list of Variables in Column A > list of items another list of variables in Column B > with corresponding Item Codes for >> column A And in Column C > I have list of item codes randomly ...
0
votes
1answer
24 views

Excel drop down list in a drop down list in a drop down list

In excel I want a single cell drop down list that automatically progresses from manufacture, to model, then to part. An example would be first I click on a cell it would show four manufactures, when I ...
0
votes
1answer
28 views

Excel calculations

I have a spreadsheet calculator that adds several numbers to one another to make a total Hence A1+A2+A3 = A4 assume 2+3+4 answer = 9 = A4 (and linked to D6 in Sheet 2) I want to store this answer ...
0
votes
1answer
34 views

data proccessing in Excel

I have set up a number of columns with some data-numbers. I would like also to present some data resulting from processing these columns: For each of these columns i would like to know the product of ...
0
votes
1answer
17 views

How to match Reg No. in one workbook to another

I want to find out a formula to match Reg No. for two workbooks. First work book is a master book I update everyday almost, next workbook I have employees name and ID numbers only, nos are in ...
0
votes
0answers
55 views

Excel: Finding comma delimited values in reference range

I have a two-sheet excel file in which I want to see if specific values are present in some column, based on comma separated values in some other cell. The idealized case would be: Sheet1: Cell A1 ...
0
votes
1answer
43 views

Summing of adjacent cells in a single column that are <>0

I have a list of numbers (8780 values in one column -- a sample is posted below) some of them are <> 0 and some of them are 0. List of numbers: 0 0 0 0 0,127227198 0 0 ...
0
votes
0answers
45 views

“Filter by Selected Cell's Color” is so slow

I have a row includes like 60-70 thousand lines. 30.000 of them colored. And I'm trying to filter them by "Filter by Selected Cell's Color" but it's so slow. It take forever to filter just 70.000 ...
0
votes
1answer
46 views

How to CONCATENATE with variable rows

Sorry in advance if I don't explain this very well, definite newbie here when it comes to spreadsheets. I have a Text only spreadsheet with 4 columns, first 3 are Student's Last name, First name, and ...
0
votes
0answers
34 views

Excel changes formula to numbers randomly

I have had recently a number of instances where Excel has changed formula to the numerical results of the formula : Formula Formula Formula Formula Number Formula Formula Formula I have ...
0
votes
1answer
70 views

Return the maximum value to the left of the cells containing a given string

For an Excel spreadsheet, I am trying to find the maximum number that corresponds to a cell with a certain string. For instance, if the data is: | A | B | 1 | 3 | Red | 2 | 5 | Blue | 3 | 1 ...
0
votes
1answer
104 views

Count instances of a letter in a row if a certain cell in that row contains a specified date

I have a spreadsheet containing a column of dates (week commencing) with columns of data to the right of it, and a conditional formatting rule that highlights this week's row based on the date. I ...
0
votes
1answer
24 views

Merge 2 sheets, always keeping the value from sheet 1 if there are duplicates?

I have 2 Excel sheets that I'd like to merge. They are an inventory file and are roughly 5,500 rows each, with each row being a product and each column being an attribute. The first column is the ...
0
votes
2answers
50 views

When to use “0” and when to use “1”

What is difference from 0 to 1 in the following formulae? Example: =IF(ISERROR(MATCH(B2,A:A,0)),"No Match","Match") =IF(ISERROR(MATCH(B2,A:A,1)),"No Match","Match")
0
votes
1answer
23 views

Removing whitespaces from data in a column

I have two columns of data in excel spreadsheet say column A and B. There are more data in column A than in column B. I am trying to find which of the data in column A is not present in column B. I ...
0
votes
2answers
58 views

How can I return a list of specific words found in a cell's contents?

I have two columns, one with a string of text (A1), the other blank (A2). A1 looks something like this: "Briefs on Southern Africa, Rhodesia, East of Suez (Including Soviet Naval Expansion), ...
0
votes
1answer
139 views

Advanced filtering leaving on unique values and removing duplicates

On the spreadsheet there are two subsets of data that are separated by color based on where I pulled the information from. Within these subsets are duplicate entries. I do not want to simply remove ...
0
votes
0answers
9 views

Pointing to another excel worksheet in a 3d table dynamicaly

I have a 3d table for some stocks of products, all sheets identical and all. If product name is "OIM", the worksheet the data is on is called "ROIM" and so on. Now, I would like to find a dynamic ...
0
votes
1answer
168 views

Excel - Script that search a sheet for a cell containing specific text, and replace the text with a specific value

I want to split a cell with data into other cells based on the data in the original cell. The data from the original cell looks like this (all content in a single cell): ...
0
votes
0answers
30 views

incorrect IF formula evaluation

I have the following formula: =IF(SELL_INVESTMENT="YES",1,2) It returns not 1 or 2 but 0. I verified that the cell contains YES and it should return 1. The file contains over 1000 cells. "Trace ...
0
votes
0answers
91 views

Getting data from closed files with concatenate formula

Each day a program is creating an excel file for me with some data for the current day. Like what is the price for products, how many people are available today and things like that. Based on all ...
0
votes
1answer
324 views

Updating another Excel spreadsheet from current spreadsheet

I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same ...
0
votes
0answers
12 views

Generating ID#'s in GIS attribute table

In the attribute table within GIS, I have a certain column with ascending values, and I want to assign ID numbers (for easier readability and display) to a corresponding column. So for instance: Feet ...
0
votes
0answers
65 views

Using Excel to calculate time differences with blank cells and calculate monthly totals

I have a sheet that looks like this: Level 1 Level 2 OFF Date Time Date Time Date Time Total T Total L2 12/3/2013 12:50 ...
0
votes
1answer
53 views

compare and update spreadsheets

Please I need some help with excel spreadsheet here. I have two worksheets, one holding the old records and the other holding the current record. What I wish to do is to develop a vba code associated ...
0
votes
2answers
28 views

Can I add data from a cell on sheet 2 to a cell on sheet 3?

I want to grab the total of the # hours from 6 cells in a row on sheet 2, and add them and the total of a cell on sheet 3, and display the result in another cell on sheet 3. What I have tried is: ...
0
votes
1answer
96 views

Getting average of data with multiple entries for a single date using Pivot table in Excel

I have tried this, but I am unsuccessful. I have the data dump in an excel sheet (Excel 2010). The first column has month. The second has the dates. The third column has numerical data. I have applied ...
0
votes
0answers
78 views

Finding IPs covered by Subnets in an Excel document

So I have a giant excel document that contains a list of IPs, but there are also entrys that have subnets. So for example, I might see "IP" "/16" and the first two octets would be the first two ...
0
votes
0answers
72 views

Turning students’ marks into grades with excel

I have a sheet contain grade boundaries, For example, the first row says ‘A* | 100 | 90’, the next row is ‘A | 90 | 80 ’, the next ‘B | 80 | 70’ and so on. Another sheet contains a list of student in ...