Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
1answer
17 views

Open .WQ1 file (Quattro Pro) in Excel

I am really struggling to find a way to open these Quattro Pro files in excel. I have tried Libre as well. Cannot seem to find something to import these things. Please help
2
votes
1answer
41 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
33 views

If statement conditions

I want to include an IF statement result in the same cell as the result of a formula in Microsoft Excel. Below is what I mean Cell 1 = the answer to a formula e.g =SUM(I19)-Sum(K19/100*I19) I want ...
0
votes
1answer
32 views

Conditional Formatting in Excel within a range

Problem Is it possible to CF a range which is already Conditionally Formatted? So far what i have done =AND(B$5<=$C$2,$A6<=$C$3) range =$B$6:$O$19 ...
0
votes
1answer
31 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
29 views

How to make a dynamic table in excel?

I have 2 tables in excel like In Table: Product1 50 Product2 75 ... Out Table Product1 25 PRoduct3 40 ... And i would wish for a third table that will automaticly update when i add new ...
0
votes
1answer
47 views

How do I merge data from other excel files to one master excel worksheet?

I have an uniform ID system throughout all the files, except with multiple entries and differing data named columns. I would like to create a master excel sheet with specific data columns from each ...
0
votes
1answer
37 views

Hide columns based on content (sum of rows)

I'm trying to hide columns based on the sum of selected rows (i.e., cells) in those columns. For example - if the sum of E9:E12 is 0, then hide column E. Additionally, and probably a little harder - ...
0
votes
1answer
26 views

Excel Copy / Paste Specific Discrete Cells

There are a lot of questions pertaining to copy / paste on excel but I do not think there is one that is describing this exact situation that I am finding myself in. I am on Excel 2011 Mac and when I ...
0
votes
1answer
25 views

How do I search for an actual asterisk in Excel?

I want to search for and replace "*", an actual Shift + 8 asterisk.There is no option to turn wildcards on and off like there is in Word.
0
votes
1answer
9 views

RE: displaying max of direct data input or cell value from formula

With reference to : Excel - how to either have direct data input or cell value from formula I would like to inquire on a related issue. How would i edit my VBA formula if i would like to compare the ...
0
votes
1answer
12 views

Excel 2007 - Default parameter - Link update False - Open

I was wondering if it was possible to deactivate the update links in Excel 2007 by default. The same way it can be done in vba when you are opening a file (workbooks.open path... updatelinks:= False) ...
0
votes
1answer
28 views

How to calculate occurrences of some word in table

How can I calculate how many times occurrences any of these "value" Column for example I need: N 97 5 N 72 7 N 83 22 N 70 3 N 76 8 Z 34 7 N 85 2 ... ... ... and sorted ...
0
votes
2answers
43 views

Selectively find duplicates across columns

Column A has the product ID. There are 102 other columns with other data. Column A will be unique unless some data was changed. In that case, there will be 2 rows with 99% of the columns are ...
0
votes
1answer
17 views

excel - inserting a value based on a range of values

I need to link a batch code to a specific unit number. The batch codes are the same for a range of unit numbers. The first table below shows the unit numbers; the “?” marks are where I need to enter ...
0
votes
2answers
20 views

macro for replacing text with hard returns in Excel

How would I write a macro that would search for a specific symbol (in Excel) and replace it with a hard return in the same cell and maintain the cell integrity? I often convert word documents into ...
0
votes
1answer
12 views

Is there a way to group an excel table similar to a SharePoint list?

I have a data set in Excel that I would like to automatically group by specific columns while keeping the raw data viewable. When using a pivot table, understandably, I can only view a summary of the ...
0
votes
2answers
18 views

Exporting CSV file to VCF

I got a CSV file on Excel/Open Office and would like to import them on my iPhone but is proving an almost impossible task. Some people suggested to send the file to myself via e.mail but, when ...
2
votes
2answers
22 views

dragging to populate cells in Excel

I am aware that you can fill the cells in Excel as a series by dragging the square in the bottom right corner. for example typing "1" in Cell "A1" and dragging the box down to "A10" will give you a ...
0
votes
1answer
23 views

Disable or delete right click menus VBA

Whenever I right click on an excel sheet two menus come up: one with cut, copy, paste, etc. and one with font size, bold, italic etc. I can customize the first one to have whatever command I want. ...
1
vote
0answers
27 views

Excel: Replace Number Format in Diagram

