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)

1
vote
1answer
24 views

Alternative to cell highlighting using conditional formatting in Excel without causing freeze/crash

In column A, I have a value and I want to highlight if it doesn't match the same value in column B. I'm using the formula below in conditional formatting which works great. ...
1
vote
1answer
20 views

How do i add separate templates in each sheet in excell?

We have a set of templates created for our need , now I create a new workbook , I want to be able to insert a custom template in one sheet and another custom template in another sheet .
1
vote
0answers
25 views

How to extract only missing records from two given spreadsheets? [closed]

I have been provided with two spreadsheets, the first spreadsheet contains information about the member and the other contains the attendance on a particular day. Both have a common unique field which ...
-1
votes
0answers
23 views

Your formula is missing a parenthesis --)

I'm trying to add the ISNA formula to a long formula with IF/OR/AND statements in it. I have a summary spreadsheet that needs to look into different templates based on the account name listed. When ...
0
votes
2answers
42 views

Is it possible to convert a text date to one stored as a date in Excel?

I have dates stored as text in the following format: Mar 10, 2015 I want to convert it to a value stored as a date and display it formatted as yyyy-mm-dd: 2015-03-10 I initially tried to use ...
5
votes
5answers
205 views

PDFs as extremely small file size (i.e. less than 20kb)

What do I need to do in order to produce PDF invoices with a file size smaller than 20kb? Example PDF I create invoices for a small business and I have 60,000+ invoices stored as PDFs (non scanned) ...
0
votes
1answer
23 views

Graceful way to handle lookup errors in excel 2011 for mac

I would like to do a vlookup, and if the vlookup fails, return the just the contents of the source. Example: =vlookup(target,Range,column,FALSE) returns #N/A I want it to return target. Right ...
1
vote
1answer
35 views

Excel 2007 how to put a text message in a cell if multiple cells are filled with data

I am trying to put a text message in a cell (say c1) if multiple cells in column A have data in. The cells in column A are A1-3, A5, A6 A8 and will have data from 1-5. I only want the text message ...
-1
votes
0answers
30 views

Excel Help maybe a sumif?

I have a spreadsheet where column A has a employee number and a separate sheet has in column A employee name, column b employee number column c the dept, column d the employee class and column e hours ...
-1
votes
0answers
22 views

Pictures in Comment disappear when I send this file via email

I have an excel file, where I put the comments in as pictures. See here for how I did it. However, when I send this file, the pictures disappear. How I can keep the pictures in the comments for ...
1
vote
0answers
29 views

Remove Rows Not Part of Filter

I am filtering a large Excel spreadsheet. I want to remove all rows on the sheet that are not a part of the filter. I know I can copy the rows and paste them into another spreadsheet. But I would ...
0
votes
1answer
35 views

read punctuation in IF

=IF(MID(B3,ROW(A:A),1)=MID(B3,LEN(B3)+1-ROW(A:A),1),"T") I was reading Palindrome in cell B3 with above formula, it works fine(if find without punctuation & spaces). but when I try to read ...
0
votes
2answers
31 views

Excel 2007 - formula to display last updated cells

I have 6 cells, A1-A6 in Sheet1. A1,A3,& A5 contain numbers 1-3 A2,A4,& A6 contain the date the numbers changed. A1 & A2 will be filled first. I want to display both cells in Sheet2 in ...
0
votes
0answers
52 views

Turn one row into multiple rows in Excel

I have multiple items that are available in multiple distribution centers (i.e., a many-to-many relationship). There is currently one row per item, with one column for each distribution center. A cell ...
1
vote
2answers
65 views

How do you unprotect the VBA macros for a macro-enabled workbook if you forgot the password?

I have heard myths about how easy it is to crack a VBA macro password, but haven't been able to figure out how to do it myself. We have an excel file at work where the VBA is password protected and ...
1
vote
1answer
18 views

Condition formatting dates two week before the actual target date

I have a spreadsheet in excel with a formula that when I enter a date into column A cells, column B cells will enter a date 9 months - 1 day from the date entered in cell A1, A2, A3, etc... Now I ...
3
votes
1answer
83 views

