# Tagged Questions

**0**

votes

**2**answers

7 views

### Assign the value of a cell as a cell reference of another cell in Excel - How to?

The intention behind this query is to simplify the review of excel sheets with engineering calculations.
Let us assume that column A contains the notations. cell A1 contains "Rfa" and cell A2 ...

**0**

votes

**1**answer

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

**0**

votes

**2**answers

18 views

### Cells show formula, not formula result

We have an existing spreadsheet that has been working fine. Today we double-clicked a cell, to edit the formula, but did not change anything (we tested on other cells to check). When hitting enter, or ...

**0**

votes

**1**answer

20 views

### Combining Two Differently Formatted Spreadsheets

I'm relatively new to excel and am having some issues comparing two sheets of data. We're looking at the benefits over the fiscal year by month. One spreadsheet has the project ID on the left, and the ...

**2**

votes

**2**answers

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

**3**

votes

**3**answers

78 views

### Excel Scheduling - trying to calculate hours after midnight so they're not negative

If anyone can give me any type of help on why I have negative numbers instead 40, which is what it should equal please help. I'd be so grateful. Thank You!

**1**

vote

**1**answer

75 views

### Excel - Parsing data to template

I'm not sure if this is possible in Excel.
I have a sheet that looks like:
+---------------+-------+--------+-------+-------+-------+-------+-------+-------+
| | August ...

**2**

votes

**2**answers

28 views

### SUMIF/ COUNTIF (look up names from column 1 then sum numbers from column 2)

I need to look up names from column 1 then sum numbers from column 2. Some names in column one appear more then once. (The spread sheet I am working on has 7400 rows!!!)
Example:
Column A ...

**-2**

votes

**0**answers

42 views

### VB macro for excel

Coding a lil' macro so it pulls data from one book and paste's it into another book and I'm a little stuck. It copies data but only from the book I created the macro/button in, and not any other book.
...

**-1**

votes

**0**answers

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

**-1**

votes

**1**answer

22 views

### Get differences between two Excel 2007 rows, showing relative changes in second column [on hold]

I want to create a spreadsheet where column A has a list of numbers and column B has the totals. I want to create a formula where the difference between each cell in column A is displayed in column B, ...

**0**

votes

**1**answer

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

**-1**

votes

**1**answer

23 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"?

**0**

votes

**0**answers

23 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

**1**answer

19 views

### Financial Quarters from date

I have looked around for other solutions to this issue using the =ROUNDUP(MONTH(A1)/3,0) code.
However I am not using the standard dates for Quarters
Q1 - 02-Feb/03-may
Q2 - 04-May/02-Aug
Q3 - ...

**0**

votes

**0**answers

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

**0**

votes

**2**answers

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

**2**

votes

**2**answers

773 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

**2**answers

54 views

### Power Pivot - Average time per item

I'm trying to calculate on average, how long it takes to make each item.
Here is the data table:
Date Item Quantity Operator
01/01/2014 Item1 3 John
01/01/2014 Item2 5 ...

**0**

votes

**1**answer

23 views

### How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2
i want to call "ASD" in instance 2 ...

**0**

votes

**1**answer

26 views

### Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel.
Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...

**1**

vote

**3**answers

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

**1**

vote

**1**answer

19 views

### Comment in fixed line in Excel gets truncated when I scroll down

I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, ...

**0**

votes

**1**answer

23 views

### Can I use excel to read barcodes and take me to a specific cell?

I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. ...

**1**

vote

**0**answers

32 views

### Getting Excel to “update” or “follow” a linked Access table?

I'm using Excel and Access 2007. I'm having an issue at work and my current knowledge of Access and Excel isn't enough. I have an Access database that has certain data in it. I have an Excel ...

**1**

vote

**0**answers

25 views

### Align column of numbers, negative numbers, decimals and percentages in Excel

My list of numbers contains the following:
48.8
4.19
(0.36)
4.52%
and I want them all to align by decimal. As far as I can tell it is not possible in a single step and the best I can do is paste ...

**1**

vote

**1**answer

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

**2**

votes

**1**answer

62 views

### Create a linear trend line in Excel graphs with logarithmic scale

I I have an Excel scatter chart with x and y values.
I set the logarithmic scale in x-axis and y-axis.
When I add a linear trend line to the graph, the line is not linear but appears like a curve.
...

**0**

votes

**0**answers

