**1**

vote

**2**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**5**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

47 views

**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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