**0**

votes

**0**answers

3 views

### Multiple Label Filters in a pivot table

Is it possible to have multiple label filters in a pivot table? I see that I can use 'contains' which could work but I am having issue with the syntax if this is possible.
I'm thinking something like ...

**0**

votes

**0**answers

33 views

### IF Statement with VLOOKUP

I'm trying to get a value from the ADD Taxable which is column 10 in the Check (sheet). I only want the value from column 10 if the Earn Type on Timecard (Sheet) has BONUS in it. I'm using the TC Ref ...

**0**

votes

**1**answer

17 views

### Excel carrying information between tabs

My excel spreadsheet carried information from one tab to another. When I add information on one tab the same information appears on other pages. I opened it yesterday and some dates were changed to ...

**1**

vote

**1**answer

19 views

### Counting the Cells in a Named Range without VBA

I have a disjoint set of 9 cells: A1,B3,C5,D7,E11,F13,G17,H19,I23. I have assigned a Name to these cells: MyPicksI have a simple formula to pick the value in one of these cells at random:
...

**0**

votes

**1**answer

10 views

### How to autocomplete columns when going down one row in Excel 2013?

In my excel sheet I have values that could be automatically filled upon going down to an empty row.
My excel sheet has this structure:
If I go from Row 3 down to Row 4 i would have to insert the ...

**1**

vote

**1**answer

16 views

### Make short key for searching filter in Excel 2010

Can one help me to make a short key for the following procedure in Excel 2010 (ALT+DownArrow then E) . this used to go directly to search box in filter excel like shown in photo
and if some know ...

**0**

votes

**1**answer

16 views

### Count values in column B based on criteria in column D in Google Spreadsheet

I would like to count all the values in a column (Column B in this case) based on a criteria measured against another column (Column D) in the same row. So, going down the Column B, I should count the ...

**0**

votes

**0**answers

15 views

### Setting Excel 2013 default theme

I want to change the default theme for Excel, so that when I open a new blank document, the right fonts and colors are in place. I've come so far as to make a theme and set it as default, but for some ...

**0**

votes

**1**answer

10 views

### Setup powerpivot on a server?

I have a client that uses PowerPivot. They save the Power Pivot inside Excel files and have pivottable reports in the same Excel files.
They feel that this puts to much strain on their computers. ...

**0**

votes

**0**answers

10 views

### Excel documents are opening as maximized

I reinstalled win8.1, Excel 2010 and now, every time I open a document, my workspace getting maximized.
For example: When I open one worksheet... even if it appears in small window on big workspace, ...

**0**

votes

**1**answer

28 views

### Excel 2013 VBA programming

I'll start off my saying I'm trying to save time for a family member who is doing this program manually.
Sheet 1
Column A is a start date
Column B is a projected start date
Column E is a Task Name.
...

**0**

votes

**0**answers

16 views

### Powerpoint Excel Slideshow

Wondering if anyone has an idea of how to do this. A client of mine has a slideshow setup, on a continuously running screen, pulling in an excel sheet and updating it on every refresh to manage job ...

**0**

votes

**1**answer

33 views

### Pasting mm:ss into excel - gets mistakenly formatted as hh:mm [duplicate]

If I paste a dataset including times in mm:ss format into excel, how can I prevent it from interpreting them as hh:mm? Changing the number format before or after pasting doesn't help, Excel still ...

**0**

votes

**0**answers

18 views

### Excel: Create a Collapsible Master-Detail View From Another Sheet?

I'm designing an excel template for importing data (into another DBMS).
The problem is, the data will be separated (normalized) into several tables in my DBMS (master-detail model).
Let's say I have ...

**-1**

votes

**1**answer

25 views

### Can I split a spreadsheet into multiple files based on a Row in Excel 2013?

I have a spreadsheet in excel 2013 which have multiple column and rows. I need to send some columns to different people separate files. Please anyone can help me in this. Please try to use macros, or ...

**0**

votes

**0**answers

18 views

### create an excel sheet to schedule employee annual planner

I want to create an excel sheet to schedule employee annual planner.
If anyone submits leave application, while entering i need to find anyone applied for these date range. And also compared it with ...

**0**

votes

**0**answers

15 views

### How to paste the data only in blank cells in ms excel from some other program using autohotkey?

Myvar:=5
F1::
xl:=comobjactive("excel.application")
xl.range("i"myvar).select()
myvar++
Send, {CTRLDOWN}v{CTRLUP}
return
In the above script, when I press F1 key it selects I5 cell automatically and ...

