**1**

vote

**1**answer

24 views

### Excel VLOOKUP with named range not working

I have the following VLOOKUP on a worksheet:
=VLOOKUP(D5,FilePurposes,2)&" in respect of "&C5
Where the named range FilePurposes refers to a block of two columns and three rows that look ...

**1**

vote

**2**answers

42 views

### I need help moving info from one column into another column in Excel

0071 3/4-1
0072 1.5-3
0072 1-3
0072 1.5-1
0072 1-1
Above are part numbers located in Column A and Column B of an Excel spreadsheet. I am trying to combine the columns. Basically, ...

**-1**

votes

**0**answers

30 views

### which one is the best python plugin for MS Excel? [closed]

I know there is three options available here, data nitron, excel-python, xlwings
for these aspects:
stable
functionality (Can manipulation most MS Excel object, like table,image,chart,etc)
easy to ...

**0**

votes

**1**answer

23 views

### Excel Validation Feature to Return Items from a List

I have a list of bank code and bank description in spreadsheet. i wanted to select a bank code from a list and then display the bank's description. How can i perform this ? Sorry im new with excel ...

**0**

votes

**1**answer

16 views

### Static Data Input Row for Excel Spreadsheet

I'd like a static data input row in my Excel spreadsheet. This row would allow the user to submit a row of data and press Enter or a Submit button to have the row added to either the bottom of the ...

**1**

vote

**1**answer

34 views

### Sumif & Indirect

