**1**

vote

**0**answers

20 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

23 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

64 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

36 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

31 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

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

**0**

votes

**0**answers

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

**-1**

votes

**0**answers

33 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

17 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

22 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

20 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

37 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

58 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

31 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

18 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

39 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

40 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

35 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

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

**0**

votes

**0**answers

15 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

29 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

21 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

33 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

38 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

27 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

24 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

16 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

26 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

19 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

40 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

16 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

14 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

26 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

29 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

19 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

8 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

25 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

38 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

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

**-1**

votes

**1**answer

23 views

### Excel formula: identifying highest weights

I need some help with the following assignment:
Task:
In the product Weight tab, you can see each product is weighted with a value per customer. Please create a Product Code for each customer based ...

**0**

votes

**2**answers

19 views

### Delete previous word in Excel

In almost any other application, Ctrl+Backspace deletes the previous word when editing text. In Excel 2013, it jumps the view to the active cell.
Is there an alternate shortcut for "delete previous ...

**1**

vote

**2**answers

144 views

### Excel: How to Superimpose 2 Stacked Column Charts

I have two stacked column charts (with no gaps between the columns) that have identical X- and Y-axes with same intervals. One graph is displayed in red, while the other graph is displayed in blue. ...

**0**

votes

**1**answer

24 views

### IN EXCEL, how do you add 2 columns then blank one of the columns without effecting the balance?

inventory # EX col A -10
B 25 currently
Question: If col A changes next month to -5, how can you blank out A-10, replace it with A-5, without effecting B.
A - ...

**0**

votes

**1**answer

14 views

### Excel column entries modification

I have a big Excel file containing a column where I have entries of the type
A3F44
and I would like to transform them into
A3F4 - 4
in order to match them with the entries in another file. ...

**0**

votes

**2**answers

51 views

### Adding together values from multiple spreadsheets (VBA)

In my Excel workbook, I have three separate spreadsheets. The spreadsheets are identical in format and represent count values for different categories (passenger cars, trucks, etc.). I need to combine ...

**0**

votes

**1**answer

25 views

### Using VLOOKUP in an IF Statement

Is it possible to use VLOOKUP in an if statement so that if VLOOKUP returns a certain value some action should be taken? I tried:
=IF(VLOOKUP(A2,G$4:$H$147,0)<>0,1,0)
and
...

**0**

votes

**1**answer

22 views

### Excel: How to find a range, from a list of ranges, that a value is in?

I hope someone can answer my question!
I have lots of values and need to know which ones lie within a list of ranges and if so which range do they lie in.
For example: worksheet 1 contains my ...

**0**

votes

**1**answer

96 views

### Insert text to the beginning of every Cell in a Column

I'm trying to find a way to insert text in to every Cell in a specific Column.
e.g. Column C has 50 rows: I need to insert 0049 to the beginning of every Cell.
I didn't had any luck finding/creating ...