**-5**

votes

**0**answers

28 views

### Excel: Can anybody help me to take-off quantities of loose furniture in the best and fastest way? [on hold]

Can anybody help me to take-off quantities of loose furniture in the best and fastest way?
Information as follow:
There are about 2000 different types of rooms and 300 sets of different furniture
...

**0**

votes

**0**answers

11 views

### Changing cell style groups

I was sent here from stakoverflow
When I create a new cell style in Excel, it goes in a group called Custom. The standard groups include Good, Bad and Normal, Data and Model, Title and Headings, and ...

**1**

vote

**1**answer

26 views

### Round up or down to nearest multiple of .05 in Excel

Example, I have 221.52, 195.97, and 138.88. Now I want it to automatically round up or round down to the nearest multiple of .05, producing 221.50, 195.95, and 138.90. Is there a formula for this?

**0**

votes

**0**answers

21 views

### Extracting HTML from Excel to enter in MySQL/Wordpress site

I have a WordPress site and an Excel document. I'm not familiar with Excel formulas so forgive me.
The document contains a lot of names, email addresses and telephone numbers. I want to create a ...

**0**

votes

**2**answers

38 views

### Excel Graph with 2 X-Axis Non-Linear Mapping

I have the following problem someone might be able to help with.
I have two risk scales, one from 1 to 11 (old) and one from 1 to 21 (new), where the mapping is non-linear, i.e. old scale->new scale ...

**0**

votes

**1**answer

13 views

### Excel Data Extraction Formula

I am trying to run a report to evaluate the downtime of devices in a network. The OpManagement report doesn't have any customization available for output reporting. So I am looking for a way to ...

**1**

vote

**1**answer

11 views

### Summing multiple cells that match row AND column criteria?

I've been given a file with 2 years worth of dates as column headers and sales info below. There's also a column that contains Year data. I'm trying to sort by both Year and Day of the Week. I'm ...

**0**

votes

**0**answers

29 views

### Pairing Numbers in Excel

I have a list of congressman (and some of them repeat) and I’m looking for something that will fill in the matching distract number in the corresponding cell, so I can eliminate the risk of the human ...

**0**

votes

**0**answers

11 views

### Access 2013 How to prevent from saving a record

I had created a form in access 2013 to add records to a table but I'd noticed that if I close the form without saving the record access still saves it to the table anyway. I would like to know how to ...

**2**

votes

**1**answer

21 views

### Excel pivot table: Show values instead of summaries

I have a table of data like this:
ID |Name |Brand |Model |License
------------------------------------
1 |Foo |KOM |830 AC |A
1 |Foo |KOM |930 E |B
1 |Foo |CAT |980 H ...

**0**

votes

**2**answers

25 views

### Excel Index/Match Sum

I have 2 worksheets in Excel. Both have data from a 2 different databases. The first tab has part numbers and costs (could be different day to day), the second has how many times that part number ...

**-1**

votes

**0**answers

10 views

### Macro - Creates individual workbook based on template on sheet2 and data on sheet2 [on hold]

Option Explicit
Sub CreateBooks()
Dim rCl As Range, rRng As Range
Set rRng = Sheet1.Range("A1").CurrentRegion.Offset(1)
Application.ScreenUpdating = False
For Each rCl In ...

**0**

votes

**1**answer

30 views

### Excel: what makes .xlsx files use less space than .xls files?

I have some xls files without around 12 tabs containing data, links to other excel files, some data validation, and some conditional formatting. Saved as xls, they use around 1.2-1.5 mb each, but if ...

**-1**

votes

**2**answers

54 views

### If one number then a different number

I have two columns of numbers on a data page, over 500 pairs. And I need a formula for the working page that will insert the second number in “column B” if the first number is in “column A”. So if my ...

**0**

votes

**1**answer

23 views

### Schedule; want to check if everyone is present [on hold]

We're making a schedule in Google Docs / Excel
We want to be sure we've got everyone in the schedule....
So we make an Excel per day we're everyone should be present in a day (row 6/7). I know I ...

**0**

votes

**1**answer

20 views

### Run a Mail Merge using a Database from Excel [on hold]

I have an Excel database that lists all our employees and the training courses they have completed. Each course is listed on a separate line with the employee name.
I would like to run a mail merge ...

**0**

votes

**1**answer

19 views

### How to filter common values of two columns with advanced filter?

I have one column containing some common values that are in another column. I want to filter values from one column that are present in other column but without using VLOOKUP. How can i do it using ...

