**1**

vote

**1**answer

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

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

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

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

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

**5**answers

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

**1**answer

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

**1**answer

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

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

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

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

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

**1**answer

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

**1**answer

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

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

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

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

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

**2**answers

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

**1**answer

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

**1**answer

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

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

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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