How to plot multiple actual vs target in a chart? Up down arrows? And how to show cumulative?

I have Actual vs Target data for 5 teams. Subset of data table below. I want to show: Variance target vs actual Cumulative progress towards total target What is the best way to plot this data? ...
0
votes
0answers
11 views

Excel CSV/Text data from clipboard [duplicate]

How can I insert CSV data from clipboard into Excel 2013? In OOo Calc I can just use Ctrl+V, and Calc automatically opens an Import wizard with a ton of options and a preview screen.
1
vote
1answer
23 views

Get the Alphabetic Maximum

If there is a word in A1 and another word in A2, I can determine the "greater" by using: =IF(A2>A1,A2,A1) In cell B2. Here "greater" means if the data were sorted ascending, the value would be ...
0
votes
1answer
22 views

Conditional Formatting for Excel Greater than

I have applied a rule if the cell is greater than 50 fill with cell with RED. The cells are populated from another location. When I apply the rule the blank cells show up RED? Any help would be ...
0
votes
2answers
32 views

How can I create an IF-THEN statement in Excel with two variables?

A B C(Output) ----------- ----------- ------ | 65 | 0 | 2 | ----------- ----------- ------ | 31 | 99 | 3 | ----------- ...
0
votes
2answers
37 views

How to convert a Dell Service Tag to an Express Service Code Using Excel

I have all my Dell tags in Excel. I want to convert the short one to the long one. I need to convert the small code to a BigDecimal, can this be done in Excel. for Example: So Simple Typical ...
-4
votes
0answers
47 views

If statement mismatch

I'm trying to use the following If statement: ...
0
votes
0answers
15 views

Pivot table not showing blank values

I'm trying to get blank values to show in a Pivot Table in Excel. I've tried all the standard options under PivotTable options without any luck. I've also tried using a custom format for the cells ...
0
votes
1answer
25 views

Parse variables from URL with formula after pasting in Excel

I often have long URL's that have ampersand delimited variables at the end, and I would like to be able to simply paste the whole URL and have all the variables populate the fields below in the same ...
-4
votes
1answer
39 views

How do I copy the first letter of a last name in a another cell [closed]

Using Excel, in one cell is the name Smith, James. How do I copy the first letter of the last name, S, in another cell?
0
votes
1answer
23 views

PowerQuery to parse fixed width csv

I have fixed width csv.txt, e.g. Martin Junger 12 John Wing 124 To load it with PowerQuery this syntax is used: let Source = ...
0
votes
1answer
23 views

How to keep header row always on top in excel

I want to keep header row visible on the top all the time while scrolling in excel. How can it be done? I'm using excel 2010.
0
votes
2answers
24 views

How can i add a prefix in a single cell for multiple codes?

I have a country code in 1 column and multiple city codes in different column separated by comma, i want to prefix the country code to each city codes.. How can i do that?
0
votes
2answers
43 views

Is it possible to have an excel workbook automatically save as macro-enabled if macro is added to the workbook?

Currently, in Excel 2010, when I try to save a workbook that I have created as a .xlsx file but added a VBA function or subroutine to, Excel gives a prompt asking (in a round-about way) if I want to ...
0
votes
2answers
47 views

Select a number of rows from a set in Excel

I have a list of users in locations within my company. Vastly reduced from the 130,000 or so in reality, the data looks like the example at the end. What I need to do is to select a number of users ...
0
votes
1answer
17 views

Changing Clustered Column Parameters in Excel

I have a quick question about how to rearrange a clustered column chart in Excel for Mac 2011. Here are the links to my data and chart: Data: Chart: I want to switch the years with the ...
2
votes
1answer
41 views

How to turn a “many” row-based relation into a “one” column based layout

Pardon my English. I am looking for a method of transforming data for a set of products. The data set I have is a relationship where attributes are listed out in rows, and I want these attributes to ...
1
vote
1answer
26 views

Drawing independant columns in a pivot table

