**0**

votes

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

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

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

**2**answers

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

**1**answer

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

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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