# Tagged Questions

**0**

votes

**1**answer

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

**1**

vote

**1**answer

15 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

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

**0**

votes

**0**answers

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

**0**

votes

**0**answers

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

**-1**

votes

**0**answers

22 views

### comparing 2 columns in excel and return the same result in a group

hi m new in excel function,
i have a problem like this. i have 2 lists of data
DATA I
NAME SCORE
----- -----
ANA 10
BUDI 20
TINA 30
DATA II
NAME SCORE
----- ...

**2**

votes

**1**answer

42 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

**0**answers

34 views

### VBA Code to update data in closed excel files within a folder by clicking a button

I have a code which works really well that updates values of closed excel files in a workbook. What I want to do is alter the code so I can create a on my worksheet where I can make y changes I ...

**0**

votes

**1**answer

22 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

**0**answers

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

**-1**

votes

**1**answer

18 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

**1**answer

105 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

**0**answers

15 views

### How do I copy datas with blank/tab into multiple excel cells?

I got a data like:
xx5 600 200
xx6 500 100
I want to copy them into multiple excel cells, like:
--------------------------------------------------
| xx5 | 600 | ...

**0**

votes

**1**answer

50 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

**1**answer

57 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

**1**answer

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

**1**

vote

**1**answer

58 views

### Excel 2007 or 2010 copy/paste without merging cells & with shift all down

Let say I have an excel sheet with structure like
I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116):
And click Ctrl+V. It gives me ...

**3**

votes

**1**answer

168 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

**1**answer

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

**-1**

votes

**1**answer

40 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

**2**answers

81 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

**1**answer

76 views

### VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function.
The purpose of the macro is after ...

**1**

vote

**2**answers

31 views

### How do I find matching data in Excel?

I am trying to find some files listed in a big Excel workbook.
On Sheet 1 I have the list of all the files with full path.
C:\A\B\01.xlsx
C:\A\C\02.xls
C:\A\D\03.zip
C:\A\E\04.jpg
...

**1**

vote

**2**answers

89 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**

votes

**1**answer

51 views

### how to copy data from on cell to diferrent cell using command button

for example the first thing i put in cell b1 has "='Ex-post'!C172"which has value "1" and c1 has "=OFFSET('Ex-post'!$B$4,MATCH($H$1,'Ex-post'!$B$5:$B$542, 0),4)" in which the value is 2300 and i want ...

**1**

vote

**1**answer

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

**1**

vote

**2**answers

130 views

### Excel Lookup adds double quotes to string

I'm using this formula to get value form a table
=LOOKUP(C11;Alias[A];Alias[B])
where C11 = 12354567
But when I use
=LOOKUP(LEFT(C11,7);Alias[A];Alias[B])
where C11 = 12345678, the formula does ...

**0**

votes

**1**answer

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

**0**

votes

**3**answers

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

**1**answer

45 views

### excel - if value grater than, use that value

I am having problems with my excel function. I want to:
if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell.
...

**0**

votes

**1**answer

110 views

### Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100.
On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...

**0**

votes

**2**answers

283 views

### Excel - column width differences in copied worksheet

I have a workbook that I created using Excel 2007. In Excel 2007 I can copy one of the worksheets to a different workbook with no problems. However, using Excel 2010 I'm getting odd behavior. I open ...

**0**

votes

**1**answer

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

**-1**

votes

**1**answer

117 views

### Invalid date value in csv file

I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...

**0**

votes

**1**answer

93 views

### Count from a cell with value to the end of row and dividing total by number of number of months regardless of blank

How do I write a formula that will auto start sum from the first cell with value though to the end which including blanks, and then divide the total by number of cells from the one with value through ...

**0**

votes

**2**answers

374 views

### Compare two columns in two sheets

I have another question, even though the last one i asked is still pending. I have a large data of over 100,000 records. I am using the code below to loop through the data so that any duplicate ...

**0**

votes

**1**answer

796 views

### Creating chart in Excel where data for X-axis (horizontal) is non linear and extrapolating value

Have some data of the following form:
X | Y
----+-----
3 | 42
4 | 57
6 | 92
11 | 119
19 | 316
(NOTE: The above table is made-up data)
What I'd like to do with MS-Excel is to plot 2 ...

**0**

votes

**2**answers

52 views

### Formatting columns in microsoft excel?

I have a list (.txt document) of telephonenumbers with first and surname and number.
Like this :
123123 john doe
123132 michael jordan
etc.
I want to put the list in microsoft excel that after a ...

**1**

vote

**1**answer

305 views

### Conditional Formatting in excel based on another column

I have an excel worksheet and two columns. I highlight the first column if the value of the cells are less than 0.
Now how can I highlight the second column cells based on the first columns that are ...

**0**

votes

**0**answers

47 views

### Displaying some cells data depending on selected text from other sheet

I have an excel sheet which looks similar to below and with some more columns.
Area Branch Empolyees Products Shelfs
Area1 Area1 Branch1 10 Product 1 10
Area1 Area1 ...

**0**

votes

**0**answers

283 views

### Fill a web form with data from excel (macro)

I am new to VBA and I am struggling to find a solution for my problem. I have an excel database with UNs and PWs for a number of profiles. I also have an administrator UN and PW and each time I want ...

**0**

votes

**1**answer

151 views

### Disable custom view in Excel

I am using a shared excel workbook that everytime a user accesses it and saves it, it
saves a Custom View for them. I want to disable this settings so that every one can see only same view of the ...

**0**

votes

**2**answers

139 views

### Why is that sometimes the excel goal seek doesn't stop exactly at zero

I am trying to do find a solution of a variable using goal seek. The problem is that the value needs to be zero, but it doesn't stop at 0.It stops at 0.002. Whereas the same goal seek stops at zero ...

**-1**

votes

**2**answers

408 views

### How Do You Stop Auto Formatting to a Cell I'm Using as a Barcode Number [duplicate]

I am having a little bit of a problem with Excel. I am typing into a cell a barcode number for my products but every time I leave the cell it automatically formats the cell as below.
Number I want to ...

**1**

vote

**2**answers

83 views

### Excel: Check for specific value in a matching row

I want to check which products (listed in rows) are produced by which company (listed in column headings) in order to fill a table like this
Company A Company B Company C
Product 1
...

**0**

votes

**1**answer

33 views

### How do I lookup using 2 values, Verticle and Horizonal? (Apple Numbers)

I have a sheet that has an individuals info, one table as their Age (TABLE 1). Another Table has a score in cell (TABLE 2). I want to lookup the VALUE that corresponds with their age and score in ...

**0**

votes

**2**answers

2k views

### Comparing two columns in different Excel spreadsheets

I have two Excel spreadsheets. In the first spreadsheet I have two columns. Column A has 240 Accounts entries and Column B has Values for each account entry. Once again Spreadsheet 2 has its data in ...

**1**

vote

**1**answer

454 views

### Excel custom axis label

I'm having troubles with some charts I'm creating using Excel. Some of the values I'm plotting are too big (264) to be labeled in the axis. Due to this, Excel automatically puts them in scientific ...

**4**

votes

**2**answers

3k views

### Excel-Count number of visible cells containing certain string

I have a sheet in which I first apply a filter to a certain column to show "Unique records only". Now I have a column which contains, for e.g., values like:
Applepie
Applesauce
Crabapple
Banana
Mango
...

**1**

vote

**1**answer

126 views

### How to access the formatted text within an Excel cell with VBA

I have embedded formatting within an excel column. For example, a cell might contain some (but not all) italicised words.
The .Value, .Value2 and .Text properties seem to strip any formattting.
I ...