**0**

votes

**0**answers

24 views

### How do I sum the last 4 cells in a column that have a value greater than 0 & contain only numbers in excel?

I have created a spreadsheet for working out the pay of our employees. The data starts in Row 14. Col A contains that week's pay date eg. 24/3/15 etc. Col B has the total hours the employee has worked ...

**1**

vote

**1**answer

21 views

### Different colored columns in excel

I have data such as this:
1 | 2 | Y
2 | 4 | N
3 | 3 | N
4 | 2 | Y
...
I need a bar graph that will display column 1 as the x-axis labels with column 2 as the y values. The color of each bar will be ...

**-1**

votes

**2**answers

39 views

### Excel formula for average daily profit

I have a table that has just two columns, Date and Profit:
Date Profit
24 - March 25.00
24 - March 19.85
25 - March 5.25
26 - March 6.36
26 - March 10.18
26 - ...

**0**

votes

**3**answers

26 views

### Excel macro: Last non-empty cell in a column

This is a followup question to this one.
The following formula can be used to find the value of the last non-empty cell in a column, in Microsoft Excel:
=LOOKUP(2,1/(A:A<>""),A:A)
My ...

**-2**

votes

**1**answer

15 views

### How to transfer spreadsheet to downsized spreadsheet [on hold]

Can I copy an excel spreadsheet with 20 columns and paste into a template using only 8 of those columns with the column sizes slightly changed?

**0**

votes

**1**answer

15 views

### How do I prompt a user with file “Save As” dialog using a macro?

I created an Excel macro to replace data from "Quote" to "Invoice", but after running the macro, I wish for the macro to continue to run and stop at: "Save As..." mode so that the user can provide a ...

**0**

votes

**1**answer

29 views

### how to CONCATENATE array text?

Let the cell A1 has "abccba"
Now I write a formula in the cell B1 =RIGHT(LEFT(A1,ROW(INDIRECT("1:"&LEN(A1))))) it gives value "a" or array string as{"a";"b";"c";"c";"b";"a"}
Now when I concatenate ...

**0**

votes

**1**answer

21 views

### Excel 2013, Vlookup - accessing different sheets.within a workbook

I Have a cell (lets say its A1) that specifies (from a drop-down list) a Sheet Name (AA BB CC DD etc)
I want to pass that sheet name to a VLOOKUP Formula which would (if life were simple) be SOMETHING ...

**0**

votes

**0**answers

16 views

### Hyperlink to file in TextMate

I use TextMate to edit LaTeX documents. Let's say I have the file foo.xlsx on my Desktop. In my .tex file how can I add a hyperlink to foo.xlsx, so that when I click on the link, the file is opened ...

**1**

vote

**0**answers

27 views

### Office 2013 on Windows 8.1 gives out of memory error when opening files

We have the same error that has been posted here:
Problems opening Excel attachments from Outlook
Namely, when a user opens a file from the internet, the internal network or an outlook attachment ...

**0**

votes

**1**answer

44 views

### excel 2010 Vba, looping through named ranges, Run-time error '1004':

I am assigning the same Macro to several OptionButtons.
I try to determine in which named Range the cklicked OButton is located.
So I get the Cell of the Button and loop through all named Ranges in my ...

**0**

votes

**1**answer

34 views

### Excel Daily Average Profit

I have a table that looks like this..Just two column..Date and Profit:
Date--------------Profit
24 - March------25.00
24 - March------19.85
25 - March------5.25
26 - March------6.36
26 - ...

**1**

vote

**2**answers

39 views

### Microsoft Excel - comparing values of multiple columns against values of multiple other columns

I have a spreadsheet containing names.
I have 5 columns of unique names, let's call the headers:
Name A
Name B
Name C
Name D
Name E
I also have 10 columns of other names (not necessarily unique), ...

**0**

votes

**2**answers

27 views

### Finding a value in one colunm that matches another column then putting that value in a third column (excel 2010)

All of the values are texts since the are usernames that are from two different systems.
so one column has:
Column A Column B
smit19108 Fred99015
Fred99015 Smit1908
...

**1**

vote

**1**answer

24 views

### How can I assign Excel keyboard shortcuts for macros that use keys other than Ctrl + {alpha character}

I would like to assign keyboard shortcuts to Excel macros that use keys other than the standard Ctrl + {alpha character}. Based on this post it sounds like it is possible but I am not sure how:
...

**1**

vote

**1**answer

45 views

### Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...