0
votes
1answer
24 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 ...
0
votes
1answer
18 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
0answers
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 ...
0
votes
0answers
32 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
2answers
25 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
736 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
vote
3answers
45 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
1answer
23 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
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
25 views

How do you add text to the end of a cell in Excel

I am wanting to add the same text to the end of about 10,000 cells, but I don't want to go through and manually type it in on every cell. So basically, I want to: A1 A5 text =A1+"file" ...
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
27 views

Copying VLOOKUP formula in multiple sheets, where sheet number automatically changes

I have created a progress card in Excel (there are 50 such sheets, one each for 50 students). There is one tabulation sheet also with the names of the 50 students. So, when numeric marks are entered ...
0
votes
0answers
29 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
0answers
45 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
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 ...
0
votes
0answers
33 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
0answers
42 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
1answer
21 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 ...
1
vote
2answers
22 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 ...
1
vote
0answers
18 views

Looking up the same value in a row and returning multipe corresponding values

I am trying to lookup value 1 in the example below and return corresponding column name. When I use index match, it only looks up the first column which corresponds to 1 in the below example, it looks ...
0
votes
0answers
29 views

EXCEL: I have a column of single-word strings and would like to see if any of these strings are contained in a column of multi-word cells

Example: In column A I have a list of words "Apple, Banana, Orange, etc." each in their own cell. In column C I have a column of multi-word strings like C1="I ate an apple", C2="Bananas are gross" ...
0
votes
0answers
23 views

Convert COUNTIFS formula to SUM(IF) to enable external workbook references?

I need to convert the following formula to one that uses SUM(IF), as I am given a #value error when the external data source is closed. ...
2
votes
1answer
75 views

Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following: = A1 + A2 = B2 + B2 etc., ... I would like to replace each of these cell references with the values without ...
0
votes
1answer
37 views

How to I use SUMIF or SUMIFS to automatically add the values of different cells when they meet they meet multiple criteria

Basically I have a spreadsheet with three criteria columns. I would like to be able to recognize duplicate HTS codes that also have the same country of origin and add the sum of those values, which ...
0
votes
1answer
27 views

Copy the content of one cell, and insert within 2 characters, in the middle of a text content from another cell (Excel)

I am trying to batch copy the content of the cells in column A, and insert it within the "><" of the text in the column B. The result should look like the output in column C. Here is an example: I ...
0
votes
0answers
78 views

Return value from table using Multi-dependent drop-down list

I am trying to obtain the value of a column header (or topmost row value for a specific column) based on the selection of properties from 2 drop-down lists. ...
0
votes
1answer
33 views

Hide sheets in shared excel workbook.

I have a shared workbook on which I have hidden some of the worksheets prior to saving. I have closed the workbook. If another user opens the workbook the worksheets I had hidden are visible. If I ...
-1
votes
1answer
26 views

Excel searching column and copying the cell next to it

i need to find the value from column C in the row B, and copy the value from found result in column D. If it's possible with formula and to copy formula to all cells in column D ? without VB? Thanks ...
3
votes
1answer
121 views

Excel 2010: Formula for Sum and Return Date

I have a workbook with a Summary sheet and a Data Set sheet with a linked table containing 700k+ records of financial data on investments. (In my particular case, it is real estate properties; but ...
0
votes
1answer
92 views

Pie Radar Chart outline series not working

I have been trying to create a Pie Radar Chart as described in answer to this question. Everything works until I get to the section that describes inserting a series to create the chart's outline: ...
0
votes
1answer
78 views

Microsoft Excel 2007 - Drop down list that grabs multiple columns from another sheet

I've been scouring the internet for this but can't seem to find a solution. Let's say I have 2 Sheets - "Items" and "Inventory". Inside "Items", I have 3 columns: Item Name Item Type Item Cost ...
0
votes
1answer
74 views

Excel: find the cell that another formula found its “answer” in

I made a formula that searches an array to return a value, and now I want excel to "show its work" and tell me in which cell it found that value. I've been fighting with MATCH and ADDRESS but so far ...
0
votes
1answer
84 views

Excel Help: Search Column A, Sheet 1 for same value in Column A, Sheet 2, return value of Column B, same row in Sheet 2 [closed]

I'm surprised I couldn't find the answer on Google, maybe I am being silly. I want to perform this function:- I have two sheets in Excel, lets say they are Sheet 1 and Sheet 2 In Column A, Sheet 1 ...
0
votes
1answer
55 views

Excel formula for collapsing adjacent rows with a sum

I have a spreadsheet with values like so: blah 1 12 2 12 3 12 foo 1 6 bar 1 2 foo 1 6 2 5 Numbers in the middle column range from 1 to 8; ...
0
votes
1answer
72 views

How to require a cell input if another cell has a value

I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I ...
0
votes
0answers
39 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
1answer
56 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
2answers
64 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 ...
3
votes
1answer
499 views

Add/Subtract button Excel VBA

Here is an example of my project in this picture I like collecting, so I am making an inventory sheet in Excel. I want to make a way that I can click a button and it affects the next, or previous ...
0
votes
1answer
70 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
2answers
101 views

Is there one simple formula for Excel that can identify a string contain non-ASCII Characters?

I know that using the clean formula, I can clean up some of the non-ASCII characters (such as additional non-printable ASCII control characters #0 through to #31, #129, #141, #143, #144, and #157 ...
-1
votes
1answer
48 views

How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ? So, this... A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB ...should split as below, B1 ...
0
votes
2answers
53 views
0
votes
2answers
127 views

Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF

Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS. There is a mistake in my formula but I can't find a way to have it since ...
0
votes
2answers
145 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, ...
1
vote
2answers
113 views

Excel SUM function for whole column?

How can I sum the whole column without freeze head? I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, ...
1
vote
1answer
114 views

Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...
0
votes
1answer
98 views

Defined Name to give text or date value instead of numeric value

I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank. But when I use this defined name in another cell, the second ...
2
votes
1answer
412 views

Excel - sum values based on a column that match another column in another table

I've been working my head around this, but haven't figured it out yet, and I'm sure it's dead simple. Suppose the following example: There are two tables, one containing animals, and the other one ...
1
vote
2answers
117 views

MS Excel Column content replication across two sheets

Microsoft Excel functional Question How do I replicate (copy a column contents of Values to another sheet column) of a whole column (with data content) from a primary sheet to an secondary sheet in ...