0
votes
0answers
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
1answer
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
2answers
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
1answer
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
3answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
2answers
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
2answers
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
0answers
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
2answers
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
2answers
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
0answers
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
0answers
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
1answer
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
3answers
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
2answers
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
2answers
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
4answers
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
1answer
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(?) ...