**0**

votes

**1**answer

7 views

### Excel: Subtotals by year value

I have a table in Excel-2013 containing some data similar to this:
Year Month Electric Gas Water Monthly Totals
2012 Feb 115.49 40.15 82.13 202.70
2012 Mar ...

**0**

votes

**1**answer

13 views

### Excel 2013 Averageifs

I want to calculate the average of time in a column of cells if the time falls within a range in another cell.
E.g. If a patient comes in between say 6 and 8 pm I want to average data in another ...

**2**

votes

**0**answers

9 views

### In Excel, Can I have two rows of (worksheet) tabs for my workbook?

I'm using Excel (2013). I have a workbook with numerous different worksheets, and would like to have them take up two rows of worksheet tabs rather than just one. Can I achieve this somehow? I can't ...

**0**

votes

**0**answers

9 views

### New items in drop down validation menu aren't showing in Excel 2010

In Excel version 14.4.2, I have a drop down validation menu and I have added more cells with new menu items.
However, these new items are not showing on the drop down menu on all the cells of the ...

**0**

votes

**1**answer

12 views

### How to join neighbor cells in Excel

I have some data which I recorded in a bad way, see the picture :
Now can I format this into something like this :
Error 1 Error 2
(3.2 ± 1.97) E-04 (3.7 ± 1.3) E-03
(2.2 ± ...

**0**

votes

**1**answer

11 views

### Chart not showing all data

I have created a very simple spreadsheet with data by half an hour for every day from Mon - Fri.
I have then created a line chart and in the legend every day is shown, however the data for Monday is ...

**0**

votes

**2**answers

14 views

### Excel Formating - How do I compare 2 cells and highlight one of them based on the date in 1 Col being further out then the date in the other?

I have a spreadsheet tracking multiple dates for about 150 people. I am having a problem however getting dates in Col I to highlight if they are going to be past the date in Col P.
I want Col I Row ...

**1**

vote

**0**answers

9 views

### When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.?

When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.??? I need to convert 16.329.932 back to 1.6329932. the table has a lot of values and all have changed ...

**1**

vote

**0**answers

22 views

### How to recover some missing data in Excel?

I have two versions of an Excel file, one from before I did a lot of work on it and one from after. The after-version, despite a lot of productive work, also includes the results of a catastrophic ...

**2**

votes

**2**answers

15 views

### How do I show only the print area in Excel and grey out the rest?

I'm trying to replicate an Excel spreadsheet that someone sent me and I can't figure out how. The print area is set, and all cells outside the print area are greyed out. The cells aren't simply ...

**1**

vote

**2**answers

21 views

### How to get VLOOKUP to return the *last* match?

I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be ...

**0**

votes

**1**answer

25 views

### sumif(s), sumproduct for many to many relationship

I am looking for a formula/function that will allow me to essentially SUMIF(s) across a BOM. I know my part to FG relationship (Part, FG) and I know how many FG's I need(FG, Qty).
How can I ...

**1**

vote

**1**answer

28 views

### How to plot complex data as a radar chart in MS Excel?

I have some data from an experiment (which I did not design) that I'm supposed to analyze. After looking through the possible options for displaying the data to visually analyze, I believe that a ...

**-1**

votes

**0**answers

10 views

### copy mixed font colors Excel

I have an Excel Document.
1 cell font colors are mixed. For example i have written in one cell
< value > < struct > < member > < name> testName1 < / name > < value > 3 < / value ...

**0**

votes

**0**answers

10 views

### Is the Excel “Last Modified” time adjusted to my timezone?

I'm looking at a Last Modified time stamp in an Excel Workbook:
I got the spreadsheet from China, and I'm sitting in Denmark. These two countries are in two different time zones, and I would thus ...

**0**

votes

**0**answers

9 views

### Using Query Function in Google Spreadsheet where {data, query, [headers]} is determined in another cell

For example in cell T2 contains the following text generated with the =CONCATENATE function
DW004!$A$11:$H, "select H where (C contains """&$E2&""")", 0
This was created with the format
...

**1**

vote

**0**answers

10 views

### Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone.
Form example:
09:00 EST 06:00 PST
Is there some sort of custom format ...

**0**

votes

**0**answers

20 views

### Excel value of the digit or alphanumeric formula

How to convert a price or value of the digit which is taken as a formula to an alphanumeric?
Example :p o l i c e m a n w x y
1 2 3 4 5 6 7 8 9 10 ...

**0**

votes

**0**answers

15 views

### Make an Excel Graph Axis Show Two Time Zones

I have an Excel graph that displays the time of day in 24 hour HH:MM format. I need to also show the time with an offset for another timezone. How can I do this? I've attempted to use a custom ...

**0**

votes

**2**answers

30 views

### Excel - take two csv files and map them

I have two csv files. 1 has a list of emails, another has a longer list of emails with first names, last names, address, etc. What I am looking to do is take both of these files and map the emails ...

**1**

vote

**1**answer

42 views

### Excel: Different background colors on condition

The problem
I have a Excel sheet that contains a status column.
Number Status Name
-------------------------------------
1 not implemented feature 1
2 completed ...

**1**

vote

**1**answer

29 views

### How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100).
In cell G2 is criteria from column A.
With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...

**0**

votes

**1**answer

14 views

### Error outputting a string to cell

I am using a vba macro to automate part of an excel spreadsheet. The following line keeps giving me a runtime error 1004# application or object defined error
Sheets("Material").Last.Offset(0, ...

**0**

votes

**2**answers

34 views

### Pulling out data from a spreadsheet

I need to add information of clients who have visited the office, which department, who they were referred by, who they were referred to etc. I have linked a screenshot of what I have currently made ...

**1**

vote

**1**answer

26 views

### Excel custom auto-complete

I have a long list in a sheet in my Excel file:
Number Value
123 Text 123
127 Another text
131 Yet another text
... ...
On another sheet, I need to input those numbers. But as ...

**0**

votes

**2**answers

28 views

### How to perform sql query on sheets of excel

I have two tables in excel(sheets) . One has 10,000 entries , another has 1000 entries . Both of them have account number column in common . I want to select only those row in 10,000 entries which ...

**0**

votes

**0**answers

7 views

### How do I change the EOL character when importing a CSV file into Open Office Calc?

I've got a CSV file that has enclosed newline (\n and \r, mixed) characters in its data. Because the consumer of that file is not able to handle that correctly (out of my control) we decided to use ...

**-1**

votes

**0**answers

39 views

### EXCEL: How do i work out how many bike riders/skateboarders where male/female? [on hold]

I have four columns in an excel document that can be grouped into two sections; one showing whether survey respondents were skateboarders or bike riders and the other showing whether they were male or ...

**0**

votes

**0**answers

14 views

### MS Excel: Send Data from PowerView to PowerPivot

I have an Excel workbook with two sheets: a PowerView sheet and a PowerPivot sheet. They both show the same data; the PowerView sheet shows data at a high level, and the PowerPivot allows users to ...

**1**

vote

**2**answers

17 views

### Apply VLOOKUP to multiple sheets and ignore blanks

I would like to do a VLOOKUP on multiple sheets (for which I am able to define a strict priority order) but where I want to ignore the answer when it is a blank. I have found this answer:
Apply ...

**0**

votes

**1**answer

15 views

### Excel Table Row lookup

I need help in populating cell drop down, and table value lookup.
Sample data in a worksheet. I have created a table and given it a name.
Sample Data (Table Name: Products):
Category Product ...

**2**

votes

**1**answer

28 views

### Week of the month given week of the year

How would someone go about finding what week of the month a given week is knowing only what week of the year it is? I was going to try something like MOD(cell,4), but I know this will only yield an ...

**0**

votes

**1**answer

19 views

### How to automatically delete rows that contain certain numbers in the ID column

I have a column of numbers in another workbook and I would like to use that set of numbers to delete rows in the main workbook. I will give an simplified example of what I'm talking about below. My ...

**0**

votes

**2**answers

23 views

### VBA Excel: How to assign .txt file content to a string type variable?

I made a little sub in excel that sends an email according to the parameters you enter:
Sub Mail_LSP(mailsubject As String, consignee As String, coalcopy As String, mailbody As String)
Dim mlook As ...

**1**

vote

**1**answer

32 views

### Windows 7 Excel 2010 annoying personal.xlsb message

I'm running Windows 7. Each time I run Excel I get this message popping up.
Excel cannot open the file '~$PERSONAL.XSLB' because the file format or file extension is not valid. Verify that the ...

**1**

vote

**1**answer

19 views

### Populate cell from table 1 from an auto-filled cell of table 2 with conditions

In Excel 2010, TAB1 and TAB2 are in the same worksheet.
I want to populate Column D of TAB1 of an auto-filled Column E of TAB2 based on the values on Column C of TAB2.
TAB1 looks like this:
COLUMN ...

**1**

vote

**1**answer

23 views

### Unwanted space in URLS in Excel 2010

I have a list of 23000 URLs in an Excel sheet but these appear to have extra spaces in, therefore invalidating the urls.
I've tried a find and replace and excel doesn't recognise that there is an ...

**1**

vote

**1**answer

13 views

### Excel formula for returning a specific weekday of a collection based on the cell referenced

I would like to use a formula to return the first day of a week for a date. I would also like Saturday to be considered as the 'first day' of a week in this formula.
For example, B2 is 03/03/2014. B3 ...

**1**

vote

**1**answer

19 views

### How do I allocate different text cells in a row a number and then sum total that row

I have a spreadsheet setup to monitor absence in the office. The columns are the days of the month 1 - 31 and rows are the month/employees
Mon Tue Wed Thu Fri
January 1 2 3 4
...

**0**

votes

**1**answer

16 views

### Drag down to change row letter, not number

Sorry for the confusing title, but I don't know how else to explain this. I'm trying to drag down this cell with the following formula:
=COUNT(Tab1!B3:B32,"<>0")
What I want is for the ...

**0**

votes

**1**answer

31 views

### Lookup with multiple criteria and priority

I am working with different excel files which contain a lot of data from different people. I would like to do a lookup (I know how to use the LOOKUP function) but based on multiple criteria. Let me ...

**0**

votes

**1**answer

13 views

### Deleting rows that contain a keyword in the column

I have an excel file that has a id as one of the columns, each id has multiple entries and follow a set of survey questions. I need to delete all of the rows that have that keyword (which is in a ...

**0**

votes

**0**answers

10 views

### How to link quickly to various pdf files in Excel

I have an excel database with hundreds of products. Each products is assigned a specific security PDF sheet in a folder.
Is there a way to optimize my linking routine?
My way:
Click insert - link - ...

**0**

votes

**1**answer

13 views

### Using multiple data sources in a scatter graph

I have a script that runs something in a loop and writes its duration into a .csv file on a share. The file looks basically like this:
"timestamp","duration","ComputerName"
"7/8/2014 2:56:03 ...

**0**

votes

**1**answer

23 views

### Microsoft Excel Custom Label Overlay on Line Graph

I have 2 tables identical.
One records the progression of projects as a percentage over dates until completion.
The other is a replica table but records the daily status of the projects on the ...

**0**

votes

**0**answers

14 views

### Creating a quadrant graph with gradiented percentages in Excel

I'm trying to create a five-sectioned graph/diagram in the shape of a tongue (with front, back, left, right, middle) sections, in which each section represents a percentage, e.g.
Front: 0.3
Back: 0.1
...

**0**

votes

**0**answers

3 views

### Excel 2013 - ActiveX ComboBox not accepting defined name

I have a worksheet that I'm reverse engineering to use for a project we have that is similiar.
It contains ActiveX ComboBoxes that use a defined name, ComboData, to list the data within.
I have ...

**0**

votes

**1**answer

23 views

### Excel Formula Issue Countif to Sumproduct

Having a nightmare at the moment with some formula's I've been asked to 'fix'. It would seem the users expected them to work with closed source spreadsheets but they don't. So they end up having to ...

**0**

votes

**2**answers

31 views

### Can I password protect Work Sheets in Excel

Can I password protect an Excel 2010 worksheet.
I have an Excel file that contain 10 sheets according to locations. This file contains some MIS reports. The file is mailed to all locations daily and ...

**-1**

votes

**0**answers

21 views

### comparing 2 columns in excel and return the same result in a group

hi m new in excel function,
i have a problem like this. i have 2 lists of data
DATA I
NAME SCORE
----- -----
ANA 10
BUDI 20
TINA 30
DATA II
NAME SCORE
----- ...