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

20 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

29 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

37 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

23 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

24 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

17 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

37 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

15 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

21 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

28 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

17 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

6 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

37 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

22 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

17 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

126 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

47 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

24 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

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

**-3**

votes

**0**answers

25 views

### How can I get Excel to auto-fill a column based on text entered in another column? [closed]

I am looking to Format a column of text in excel for example
A
ABC123
123DGF
ABC124
NMO445
B
Corp
Acct
Corp
HR
I want excel to notice the text entered in column A and then ...

**1**

vote

**1**answer

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

**2**

votes

**0**answers

65 views

### Different icons for different excel files

In my work, all coding can be done in VBA only - hence, all of our tools (dbase queries, data processing, cash overviews, etc) are written as xlsm files.
At the moment, the number of different tools ...

**0**

votes

**0**answers

30 views

### Excel Floating Column Chart with Gaps

Use Excel to plot multiple start/stop events for multiple days in one bar chart with all activity for each day represented on the same line of the chart for that day (bar chart with gaps)
Desired ...

**1**

vote

**1**answer

30 views

### Excel column headers export to csv

Just wandering how I can export excel files to csv while retaining the multicolumn headers?
I realize that csv does not support this however, I'm hoping that I can have the header name duplicated for ...

**0**

votes

**1**answer

28 views

### Grouping by date and time, with certain layout

I have a list of dates, every date has several timestamps, and every time stamp has a value.
I have to rearange this data in a specific way. here's the data and below the way it should be arranged
...

**2**

votes

**1**answer

35 views

### Delete text in excel cell with certain format

How do I easily delete strings in excel cells with certain formatting.I want to get cell with formatted string deleted like the second cell
The string could be anything the only thing that define ...

**0**

votes

**1**answer

16 views

### How can I use vlookup for one value and return multiple corresponding values in excel 2013

Could someone please help me understand what formula or what I can do to enter in one value and have all the values populated based off that one value. Below is the excel sheet I have.
261 201421 ...

**1**

vote

**3**answers

35 views

### Extending a sheet with hidden/deleted last columns in Microsoft Excel

I inherited an Excel workbook from a colleague which left the company. Somehow, this colleague managed to hide or delete all columns to the right of a sheet. For instance, currently this worksheet ...

**1**

vote

**2**answers

30 views

### How to convert a Excel row to a single csv text cell (inverse of "Text to Columns)

I have a POS program that allows me to import stock items from a csv file. The problem is that it only accepts a certain csv format.
I have a Excel spreadsheet that saves my stock in different ...

**1**

vote

**1**answer

29 views

### How to extract the last 7 number values in an alphanumeric string

I need to extract the last 7 number values (not characters) from a string in an excel cell. The string contains a file name (which can be a mixture of letters,numbers and a dash) and then 7 numbers ...

**0**

votes

**1**answer

9 views

### I want a shortcut in Excel to cells I have Hyperlinked

I've built a Series of Cells which wnen concateneted = HyperLink to a remote server. Excel Wk Sheet 2010 (File name changes Daily with date function or Date User inputs)
On the same Sheet I want to ...

**0**

votes

**1**answer

21 views

### Embedded IF(OR(IF) statement

I have made a formula that basically looks for a string of text inside a cell and if it finds it puts it in another cell. I needed to check three cells so I did three separate formulas (because I'm ...

**6**

votes

**2**answers

186 views

### OpenOffice Calc: reduce file size when saving as Excel

I'm working on a spreadsheet together with another person, sending new versions forth and back by email. It contains nothing fancy. While he uses Windows I'm on Ubuntu 12.04.4 LTS. The first version ...

**1**

vote

**1**answer

25 views

### I am unable to open corrupt MS Excel file due [duplicate]

How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. ...

**0**

votes

**0**answers

23 views

### When sorting in Excel, cells with images don't follow the sort results

I have created an Excel table and in the table I am able to filter the images with no problem with each pivot table. However, whenever I try to sort the data to organize alphabetically the images will ...

**0**

votes

**1**answer

26 views

### Format text list with corresponding key into spreadsheet

I have a text file with dates arranged as such.
name1
2010-01-02 (i)
2010-05-07 (i)
2010-06-12 (i)
name2
2010-01-02 (i)
2010-05-07 (i)
2010-06-12 (i)
name3
2011-01-05 (i)
2011-05-05 (i)
2011-06-14 ...

**0**

votes

**1**answer

25 views

### What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?

I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...

**0**

votes

**1**answer

25 views

### Excel: portable formula to reference data on previous (relative) worksheet

I need to create a fairly simple Excel spreadsheet (workbook). I need 12 sheets (tabs), one for each month.
Each sheet references cells in the previous sheet. For example, the "May" sheet is ...

**0**

votes

**1**answer

16 views

### Moving content from one workbook to the another without opening it

I have excel sheet (1) in workbook A which update the DATA in designated cells when launch.
I want cells content to appear in another excel sheet (1) of workbook B in NEXT row witout opening it.
...

**0**

votes

**0**answers

16 views

### Convert COUNTIFS formula to SUM(IF) to enable external workbook references?

I need to convert the following formula to one that uses SUM(IF), as I am given a #value error when the external data source is closed.
...

**0**

votes

**2**answers

32 views

### Concatenating columns in excel

Need some help in concatenating columns 1 and 2 as seen in screenshot.
There will be further entries in column 2, perhaps 'Blue'. I would want '1 Blue' '2 Blue' '3 Blue', etc starting off from ...

**0**

votes

**0**answers

27 views

### Excel 2013: Bug when creating custom date, converts all years after 2000 to?

Data is in US date format: mm/dd/yyyy, ranging from 1991 to 2011. If I try to convert into any custom format involving date, years after 2000 are converted to either 2014 or 2000. I think I must be ...