I have a list of items with several columns, including: ID date boolean A boolean B boolean C Columns A, B, and C are booleans, and I want to plot the number of each being TRUE, over time. Using ...
3
votes
1answer
40 views

Using a Defined Name in a Formula

I have a set of cells with values: A1,B3,C5,D7,E11,F13,G17,H19,I23 I have a formula to select, at random, the value stored in one of these cells: ...
1
vote
1answer
28 views

Create Excel Array In Formula Text

I'm using a formula that requires an input of a 2D range. I have all the data that should be in the range, but it's currently stored in a row. Is there a way to, within the body of a formula, ...
0
votes
0answers
18 views

Merging tables in Excel

I stumbled into Ajedi32's formula for merging two tables at How do I merge two tables in Excel that have identical columns? =IFERROR(INDEX(Table1,ROWS(A$2:A2),COLUMN(A2)), ...
0
votes
1answer
12 views

XNPV Excel function on Mac : not working?

trying to use XNPV (Excel) function on a Mac ; for some reason this does not work yielding only ERROR message (exact same exercise on PC no problem) ; error shows that through the (correctly ...
0
votes
1answer
20 views

Show Raw Data From PivotTable

In Excel, I have a PivotTable. I'd like to see all of the cells that went into individual calculation. For instance, if I would like to see all the individual values that made up B@ (Mark/Profit) in ...
0
votes
0answers
15 views

Exporting raw data of Checkpoint Firewall

I am looking to export a Checkpoint configuration to a Excel document (HTML or XML would also work). However, one requirement is to have the configuration showing the rule base with IPs ONLY (no ...
0
votes
1answer
28 views

Why doesn't this array formula work when cell reference contains a formual?

I have created an array formula (first formula below) to return the nth value in Data!B:B based on the date value in B4. The formulas appear to work when I have the date in B4 but if I use the second ...
1
vote
1answer
29 views

Excel VBA format footer that contains calculated value

I have a macro for my footer that uses the RIGHT and LEN function to pull strings from various cells within the worksheet. I've tested on various sheets and this works. ...
1
vote
1answer
49 views

Excel: delete row if empty cell condition is true across multiple columns

I have a data set in Excel that i need to filter out rows where no data exists (i.e.- empty cell). It isn't as easy as deleting a row that has an empty cell in one column but rather if there are empty ...
0
votes
0answers
20 views

Get original data source of pivottable

I have been sent a workbook containing a pivot table. The connection/source data used is an external database. I am aware that double clicking on a row will drill-down into the data, but I wish to ...
0
votes
1answer
32 views

Excel 2010 - VLookup -

I have two identities associated with one unique value in the table. I need to pull both the values in another sheet using vlookup - is that possible. Here is the example: Id Owner Name A1 Owner 1 ...
0
votes
0answers
21 views

Excel no longer auto update my calculation?

My excel sheets does not auto update my formulas. It did up to a point and now it no longer do. Just checked the settings under file and it is set to auto? Can some please help. Sheet to big to redo. ...
0
votes
0answers
9 views

How to I auto-refresh an Excel auto-filter when data is changed … On a mac

this question is a variation on a previous question posted here How to I auto-refresh an Excel auto-filter when data is changed? I implemented this solution and it works fine. But on a mac this ...
-1
votes
0answers
17 views

Sort and Merge Column B cells based on Column A values

Link to sample data: https://www.dropbox.com/s/rsyupyayfea8trs/Untitled.png?dl=0 I want to merge cells in column B if the corresponding cell in column A is equal. Also duplicate values in column B ...
0
votes
1answer
39 views

Format range that is dynamically based on other cell values

Take the following excel spreadsheet into consideration: I would like to format the cells in row1:2 according to the values in cells A4:B7. If I change the values, the cells in row1:2 should be ...
0
votes
1answer
68 views

How do I copy multiple rows to another sheet based on selection with checkboxes in Excel?

This is a screen clip of 2 sheets in Excel 2013. What I am trying to do is that if the checkbox corresponding with the row is checked, the text in the row shows up in the second sheet. There will ...