Tagged Questions

5 views

Auto-fill rows from columns in another sheet?

I'm using Google Doc's Spreadsheet at the moment and I'm attempting to create the same view in another sheet. First Sheet: (yes I need these merged cells) Second Sheet: Unfortunately Google ...
14 views

How do you auto update row count in a formula that yields a percentage?

How does one get a formula to auto update when a row is added when this formula is meant to yield as a percentage, which is directly linked to a pie chart? For example: my formula reads ...
29 views

Excel- How do I find common text values from multiple (>2) columns?

I have 9 columns of text data and need to know the common terms that are found in all nine columns (or possibly different combinations of columns). I can do 2 columns ...
11 views

How to use SUMIFS function for summing values if criteria range exists in a range?

My data: A B C a 3 d b 1 a c 8 e d 5 I want to use SUMIFS function, sum range is B1:B4, if the corresponding value in column A exists in column C, sum the values in column ...
19 views

Ignoring value IF “[Value_if_false]”

I am trying to figure out the average difference in monthly sales versus previous years, and I have an IF function within an Average function. I want to skip zero values in the average function if the ...
23 views

I would like to copy data from 1 row to another in Excel

I am trying to solve the following issue in excel: I am working in two sheets, Sheet 1 and Sheet 2. There is a column of data in sheet 1 (say from A5 to A20). I need every row from that column to be ...
13 views