32 views

### Macro to copy values to new sheet and prompt user where they want to save

I'm looking to create a macro in Excel 2007 which will do the following:
copy the formatting and values from a sheet called 'report',
insert this into a new workbook, naming the file with the value ...

**0**

votes

**1**answer

30 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

**2**answers

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

**-2**

votes

**1**answer

34 views

### sum the values in a column and add the sum to the filename of a workbook

Hello I have been able to create new worksheets based on unique values in a column. In addition to this, i want to sum up the values in a column and include this sum in the filename of each ...

**0**

votes

**1**answer

32 views

### Excel: Copying web table or saner way of merging cells?

I have an issue where copying information from a table in a web page to Excel doesn't copy the headers cleanly. The headers look something like this:
# Line Part Part Description List
...

**0**

votes

**0**answers

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

**0**

votes

**0**answers

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

**0**

votes

**1**answer

63 views

### Excel cells- show displayed text instead of value in Data Validation list

I read this topic: Excel cells - show text different to the actual value?, and now I'm trying to use it as a Data Validation list in Excel.
But when I choose for the list those cells, when I choose ...

**0**

votes

**1**answer

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

**0**

votes

**0**answers

8 views

### Excel group files not opening

The OS is Windows XP 2003 server and the program is Microsoft Office Standard 2007 (Excel). This computer recently upgraded from Office 2003 to Office 2007.
Upon clicking any .xls or .xlsx book file ...

**0**

votes

**1**answer

47 views

### Excel - Counting unique values with multiple criterias

I have a large scale data set and I am looking for a way to count the number of unique values:
Day -ID, Location-ID, Truck-ID
1, 18, 1
1, 19, 1
...

**0**

votes

**1**answer

21 views

### Replace two numbers in a column with 99

I have Selling Price which is not in proper format as its converted from Dollar to our local currency.
So the amount in the column are ending with random number. I want to change last two numbers to ...

**2**

votes

**1**answer

90 views

### How to create a stacked bar chart that displays data in monthly intervals?

I have a table with dates and prices, and I want to create a bar chart, which shows me total amount spent in months. Table looks like this:
30.5.2014 700,80 CZK
6.6.2014 1 000,30 CZK
20.6.2014 ...

**0**

votes

**2**answers

57 views

### How do I categorize a list?

I'm looking to categorize/sort a list by matching certain strings. I previously couldn't find a solution so hopefully this way is easier.
Example list:
[A]
The apple is the pomaceous fruit of the ...

**0**

votes

**0**answers

46 views

### Excel Table Copy Wrong Formula with Newly Inserted Rows?

I am trying to create a simple spreadsheet to track costs. I have a total of five columns with different categories, two of which have formulas. I wanted to be able to insert a new row into the ...

**0**

votes

**2**answers

34 views

### Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007).
It doesn't format the year, it just states yyyy instead of e.g. 2014.
If I have a cell with 23-7-2014 and use the formula ...

**0**

votes

**0**answers

50 views

### Microsoft Excel 2007 - Auto Update in 1st Sheet based on What updated in 2nd sheet (2nd sheet Update will be in Fixed Column but Random Row)

Actually I'm facing a problem now.
I am using Excel 2007.
And, I have two different sheet of excel file with me.
My 1st sheet is my report.
My 2nd sheet is my customer name.
I hope that when ever ...

**1**

vote

**0**answers

75 views

### vlookup in a cell that contains mid formula

I am trying to create a vlookup in a cell referencing a specific cell so that I can pull the data from my lookup table. Well this cell that I am referencing happens to have a mid formula in it, and ...

**1**

vote

**1**answer

29 views

### How to remove one column of a calculated item in Pivot?

I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...

**0**

votes

**0**answers

34 views

### How to Group and Layout Pivot Table when Values is in the Row Labels Field?

I'm attempting to present large amounts of data in a report using a Pivot Table to allow for dynamic filtering/categorization. The data in the table is of the form:
Year Month Category Region ...

**1**

vote

**2**answers

23 views

### Single formula to search column and return corresponding fields

Am having issues creating a single formula to search the billionaires list by name and autofill the rank, age, net worth, and citizenship field in the search spreadsheet.
This is the formula I have ...

**0**

votes

**0**answers

16 views

### Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010.
It's a excel 79 to 2003 xls file.
We checked trust centre on 8.1 but no joy, ...