**0**

votes

**0**answers

14 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

18 views

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

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 after pasting doesn't help, Excel still sees them as ...

**0**

votes

**0**answers

13 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

18 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

13 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

11 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

24 views

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

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

10 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

23 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

19 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

34 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

10 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

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

**1**

vote

**1**answer

17 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

**1**answer

19 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

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

28 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

52 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

18 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

23 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

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

**0**

votes

**2**answers

32 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

25 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

28 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

24 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

42 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

25 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

38 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

26 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

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

**0**

votes

**0**answers

32 views

### setting upper and lower limit excel histogram

I am using the built-in data analysis tool to create a histogram for a column of numerical data in Excel. I'm doing the same thing for many different files, and they all need to have the same scale ...

**0**

votes

**0**answers

25 views

### Multiple Values in one cell needing separate row in Pivot Table

I am looking for a solution on how to have a separate row in a pivot table for 2, 3 even 4 values in one cell.
Example - Columns are as follows: Date, Job Name, $ Value, Distributor Quoted, ...

**2**

votes

**1**answer

30 views

### How to unselect Excel Cell using Keyboard Shortcut?

One can select multiple Excel cells (either contiguously or not) using the keyboard shortcut Ctrl+Click.
How do you deselect one or more of these previously-selected cells?

**1**

vote

**2**answers

47 views

### Excel: Sum a column of text excluding duplicates in another column of numbers

I am trying to figure out a formula. I need to know how many times a certain issue happens based on case numbers. Meaning there are multiple entries under a specific case number for that subject, but ...

**0**

votes

**0**answers

16 views

### Import image from MS SQL Database into Excel

I have a MS SQL Database where images are stored as byte[].
Is it possible to import these byte[] into Excel and convert them back into images?
I already have a connection to the database in my Excel ...

**1**

vote

**0**answers

25 views

### Cell Formatting, 0.00 where blank value

I have some cells that are formatted as hours and minutes i.e. [h]:mm.
If no value exists in a cell I want the cell to show 0:00 without having to manually type.
It needs to be user friendly, so if ...

**0**

votes

**1**answer

14 views

### Return transposed list of all strings in a row in Excel

In my Excel (for Mac 2011) sheet, the range B2:2 contains mostly empty cells, but some cells contain strings. I would like to print these strings into a transposed list beginning at A12. This list ...

**2**

votes

**1**answer

26 views

### Excel Formula - returning data

I have a spreadsheet that has four columns of data.
I want column number four (D) to display the value of column three (C) IF the number next to it in column two (B) matches ANY number in column one ...

**1**

vote

**1**answer

28 views

### Show increase in trendline by using Excel vba

I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...

**0**

votes

**1**answer

27 views

### Excel converts datetime to other format where days are low enough to be months

I live in europe and our datetime format is usually dd/MM/yyy
I have an excel spreadsheet where I have ALOT of dates
But for reasons I do not know, Excel converts where (dd < 12) to mm/dd/yyyy - ...

**0**

votes

**1**answer

17 views

### run macros assigned to many excel sheets of a workbook, with one click

I have one workbook with 8 worksheets.
I have a macro assigned to each worksheet.
I want to run all 8 macros from one worksheet in one click(by clicking one button, to run all 8 macros).
How can ...