I have two spreadsheets, one with a Calendar, and the other one with Data Chart. I'm trying to make it so that the Data Chart will only start using Data from Today's date in the Calendar. (Note: ...
20 views

Excel 2010, IFERROR, INDEX, MATCH

I've got a sheet consisting of various lines like the following. POH-00006366 CYM001 Cymot NAD 6000 POH-00006366 CYM001 Cymot NAD 7000 POH-00006366 CYM001 Cymot NAD 8000 ...
29 views

comparing two columns for matches then return values meeting certain conditions

I have the following: column D ( 300 values representing the average of three cells, A1:A300 & B1:B300 & C1:C300) column H ( 50 values ) column E & column F & Column G; they are to ...
26 views

Problems figuring out weekly scheduling and hours past midnight

This is a screenshot of what I have What I'm trying to do is have the hours for each individual person posted as shown or a way that the hours can be posted like this and then have the total amount ...
29 views

Make the background/text colour follow another cells background or text colour

Ok so I have a large spreadsheet (so I don't want to have to set each cells colour individually or manually) and I have many cells copying other cells. So for instance I have cells N9, N 3, N80, N117 ...
21 views

2 EXCEL (array?) questions

I am trying to perform some lookup calculations on a pivot table and having some abysmal luck finding the correct function/formulas to use. I've searched the Interwebs and can't find something that ...
17 views

In Excel 2013 Is there a way to code an auto-complete function ibased on values in another tab

I want to create an auto complete cell in Excel for the resource name. The list is too long for a custom list and I really do not want a drop down list as in data validation. Does someone have an ...
16 views

Looking for a formula(s) that will return the next date (higher than the starting date) from a row of dates, then the next date from that one

Worksheet 1 lists all of the "legs" flown by our aircraft. The leg or legs for each day would then go to Worksheet 2 for Day 1, Worksheet 3 for Day 2, and so on. Legs are listed in columns starting ...
15 views

How to update range of columns in excel

I have an excel sheet where from one sheets's Id used as reference in next sheet. The Id's are sequential. Like this : Sheet 1 Sheet 2 ID Name ID Sheet_1_ID Text 1 ...
25 views

Display formula result only if inputs are defined

I have a simple spreadsheet, with one row of equations to get sums or differences. What I'm trying to do is enter an equation so that if only one part of the end equation is present, the field is left ...
19 views

MS Excel 2007 Copy Range Across Worksheets and Increment or Offset by 50 rows

I'm looking to copy and paste a list of names from Sheet 1 to Sheet 2 but space them out. For example, I'd like Sheet1!A6 -> Sheet2!A51, Sheet1!A7 -> Sheet2!A101.... Sheet1!A41 -> ...
12 views

How can I calculate the grouped averages and maximums per day for a range of dates and times?

I have a CSV dump describing the utilisation percentage of some servers in my organisation, covering data samples from several times per day. Each server belongs to a group. For each group, I have to ...
30 views

Excel - How can I collapse data, eliminating blank rows?

I have a 3 column, 20 row table. (A1:C20) The 3 columns are each 1 digit of a 3 digit number. Some of the rows have 3 digits, some are blank. I need a way to return all the non-blank rows of 3 ...
21 views

Formula to return values into a number of cells based on another cell's value.

If I have a cell (A1) value is "2" (set value) & another cell (A2) value is "4" (number of cells in 1 column i want the set value to appear in) How do I return the values in B1:B4 to all be "2"?
23 views

Moving Right When Dragging Formula Down

I have a SUMIF formula as follows: =SUMIF(\$B\$2:\$B\$5758,">1",N\$2:N\$5758) Is it possible to make it so that when this formula is copied down the formula becomes =SUMIF(\$C\$2:\$C\$5758,">1",N2:N5758) ...
32 views

Is there a formula I can use to count the number of occurrances of a name in 1,2,3 order?

I have an excel spreadsheet containing a list of names and "scores" that they have received for a specific date. Each name should have 3 scores each month and I'm looking for a formula that can help ...
28 views

Excel TRUE/FALSE IF formula

I have a "Pass" column (A) and a "Fail" column (B) in one worksheet. I have a column in another worksheet where I need the following to happen: If A is true and B is false, return "Pass" If B is ...
22 views

excel - ask for input to be used as new cell values

I use excel 2007 and I want to create the following function: At first I need to add a vba function button that prompts the user to add four different values, e.g. a name, a number, a date and an ...
17 views

Excel: INDEX and array on another sheet

My raw data is a list of students and their grades on Sheet 1. 6th Bobby 6th Carl 7th Tommy 8th Bobby I want Sheet 2 to give me a list of students based on the grade I input into cell A1. example: ...
19 views

Calculate Break Point Weight

I have a table like so: Miles Weight Rate 50 1710 54 50 3417 44 50 7253 38 50 12025 36 50 16052 35 100 1716 55 100 3429 45 100 7269 39 100 12027 37 100 16055 36 Where ...
55 views

Conditional Matching Based on Datetime

I have a set of names and datetimes on two sheets. One sheet we'll call LargerSheet and the other we'll call Sheet1. On LargerSheet each name has multiple datetimes associated with it. On Sheet1 ...
43 views

Sum of Multiple VLOOKUPs

I am trying to find a formula that would help me sum the results of multiple VLOOKUPs. For example, you have two sheets that look like the following: Sheet1 Fruit______ Orange_Apple_Banana ...
30 views

Excel COUNTIF range search returning #N/A

I'm using Excel to search multiple days (my ranges) in a timesheet for hours worked (my HLOOKUP reads the value below the dept number) by multiple members of staff for different departments. I've ...
27 views

Excel - formula to calculate average for variable number of rows in table?

I have a table where the value in column B is the average of some preceding values in column A. I want to use a named range "DaysToCount" to vary the number of rows used for the average. I've tried ...
27 views

Excel - How to merge rows from 2 tables based on a common column?

I am trying to merge 2 worksheets where only one col matches in content. Column"A" in both worksheets have matching values but all other fields are different. Worksheet1 Col"A" colb colc cold ...
35 views

How do I make a function update dynamically when I make changes to the function in a “master” cell?

For example, column 1 would contain input data, and subsequent columns would perform actions on that data. Row 1 would be the master row. All changes to the formulas in row 1 would be duplicated ...
34 views

Get row number for the row matching multiple criteria in Excel

I have 2 worksheet that work together. Worksheet "Application" has a DATE column, a CODE column (a single digit number), and a VALUE column with a dollar value. Worksheet "Scheduled" also has a ...
28 views

How can I find max value for a text as unique identifier in Excel?

This is basically for an auction setup in Google spreadsheet. Say there are 26 bidders A to Z and each bid 5 times with different values. I need to find the max value bid by each of them and display ...
765 views

How do I get “yes” or “no” in Excel if the information comes from “true” and “false”?

first of all, I have to point out that I am a German visiting this forum (I couldn't find anything useful on the German websites), so excuse my English if it is bad here and there ;-) Here is my ...
38 views

Excel: Use array to sum product by row

Is there a way to use SUMPRODUCT or use an array formula with arrays of differing sizes? Currently I have a list of ~1500 products in column A and columns B-I contain their respective component ...
102 views

Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values in column B, and depending on that value, put the answer in column C. For example, using the table below, it searching in ...
32 views

Comparing two strings in excel, add value for common variables

I'm comparing two large datasets containing strings in excel. Column A contains the numbers 1-1,000,000. Column B contains 1,000,000 strings, neatly organized in the desired order. Column C contains ...
46 views

IF formula returns wrong value

https://www.dropbox.com/s/v6nd2z4icftmnvf/example1.xlsx We have Excel 2007 (German) and vista ultimate. I am trying Excel by building a roster but have run into a problem with the following formula. ...
49 views

SUM From Sheet 1 Columns to Sheet 2 Rows

Tried searching for a while, didn't see what I was looking for. On Sheet1, I have approximately 100 columns, each representing an item. Each row is populated by a quantity of that item. As you can ...
47 views

Average Difference and Direction Between Values in Excel with Blanks

I have a sheet that looks something like this: Sheet 1 1 2 3 4 5 6 7 8 9 10 11 1 6 2 3 5 3 ...
30 views

VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure: Fill one cell with a formula, where arguments to ...
27 views

Auto Updating Month Over Month and Year Over Year formulas

I have a spreadsheet that has several different sheets (Visitors, Buyers, Conversion Rate, GMS). Each sheet has the data on that statistic monthly from 2013 onward. So sheet 1 shows monthly visitors ...
44 views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
29 views

Excel: how to link cell from one sheet to another

could you please, help me? i would like to find out how to do this: i have a sheet 1: with columns: number, name, color. i would like on sheet 2 to have 3 cells, where after entering the number, two ...
24 views

How can I use COUNTIF and TODAY functions to identify work deadlines in multiple worksheets?

I've been playing with our spreadsheets at work and have been able to create a basic formula that will identify when there is a deadline on today's date that needs completing. The issue I now have ...
44 views

Excel One cell to many formula (I realize this may not be possible)

First of all I want to start by saying I know this is either extremely difficult or impossible. I have data (from wikipedia, on any airport in the airlines and destinations list), in one column is ...
42 views

Use an user defined function for data validation

I created a named range which is the result of a user definer function. Let say my rage is named List and has three items, if I select three cells and enter =List and press Ctrl+Shift+Enter, I get ...