# Tagged Questions

**0**

votes

**0**answers

4 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 "1" and c1 has 2300 and i want to copy data in c1 to cell h1, then i clear what i put in cell b1 and c1 and put another like b1 "2" and c1 "2800" then ...

**1**

vote

**1**answer

12 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

51 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

32 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

37 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

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

**-3**

votes

**0**answers

14 views

### Fill series of hyperlinks in excel

in an excel sheet i have list of items numbered from 1 to 2000 I have images for them namely 1, 2, 3..jpg files in a different folder in C. help me to create automate hyperlink to link the numbers to ...

**0**

votes

**1**answer

48 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

80 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

78 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

87 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

33 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

82 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

114 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

41 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

89 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

34 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

227 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

80 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

44 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

149 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

51 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

28 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

185 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

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

**3**

votes

**2**answers

841 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

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

**2**

votes

**2**answers

100 views

### How to identify if a cell contains any of the values in a column

My question is the opposite (inverse?) of How to identify cells in Column A that contain any of the values in Column B. Specifically:
I have a list of 19,000 first names and 10,000 passwords. I'm ...

**0**

votes

**0**answers

31 views

### VBA Editor on F8 shows outlook insted of Step Into

Excel VBA Editor on F8 shows Outlook insted of Step Into. I don`t use it and it wants me to add my e-mail configuration every time. In other applications F8 works properly. What am I doing wrong?
...

**-1**

votes

**2**answers

46 views

### Excel formula to convert “Today, 10:18:03 AM” or “Tuesday, May 14, 2013 12:06:36 PM” to Excel date

Can someone come up with a formula to convert strings like the following to Excel dates? Note that it will say "Today, time" if the date matches today's date, otherwise it will say the day name. You ...

**0**

votes

**2**answers

49 views

### Plotting Graphs in Excel [duplicate]

I need to plot these values against time. Y are prices of an stock index and X are given in dates. When I highlight both the columns and insert line graph. The graph turns out wrong. Not sure why. ...

**1**

vote

**0**answers

71 views

### How to stop IE opening Excel spreadsheets in embedded mode?

When we open an Excel workbook with Internet Explorer (D:\Book1.xlsx in address bar) - IE opens the Excel workbook in embedded mode. It triggers Excel with the following option C:\Program Files ...

**0**

votes

**0**answers

55 views

### Indirect lookup across spreadsheets

I have a spreadsheet that has information about all products for every week of the year.
Currently I have a second spreadsheet that is setup to look at the first one for each field (currently has 52 ...

**2**

votes

**1**answer

51 views

### Excel lookup / value formula

Ok hard to describe this one.
I want to be able to create a formula where part of the formula is populated by info in another field.
e.g.
Sheet 1
A1 = TXT - A2
A2 = number - 1599
Sheet 2
A1 = ...

**1**

vote

**3**answers

26 views

### Summing up a row(where I am checking if the value is greater than -1% and lesser than 1%)

I want to check whether the value in the cell is greater than -1% and lesser than 1%.
Which I have done this way: C4>-1% *C4 < 1%
Then I want to sum up the number of cells that satisfy this ...

**0**

votes

**2**answers

43 views

### having cell show a paticular number if the answer in the formula in the cell is a certain number

so I don't know if it's possible but I want to have a cell show a particular percentage in the formula I put in the cell comes up with a particular answer. for example, if I put in the formula =6/3 ...

**0**

votes

**2**answers

471 views

### Conditional formatting of a cell based on value in 4 adjacent cells

I'm trying to get a cell C3 to highlight using conditional formatting, but based on a value in 4 other cells.
If 4 continuously adjacent cells (e.g. AS3, AT3, AU3, AV3) contain the X value only then ...

**1**

vote

**0**answers

51 views

### .xls Excel File With Protected Fields Allow Editing in 2007, Not 2010 or 2013

We have a form in use at the office. This form is a .xls file. Most cells are protected with the exception of data entry cells. I am able to edit at will in Excel 2007, however in 2010 and 2013, any ...

**2**

votes

**1**answer

470 views

### Excel array formulas to find smallest date with multiple criteria

The array formula I have will give me the smallest date from a Service table, based on the following criteria:
1) The value in the item column matches the item # in cell A1
2) The value in the ...

**0**

votes

**1**answer

124 views

### Excel - value of the last changed cell in row

I hope someone can help, I have a number of cells in a row which is filled automatically by another application, I need to read the last changed value in that row into one cell. I know I can create ...

**1**

vote

**2**answers

2k views

### How to change date format from dd-mm-yyyy to dd-mm-yy in formula bar of MS-EXCEL? (Still didn't got satisfactory answer)

I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type ...

**-2**

votes

**1**answer

2k views

### Match up 2 columns in excel from one worksheet to another worksheet

I'm having trouble comparing two worksheets. I have worksheet A and worksheet B. In each worksheet, column A have the customer number and column B have the date. The same client and same date can ...

**4**

votes

**1**answer

49 views

### 2007 Worksheet Opens with Errors in 2010

I am trying to help a customer with a specific problem that they are having with deploying an Excel 2007 Worksheet to users if they are running Excel 2010.
The spreadsheet in question has 5 to 6 ...

**0**

votes

**1**answer

290 views

### How do I avoid #value in my excel sum equation?

When summing for the cells with nothing in them, I get #value using this formula
=CB85+CC85
Yet I don't get it when I use this equation:
=SUM(CI157:CJ157)
But on using =SUM(CI157:CJ157) I get a ...

**0**

votes

**0**answers

79 views

### excel pivot table structure in 2007/2010

In Excel 2010 my pivot tables have the following structure:
Report filter (All)
(blank line)
Row Labels Average Value
(data)
In 2007, the same file looks like
Report filter (All)
...

**0**

votes

**1**answer

169 views

### Single cell with structured table references with Excel 2007

I need to find the Excel 2007 syntax, for getting the cell (eg. 2nd row, 3rd column), in table reference flavor.
To be clear, ref to the Microsoft - Using structured references with Excel tables ...

**-4**

votes

**1**answer

58 views

### Want calculate the result depend on the output of the value of the same calculation

"=IF(AND(L2>0,L2<=3500),C2*50,IF(AND(L2>3500,L2<=25000),C2*35,IF(AND(L2>25000,L2<=40000),C2*25,IF(AND(L2>40000,L2<=50000),C2*21,C2*18))))"
I am getting 0, but I understand that it will ...

**1**

vote

**1**answer

89 views

### How can I use excel to create a multiple IF function?

I have a spreadsheet comparing numbers of programmes sold by my company. I want to create a formula that will total several variables.
In one column I have the month then whether it is a "Finance" ...

**0**

votes

**4**answers

1k views

### How to stop Excel from formating the 16 digit account number in a way to avoid making the last digit zero?

I have large number of bank account numbers of different banks. Some banks account number start with zero and some have 16 digits. When I paste the data in Excel the leading zeros will be removed and ...

**0**

votes

**1**answer

64 views

### How to convert 58m32s to 00:58:32 or 72m10s to 01:12:10

I have a excel column with data like:
58m32s
72m10s
125m02s
And would like to show it like:
00:58:32
01:12:10
02:05:02
What formula combination should i use to make this possible? This should(?) ...