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
2answers
22 views

Excel: Format rows in sheet B based on value in sheet A

How do I shade an entire row on tab 2 when an "X" is placed in column "A" of the same row in tab 1?
-2
votes
2answers
28 views

Not able to open excel file

My excel file(shortcut) is saved with file extension .lnk and I m not able to open it so I want to know how to open it or how to remove .lnk extension.
0
votes
2answers
26 views

Excel Equation: How to skip cell value if row header contains certain text

So I have a workbook for tracking my inventory in real time. It's a really bad bandaid for a problem I cannot have addressed at the moment, so bare with me. The issue is, I want to have my inventory ...
0
votes
0answers
25 views

Formatting of dates in cell using Excel to show result as numbers

I am working with calculating the difference in years, months and days between 2 dates. My results are showing as eg. 32 years, 9 months, 3 days. How do I format the cell to show a result 32 9 3? I ...
0
votes
1answer
39 views

Search cells in excel [closed]

I have an Excel workbook with multiple worksheets. I'm using Excel 2013. First worksheet contains the list of items. The other worksheets contains the same items but in scattered fashion (with lot of ...
-1
votes
2answers
36 views

Excel addins for office 2013 [closed]

We have on hand some custom-made Excel add-ins that were designed to work with Excel 2003. We would like to upgrade to Office 2013, but the add-ins do not function properly in the new version. Is it ...
1
vote
2answers
46 views

How to avoid opening a workbook referenced in vlookup between 3 workbooks

Situation: I have three excel workbooks of which Workbook1 and Workbook2 contain my data. In Workbook3 there is a VLOOKUP which references to the data in Workbook1 and Workbook2. All of that works ...
-1
votes
0answers
19 views

Automatically transfer of conditional data between two sheets [on hold]

I got two sheets on file. First sheet is to enter data and assign a machine to it through a list. Simple data entry on first sheet. On second sheet, how I can configure it in such a way that whatever ...
0
votes
1answer
27 views

How to check if a date is within a given range in Microsoft excel [closed]

I have a data sheet with 6 columns which shows location, class, code, plan, start date, and end date. These dates show the block dates that needed to be illustrated in another sheet. I need a formula ...
0
votes
0answers
11 views

how to use =TEXTREVERSE() of morefunc add-in in Excel 2013?

I recently installed morefunc add-in in Excel 2013 but I don't know how to use it. I saw tutorial to use it in Excel 2003/2007 but I can't find the way to use morefunc in Excel 2013. how to use ...
0
votes
2answers
31 views

Hide rows based on the value of another cell

First, I've tried these threads, to no avail (1, 2, and others which I am prohibited to mention since my rank doesn't allow for more than two links). I am almost certain I'm just missing some simple ...
1
vote
1answer
26 views

How do I change color every time my length is bigger then 5 character in VBA

How can turn my color into green when my length exceed more then 5 characters. I keep getting "object doesn't support this property" error Sub deme() Dim lastrow As Long Dim a As ...
0
votes
2answers
13 views

Excluding rows in excel SUM based on different cell values

I have a SUM (A:A) cell value that calculates the sum of all cells in a certain column. However, I want to create another cell that has the sum of all cells in the same column, but exclude those cells ...
0
votes
0answers
32 views

Why is VLOOKUP returning wrong cells as data is refreshed?

I am creating a spread sheet which works out my material requirements based on future order forecast. I have live data in the workbook which represents the material on stock and they're location. I ...
0
votes
1answer
22 views

Lookup based on two criteria, one a number and one a range

I have two lists, one with ID's and percentages based on various ranges, and the other with ID's and totals. I need to look up the percentage in the first spreadsheet based on the ID and total in the ...
1
vote
1answer
21 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
22 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
40 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
198 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
21 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
32 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
28 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
60 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
17 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
73 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
28 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
40 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
45 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
16 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
40 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
35 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: ...