In using the following sumif/indirect function
(=+SUMIF(INDIRECT("'"&$A$3&"'!$B$2:$B$102"),$C13,INDIRECT("'"&$A$3&"'!F2:F102"))
my columns (F:F) wont move as I drag the formula to ...

**0**

votes

**2**answers

47 views

### Removing commas from CSV file

I created an Excel .XLXS file, reformatted the columns from currency to numbers with 2 decimals and no thousands separator, then exported to a .CSV file, then to a .TXT file.
Once I did that, the ...

**0**

votes

**0**answers

22 views

### Windows 7 and excel copy & paste

I have trouble using the right mouse to drag and copy several fields in excel at one time
. I am using excel 2013.
I will start highlighting by dragging my mouse over the the fields I want to copy, ...

**1**

vote

**3**answers

24 views

### Splitting Data in Excel Based on Character Location

I have a column of data, each row containing a set of 83 characters (e.g. 010203 344345 929348238482abcde33 4566) with no particular pattern that needs to be split into blocks of different lengths ...

**0**

votes

**1**answer

17 views

### How to gray-out cells when N/A is entered

I have an Excel sheet used as an order form.
I need to know how to gray out a number of cells if an N/A is entered.
My problem is that if an N/A is entered in to cell D13, cells E13 to E15 to gray ...

**-2**

votes

**0**answers

14 views

### Excel 2007 VBA help requested for counting Yes/No

I hope someone can help me with this problem I have?
I have a text files that contain multiple columns. Two of the columns I have analyse the results of. My issue is that these two columns vary in ...

**-1**

votes

**0**answers

13 views

### Page Layout Tab Freeze [on hold]

I highlight the work sheet than click on page layout on the excel ribbon on top of the sheet.
The page layout "tab" does not want to respond.
This happens intermittent.
What is the problem and how ...

**1**

vote

**2**answers

32 views

### Increment numbers inside a text in microsoft excel 2007

I would like to drag cells downward and increases the number next to letters. It work when there is no letter for me.
For example, I want to increment the number this way
AG1
AG2
AG3
AG4
...
I ...

**2**

votes

**1**answer

21 views

### Multiple data points in a graph's labels

I'd like to build a bar graph in excel. The thing i'm having issues with is the formatting of the labels on the datapoints. I'd like the labels to pull from 2 datasets. The bar would be drawn using ...

**1**

vote

**1**answer

34 views

### Replacing similar terms with one word in Excel

I apologize in advance, because I'm not entirely sure how to word this question.
I'm maintaining financial records for a student organization, and my goal is to make a spreadsheet that is easy to ...

**1**

vote

**3**answers

37 views

### How to split and distribute columns like “A,B,C” and “X,Y,Z” into “A,X,B,Y,C,Z”?

so this seems tricky to me but i have a set of data that need to be split into alternating comlumns here is what i mean is in the example below i split column A to C E and G ect depending on how many ...

**1**

vote

**2**answers

19 views

### When I copy table data into excel, it ONLY pastes it into column A! How to fix this?

If I use the following link:
http://web.utk.edu/~dhouston/excel/exam1.pdf
to copy the table and paste it into excel, it will only paste the values into one long column in Column A (and each row has ...

**0**

votes

**1**answer

41 views

### How to combine data set to create unique combinations [duplicate]

First of all I don't have experience with Excel scripting, just basic formulas. I've seen this other question on SU but I'm not sure if that's exactly what I need or how to adapt it to my needs.
...

**0**

votes

**0**answers

14 views

### Fuzzy Lookup Add-In

I hear it is a faux pas to hijack another post in order to get help with my issue, so I'll just post a link to that post and hope for the best: Comparing Similar Text Strings in Excel
So, I'm trying ...

**-2**

votes

**0**answers

20 views

### How do I set MOUSE 4 and MOUSE 5 to do functions in Excel 2013?

I have a five button mouse and I want to assign functions for the side buttons inside excel.
Functions I have in mind are both Ribbon functions and I use Excel 2013. I've seen some tutorials online ...

**0**

votes

**0**answers

24 views

### Showing Zero Values in Pivot Table in Excel

I have an unremarkable pivot table in a completely new workbook. I tried both "For empty cells show 0" in pivot table options and "show blank values" in field settings to no avail. Is there another ...

**0**

votes

**1**answer

16 views

### In Excel for Mac 2011, how do I delete the name from a named cell?

How do I delete the name from a named cell in Excel 2011 for Mac?

**1**

vote

**2**answers

45 views

### Changing Cell Date Formats to Text Format and Retain mm/dd/yy

I need to change cell dates with a general format (mm/dd/yy) to a text format for uploading to Peoplesoft. However I must retain the mm/dd/yy. When I change the cell from general format to text format ...

**0**

votes

**1**answer

42 views

### How do I get Excel to identify a country from city list?

I have a list of data with many columns.
In one column - let's say C, there is a list of cities/places. There are multiple entries, i.e. one city pops up loads of times in a column in different ...

**-1**

votes

**0**answers

6 views

### Autopopulate a templated spreadsheet with another spreadsheet

We use Salesforce.com as our CRM and database, with regular use of reports. Naturally, we use those reports for sales and business development strategies. However, the way that we like to look and ...

**0**

votes

**2**answers

42 views

### excel vba codes user form

I have created a user form for my work book. I would like the user to navigate their way around the workbook using the button on this user form. Is there any code that I can use to limit the user by ...

**0**

votes

**1**answer

40 views

### How to Mirror cells in excel 2013 [closed]

I want to make an excel file for sales management of my company. the excel I have created has 4 sheets and every sheet is handled by different persons.
I want to dedicate the first column of these ...

**0**

votes

**1**answer

20 views

### Excel Formatting Columns to show amount NOT carried across [closed]

I have a column (D) which has an amount in it ... this amount needs to be carried across to one of 25 possible other columns (E - AB) - I want the column D to highlight until such time as the amount ...

**0**

votes

**1**answer

22 views

### Excel changing UNC paths in shared workbook

Excel documents stored on network drive, for example, \\networkdata\Excel\Shared
Data workbook.xls contains tables with data entered into.
Report.xls contains UNC paths pointing to ...

**1**

vote

**1**answer

41 views

### excel vba userform/button coding

I have created a workbook in Excel. To navigate I have inserted a userform. I have code which takes me to a spreadsheet once a button is clicked on the userform.
Now I would like a button on the ...

**-1**

votes

**2**answers

35 views

### Trying to use SEARCH function in Excel

I'm trying to do something on Excel which is a little bit over my head and was wondering if anyone out there can help:
I'm trying to search through a table (specifically one column) for several ...

**1**

vote

**1**answer

23 views

### Create an animated plot of data points from csv

I have a large CSV File containing some data points [~3MB, example data] as a series of coordinates.
I want to create an animated plot of point where the point is moving acoording to the given ...

**0**

votes

**0**answers

17 views

### Excel has quit opeing files properly on my Windows 8 computer

I installed Microsoft Office 2013 on my computer and all of it has been working great until recently. Now when I try to open an Excel program that has previously worked just fine, all I get is the ...

**0**

votes

**2**answers

19 views

### Auto-increment cells for named rows and named columns

I am looking for a way to reference cells inside named range and have it be understandable for person looking through the spreadsheet.
I have this spreadsheet:
A B C D E F G H
1 ...

**0**

votes

**2**answers

40 views

### Excel- Generate a list from single cell input

My question is basically how can you generate a list in Excel based on a single cell input?
For example, the user types 10 then replaces it with 20 and then 30 etc, is it possible to generate a list ...

**0**

votes

**1**answer

20 views

### Excel - How to create multiple named ranges with a fixed size from one column?

I am wondering if there is a way to create named ranges with a fixed size (252 cells) from one column.
I have 51156 numbers in column B. I want the first 252 numbers (B1:B252) to become named range ...

**1**

vote

**1**answer

56 views

### Using the with cURL command-line tool on Mac, What can I do to this script to ask it to fetch stock data which comes back WITHOUT commas?

cd documents/quoteUpdate
while true
do
curl -o quotes.txt -s "http://download.finance.yahoo.com/d/quotes.csv?s=goog,aapl&f=sl1c1p2pt1"
echo UPDATED:
date
sleep 10
done

**1**

vote

**1**answer

32 views

### Converting date Jan-12 2015 10:51AM to Date format for sharepoint use

I have a date that imports into excel from an external source as Jan-12 2015 10:51AM, but is not a friendly date format for copyinging into sharepoint 2013 datasheet. How do I convert this in excel so ...

**0**

votes

**1**answer

39 views

### How do I do some minor conversions while importing a chat log into Excel?

I exported a chat log as a comma delimited CSV. From that file, I'm trying to import and format it in Excel.
The file has a field for Date and Time formatted mostly as YYYY.MM.DD HH:MM:SS with some ...

**2**

votes

**1**answer

20 views

### Excel - Exclude Cells from Computation

Say I have 5 columns of data with 100 rows (so from A1 to E100). For each row I want to compute the averages of the 5 entries while I always exlude one of the entries. E.g. for the first row I would ...

**0**

votes

**1**answer

25 views

### How to display US format date time in csv file in UK format in Excel 2010?

I have a Windows Performance Monitor csv file that I want to view in Excel and produce charts from. The first column in the csv file is in US datetime format. e.g. "01/12/2015 10:54:44.043" which ...

**0**

votes

**0**answers

25 views

### Copy Rows down with value from another Cell

I would like to copy a row of data down dependant on another cell value.
I have a row of data on Sheet one. A user will put a number into cell C2 on Sheet2 say 13.
I would like the row of data on ...

**0**

votes

**1**answer

20 views

### I need to find the difference of multiple cells

I have seven days that will be filled in with weight i.e 180. So i need the +/- to reflect the change in their weight from day to day. For instance I need the +/- to reflect day one and day two then ...

**1**

vote

**2**answers

43 views

### VLOOKUP or INDEX MATCH doesn't update columns when referencing pivot table

I'm going bonkers trying to figure this out. I thought I hit the jackpot when I learned about Index match and the additional flexibility over VLookup, but that flexibility doesn't seem to help when ...

**0**

votes

**1**answer

18 views

### Keep Original Sorting of Labels in Excel Pivot Table

I have a list of projects and the quarter that they are to be completed in. I used this data to create a PivotTable that puts a "1" under the column for the quarter when the project is to be ...

**0**

votes

**0**answers

15 views

### turning off read only…have tried multiple avenues

I have 2 separate workbooks that I am hyperlinking. When I try to save the document I get a message that the file is read only and to save a copy. I get this for both workbooks that I am ...

**4**

votes

**4**answers

471 views

### How do I add multiple formulas into one cell?

Here are the formulas I need but I can not figure out how to combine them.
=IF(H4=1,IF(J30<=E29,"Pre-Qualified","Unqualified"))
=IF(H4=2,IF(J30<=E30,"Pre-Qualified","Unqualified"))
...

**0**

votes

**1**answer

24 views

### Cannot copy-paste from-to ranges with filtered rows

I want to copy a given range in Excel, which has rows hidden due to filtering out, into another range which has other rows filtered out.
I applied the usual procedure Ctrl+C, Ctrl+V.
It is as if it ...

**1**

vote

**2**answers

33 views

### How do I create spreadsheet that will alert me when a quantity drops below a certain threshold in Excel 2010?

I am trying to make a sort of "inventory helper" spreadsheet that can track quantities. On the summary sheet, I want to be able to enter a quantity into a column called "On Hand" and then if that ...

**0**

votes

**1**answer

16 views

### Using the text values from one column to lead to output in another

I have a list of cities in one column, Column C.
I have a list of countries which relate to each of those cities. How do I get Excel to look at the Column C, compare to my list of countries (I can ...