0
votes
0answers
15 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 ...
0
votes
0answers
3 views

Google Sheets Suffix To Column Cells [migrated]

I'm editing a spreadsheet of product data that has a category column. I'd like to create a new "Left Handed" as well as "Right Handed" category in addition to each products current categories. I've ...
0
votes
1answer
15 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: ...
0
votes
1answer
17 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 ...
0
votes
2answers
24 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 ...
0
votes
0answers
34 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 ...
0
votes
2answers
22 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 ...
0
votes
2answers
15 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 ...
0
votes
3answers
14 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 ...
0
votes
0answers
31 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 ...
0
votes
1answer
26 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 ...
0
votes
2answers
24 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 ...
2
votes
2answers
728 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 ...
-1
votes
1answer
21 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 ...
0
votes
3answers
78 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 ...
0
votes
1answer
22 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 ...
1
vote
3answers
42 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. ...
0
votes
2answers
39 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 ...
0
votes
3answers
44 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 ...
1
vote
1answer
22 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 ...
0
votes
0answers
21 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 ...
0
votes
1answer
35 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 ...
0
votes
1answer
23 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 ...
0
votes
1answer
21 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 ...
1
vote
1answer
42 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 ...
0
votes
1answer
22 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 ...
0
votes
0answers
18 views

How to check if cell contains entry from another column?

So basically I have a column(A) with company names and addresses together. I have another sheet with a column(B) with the company names that are members. I want to check if the companies in A are ...
0
votes
2answers
26 views

Excel: Random select within table that meets two criteria

Here is an example of my data: Name: Office: Years: John Smith Canada 1 Bob Smith Canada 1 Jake Smith Canada 1 Sarah Smith Canada 1 On another sheet I want ...
0
votes
1answer
22 views

Generating Joint Density Function in Excel

Is it possible to have Excel calculate a joint density function based on two sets of descriptive statistics generated by the Data Analysis tool? To explain further, suppose I have two means a and b ...
0
votes
1answer
24 views

Get result of formula as text

I have an Excel doc which populates a matrix using formula, for example; | A | B | C 1|=1+2 |=2+2 | 2| | |=4-1 would display as; | A | B | C 1|3 |4 | 2| ...
1
vote
1answer
19 views

How to return the text left of line break

I have a Excel sheet, which contains a cell with this content: Text1: "abc" linebreak1 .... Text31: "mno" linebreak31 Text 32: ... linebreak32 ... Text50: "xyz" linebreak50 No I will ...
0
votes
1answer
24 views

Conditional formatting

What I am looking to do is have a conditional format set up so that if row G contains the value "In progress" "With 3rd Party" or "Identifying" and row H, J or K contain no value then highlight rows A ...
0
votes
2answers
14 views

IF Function on excel - i need to put a formula into one cell using to < < however it isnt working

I need to put in one cell that IF the value of H3 and F3 is lower that 25000 but higher than 0 it will equal 29.95, if false 0 the formula =if(0
0
votes
2answers
29 views

Excel: Percentages and ranges

I am attempting to make a bonus spreadsheet for work and am having some issues with the following. I am using this formula to determine 80, 90 and 100% ...
0
votes
1answer
58 views

Excel Formula: An Array formula containing VLOOKUP, SMALL, IF, OR

I am trying to create a formula that considers the data from three columns Y, H and V on my tab titled 'Data', returning the smallest value in A that meets that condition, once found Vlookup that ...
-2
votes
0answers
23 views

Excel formula to copy text from another sheet in other cels

Hello I have this situation. In sheet 1 I have rows a1, b1, c1, d1 and pasting them to sheet2 (sh1)a1 into e8 then (sh1)b1 into e10 then (sh1)c1 to e12 and (sh1)d1 to d22. Then from sheet2 I wont to ...
0
votes
2answers
40 views

How to sort columns in Excel so that only one value appears in each row?

Say I have a a spreadsheet with the following data: A B C D --------------------- 2 1 0 2 3 2 1 4 5 3 3 6 7 5 6 8 11 8 10 10 ...
1
vote
1answer
17 views

excel grid to columns

I have data in an array/grid like this: Name | Group | A1 | A2 | A3 name1 | Group1 | 14.95 | 19.95 | 0.00 name2 | Group2 | 4.95 | 9.95 | 12.95 name3 | Group2 | 49.95 | 0.00 | 0.00 And I need a way ...
0
votes
1answer
21 views

Construction Quote Log

I'm reworking my company's log of the proposal's we send out. Trying to indicate the total dollars that we could conceivably be awarded. The challenge I'm having goes something like this: We are a ...
1
vote
1answer
18 views

Using column data from another worksheet

I have a worksheet with one column and that has a list of my company names and what I want to do is be able to create a stats worksheet where I can use those company names without changing both ...
0
votes
0answers
28 views

Go to first non-negative cell in a row and divide by another cell

I'm looking to have Excel calculate the financial payback period for me. In words, I'm trying to count and return the first non-negative number in a row and divide that value by a corresponding cell. ...
1
vote
1answer
32 views

How to perform a function based on surrounding cells in Excel?

My rows on my spreadsheet look like the following: foo | cherry | 400 bar | lemon | 300 foo | cherry | 500 bar | cherry | 70 I want another row to make calculations in column C based on the ...
1
vote
0answers
16 views

Excel Table function

I got a Excel file. There is a formula, {=TABLE(C7,C5)}. I cannot find any table name from ribbon Name Manager, so I think there is no table. Then what is this formula doing ?
0
votes
0answers
38 views

Excel 2010 Compile Data from Multiple Worksheets into Summary Spreadsheet

I've compile a structural steel and architectural finishes material take off for an industrial building. I simply tallied the quantity of each length of each shape on a sheet corresponding to each ...
1
vote
1answer
39 views

Working with cell addresses in excel with VBA

I have a Excel sheet in which are multiple forms. The forms look all the same and they have exact the same cells between them. They are ordered in 4 x 3: x x x x x x x x x x x x x x x x .... There ...
-1
votes
0answers
39 views

How do I use VLOOKUP or other lookup function to return all results of criteria?

I have a spreadsheet like this: **Column A:** **Column B:** apple 1 apple 1/red apple 1 apple 1/green apple 1 apple 1/yellow apple 2 apple 2/blue ...
0
votes
1answer
24 views

excel text to specific cell

so i have this problem i want to get a specific cell from text i mean that i have made a table 1,2,3... A,B,C,.... i made a vlookup to search for specific letter in number so if i press 1 in a A3 it ...
-1
votes
1answer
25 views

Excel, Write a value based on a counter

What I want to achieve is very simple. Based on the value of an Excel cell (let's consider it X), I want to write a specific value in X subsequent cells. For example, if A1 has the number 3, a ...
1
vote
3answers
47 views

Excel date & time formula-round up cell value

I'm preparing a report of usage statistics for a group study room reservation system we use at the library where I work. I've exported all the reservations from MySQL in Excel for the past year and am ...
1
vote
2answers
38 views

Excel to calculate summation with exclusion list

Say I have a table like below: Task Time a 1 b 2 c 4 d 8 -------- sum 15 When a task is finished, I would like to add strike line to the row and exclude it from summation. Adding ...