I have an Excel Workbook which will be sent to a client and I need to get the thousands and decimal seperators right. I have a Workbook.Open routine which will change to custom formatting (and back on ...
0
votes
1answer
33 views

How to force time series in pivot chart — force break in line

I have a housing transaction dataset that looks like this: geography | date | housing type | sq.ft. | sale price | price/sq.ft. I can make a pivot chart showing the change in, say, price/sq.ft. ...
2
votes
1answer
87 views

Excel: How to create a nonuniform stack chart

I want to create a stack chart that shows the timeline of 3 phases on the x-axis (intervals separated by month) and total budget on the y-axis. The budgets for all projects will stack up against each ...
1
vote
3answers
46 views

Is there a quicker way to enter formulas?

In the firm I currently work in we have a very inefficient and time-consuming process for entering formulas. For example: Y1=CHOOSE(B3,'[Flacflow balancesflacflow.xlsx]Data'!$A$77, '[Flacflow ...
0
votes
1answer
35 views

Match Cell in One Column and Not Match in Other Column

I have 3 columns in excel. I want to compare the cells in column A to column B and C. If cell A1, matches with column $B:$B but not column $C:$C. I want to return A1 in Column D. How do I do this??
1
vote
0answers
28 views

Excel: Keeping references/links when transposing

I have a worksheet in where I have table (let's call it the summary table) with references to a another table (among others) which is 2x40 (rows x columns). I would like to tranpose this into a 40x2 ...
0
votes
1answer
55 views

For loop macro in excel

I am completely new to Excel, but I want to make a macro where I can fill in two columns, and the start and end number of the rows, and it will do this: (A1*B1+A2*B2+A3*B3...)/((SUM of column B)/N)) ...
0
votes
0answers
35 views

Forfiles SubFolders

I am hoping I can get some help here. I saw a another post similar to my problem and I figured I would give it a try. I have a Forefiles code running in Excel using VBA. The code works great on local ...
0
votes
1answer
7 views

Inspect document doesn't show anything, Excel 2010

In my Excel 2010 workbook I wen through File > Info > Check for Issues > Inspect document. But as it's shown following, it doesn't show anything. Why? Thanks in advance.
0
votes
0answers
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
1answer
45 views

Take data from one row and convert to 4 rows and repeat every four rows

I would like to go from here: To here: If there are other ways to do this please let me know. I've tried the offset and index features to no avail. The problem is when I try to autofill to the ...
0
votes
2answers
36 views

Excel - Referencing a cell in another sheet depending on its value

Here is my situation. I have two sheets. They are in a certain format, like this: 1. | Id-Number | Id-Name | 2. | Id-Number | Id-Other Value | I would like to take "Id-OtherValue" and add it ...
0
votes
1answer
57 views

Where can I find my office account email for office 365

I purchased office 365. In order to install on my computer I had to log in with email so I quickly made an email. The package I purchased allowed for install on five computers. But when I try to ...
0
votes
1answer
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
1answer
34 views

Trying to get an alert if three seperate cells do not match

Hi I am trying to put 2 formulas together in one cell The first is to give a sum, i.e. : =(D3+F3+H3+J3)-(C3+E3+G3+I3) The second is to check the resulting number above against a number total in 2 ...
0
votes
1answer
34 views

Get the index of selected value in Excel drop down

I have a drop down list generated in Excel from row values. I want to select from that drop down, get the index of that value in the drop down array, then use that for an offset value to select the ...
0
votes
0answers
36 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
23 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 ...
3
votes
1answer
26 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
1
vote
2answers
82 views

Remove non number data from an excel array

I'm having throuble using the method LINEST with data containing gaps. Order and remove the gaps by hand is not an option. I have found this: ...
2
votes
0answers
77 views

IE9 not prompting to save downloaded CSV file, opens in Excel

I am accessing a website that generates CSV files when I click a "download" link. Instead of prompting to "save or open", IE 9 is going right ahead and trying to open the returned file in Excel. Since ...
1
vote
1answer
23 views

PowerView to PowerPoint?

Is there a way to export PowerView slides/tabs to PowerPoint? I realize there are a couple articles on how to export PowerView from Sharepoint, but wondering if there is a way to do this for ...
-1
votes
0answers
21 views

Error when changing excel data sheets in word mail merge?

As part of a program i am working on data is transferred into an excel document with usually more than one worksheet. after that happens a mail merge is manually done to create labels. the problem i ...
-1
votes
0answers
27 views

Excel “NETWORKDAYS” formula

So I'm trying to compare 2 columns of dates in excel using the "NETWORKDAYS" formula but i have quite a bit of dates to compare. if someone could walk me through how to make it so column "C" shows ...
-1
votes
0answers
17 views

Excel or R: Make 1 file for each line of a table, preserving the headers

I have 200 lines in an excel table that I'd like to split into 200 files (csv), with the headers maintained in each file. Is there a way I can do this using VBA in excel, or even R? Many thanks
-2
votes
1answer
33 views

Microsoft office automation error

I am receiving an error when i try to create an excel workbook through a vb6 application. the error is a Microsoft Software Installer error 0x80004023. i have read over a similar question on a ...
1
vote
1answer
27 views

Excel Cross Referencing

Got an interesting problem that seemed trivial at first... I have a table in the following format: USER | QUESTION | ANSWER ======================== 1 | 1 | A 1 | 2 | B 1 | 3 ...
0
votes
1answer
12 views

Graphing only data from certain dates

I have a database that is filled in by multiple people at different times - I would like to create a graph that shows a time series analysis of only the last quarter's data. I know how to set up a ...
0
votes
1answer
22 views

Can I save an Excel chart to a PDF document with the chart's exact dimensions?

I want to save (or 'Publish') an Excel 2010/2013 chart to a PDF file whose dimensions will be exactly those of the chart - not a full white page with the chart on it. Can this be done somehow? ...
0
votes
1answer
47 views

Expanding a cell formula resolving all its references (precedents)

In Excel I have a cell containing a formula referencing other cells, which reference other cells and so on... forming a large tree of references. I'd like to substitute recursively all the occurrences ...