**0**

votes

**1**answer

6 views

### Can I filter out all rows corresponding to reference list in excel

I have a list of IDs that I would like to select in a excel sheet. I am used to using the filter function to search for 1 ID, but now I would like to filter out all the rows with that match the ID in ...

**0**

votes

**1**answer

14 views

### Excel formula - Return value from lower row

I'm looking for a way to search for a value in a single column and return a value in that same column two below it. Example:
A1: Apples
A2: Bananas
A3: Oranges
A4: Pears
If I search for ...

**0**

votes

**2**answers

16 views

### Why is using this code to replace a formula giving me an error?

In Excel I use the following to clear cell E5 and replace it with the word name.
Sheets("Invoice").Range("E5") = "Name"
I can also use the following to replace G11 with the VLOOKUP code I have here ...

**1**

vote

**2**answers

19 views

### How do I format cells in one column based off cells in another column?

So I found some similar questions to this already answered here, but they don't go deep enough for what I want to do, and was hoping to find some more help.
At a high level I want to format some ...

**-1**

votes

**0**answers

16 views

### How to write % change formula in Microsoft Excel

I have a spreadsheet that I am building and I need to show staffing level changes. I currently have several cells with 0 counts that will be changing to 1, 2 or 3. How do I write the formula to show ...

**-1**

votes

**0**answers

14 views

### How do I export data from an excel file to xml with fixed width columns?

I have an excel file with 7 columns. The data in this file in some cases is shorter than the required fixed widths needed (the export will be used to load into a table in our data warehouse via an ...

**0**

votes

**2**answers

18 views

### Excel Conditional sum on same row

I have a rather basic Excel question, but my Excel skills suck.
What I want is a conditional sum, but I'm not sure how to do it.
Example:
A B C D E
...

**0**

votes

**0**answers

6 views

### Excel saves absolute references to other sheets in my workbook. This causes problems when emailing the workbook to colleagues

I have this the following problem.
I create a pivottable and set a reference to anther Sheet, for example:
=Sheet1!A:C
When I save, copy, cut and paste file to various locations, I end up with the ...

**0**

votes

**0**answers

11 views

### Find duplicates [on hold]

I have a 1 workbook 13863 records. And I want to search these record to 73 xls works. These 73 excel files contain 800,000 records. I want search text from 1 file to 73 files one by one. And match ...

**0**

votes

**0**answers

13 views

### Scan only to excell cell

I am trying to set up a system where particular cells on various spreadsheets can only have data scanned into them. It will also be necessary to disable the ability to input data into that particular ...

**0**

votes

**1**answer

23 views

### Formatting of output .csv file generated by a software

I've been using a software which gives the output in .csv format automatically.
In my .csv output file "." is used as a decimal separator.
But in my colleagues' computer, with the same software the ...

**0**

votes

**2**answers

17 views

### Finding the right graph to display inter-department connections

I have a task of displaying the interconnection between departments at my university. The idea is to show how many departments come together to work on a project. The data I have lists the projects in ...

**0**

votes

**0**answers

17 views

### Macro to update Date in Specific row in excel

I want macro to update current date in cells M10, M15, M18 and M19
Ex:
If format of the date is 01-11-2014,then,
macro should update cells M10,M15,M18:M19 with 1 ...

**0**

votes

**3**answers

27 views

### How do I get the fiscal year to start on a specific date each year in Excel?

I used the formula listed here to generate a fiscal year based on the current month. I have an odd requirement where she wants the fiscal year to start on 6/20. For example, any dates ranging from ...

**0**

votes

**1**answer

19 views

### Pasting a spreadsheet column into a spreadsheet that is keyed differently

I have a spreadsheet (Spreadsheet 1) that has student numbers, and exam results.
Spreadsheet 2 just has the student numbers of everyone in the subject.
I need to paste the exam results from ...

**0**

votes

**0**answers

8 views

### Create a spreadsheet that filters data and allows users to edit filtered data

I have a master datasheet with lots of information. I extract data from the master to a simple overview pertaining to only specific groups of people which takes this data and calculates other ...

**0**

votes

**1**answer

19 views

### converting dates to quarters while displaying the correct fiscal year

My current problem is that the below formula is displaying Q1 2014. I need it to display Q1 2015, as our fiscal year begins Dec 1st. All other months are displaying correctly.
Cell A1 is: 12/1/2014 ...

**-1**

votes

**0**answers

19 views

### Excel crashes upon performing regression

I'm attempting to use the Data Analysis add-in for Excel 2013 to perform regression, something that worked for me last week. Today, however, Excel crashes whenever I try to actually perform the ...

**0**

votes

**1**answer

16 views

### Subtract between two sets if one has value in the same row

In one row I have two possible places for times to be completed, Day Shift and Night Shift.
I want to do a simple subtraction where the cells are completed (Example =O9-S9 or =K9-G9 where there are ...

**-1**

votes

**0**answers

30 views

### Power user but no Expert [on hold]

I've never written VBA in Excel. Is there a source to figure out how to do what you have described here? I keep getting an error each time I copy your formula and run the macro. I"m obviously not ...

**0**

votes

**3**answers

26 views

### Excel Averageifs with multiple conditions in one column

I am looking for some help for how to tidy the second formula below in bold. I am looking to calculate the average 'Pupil_Score' (this is also my first try with named ranges) based on race, I am ...

**0**

votes

**1**answer

10 views

### Search for a string in the whole Excel Workbook

How can I find all the occurences of a sequence of characters in the whole Excel workbook ? (Excel search is limited to the current sheet only)

**-2**

votes

**0**answers

17 views

### Analyzing printers' paper usage [on hold]

Can you please advise me on whats the best was to do the following in excel?:
Analyse print usage using usage counter data from 3 printers (printer A B and C).I would like to show changes in paper ...

**1**

vote

**1**answer

31 views

### How to convert number to words?

Is there any formula / procedure to convert number to words. e.g 25371.34 to be converted as "Twenty Five Thousand Three Hundred Seventy One and paise Thirty Four Only".

**0**

votes

**0**answers

19 views

### excel 2010 formula for counting formulas in a column (or row) [on hold]

I have a huge file containing many worksheet, each of which contains hundreds of rows and columns. Most of the cells contain formulas. In order to be able to check if the result is reliable, I need a ...

**0**

votes

**0**answers

12 views

### Show Excel column filter information in cells - Not working

I am on a W7 64bit pro edition, on a Lenovo T420
With regard to Show Excel column filter information in cells, is there a reason why it is not working in Excel 2003?
Thanks in advance
Gilberto
PS
I ...

**-1**

votes

**1**answer

11 views

### Excel 2010 Select Data making dynamic to static range

I load this into a charts Select Data field ='Metrics Test 2.xlsx'!ROFPS_Range and the chart works fine. If I change the range I am working with the formula is changed to ='UW ATO'!$B$10:$B$15 and ...

**0**

votes

**2**answers

18 views

### Excel - Comparing two variable length columns, removing duplicates from both

I have two separate sized lists in an excel sheet - each around 150,000 columns.
I need to find the unique values in one of these columns. From the ~150,000 records, I'd expect maybe ~800 to be ...

**-1**

votes

**0**answers

28 views

### VBA/Excel meter codes [on hold]

Hello Someone help me out in writing the VBA code for the Meter in the excel, like 3 colors RED(<98%), AMBER(98% to 99%) & GREEN (>99%). if i key the percentage in one of the cell the meter ...

**0**

votes

**0**answers

20 views

### Just installed new office program. Can't open old files

I just purchased a new lap top with Windows 8 and have also installed Windows Office 2013 on this new system. I have backed up and completed a restore of my old PC and now have the files on my new ...

**0**

votes

**0**answers

9 views

### Rows order lost just right after refresh all (data connection - SharePoint)

I got an excel workbook with a data connection to a sharepoint list... everytime just right after a refresh all, the row order dies in some columns. Those columns are "manual columns", the data is ...

**-2**

votes

**1**answer

21 views

### Find absolute cell location of a vlookup reference

How do I extract the location (row & column) of where a vlookup function located the specified value? I am trying to locate which row of a spreadsheet a key word is found so that I may then use it ...

**0**

votes

**0**answers

18 views

### How to add markers to all series in an excel line chart in one go?

I have about 15 series in my chart and do not wish to manually select and edit each one individually to give it a distinct marker
Is there a way to do this for all lines in one go?
I don't care if ...

**-2**

votes

**0**answers

16 views

### Software to automate the download of a list of URLs to special paths [on hold]

I have a similar question as Software to automate the download of a list of URLs
However I have two columns, the first one contains list of URLs (images) to download and the second one (with the same ...

**0**

votes

**0**answers

9 views

### MS Excel: save spreadsheet to tab-separated with UNIX end of lines and UTF-8?

I have a tab-separated text file with a table that has UNIX end-of-line characters (i.e. \n) and UTF-8 encoding. I can open it in MS Excel 2010 without major problems using Data → Import and selecting ...

**0**

votes

**1**answer

8 views

### Open XLS file in protected mode manually

Is there a way to open the excel document in protected mode manually.
I know one way to open it as a protected mode.
Uploading to the web and Downloading it back let Excel think it's unsafe so that ...

**1**

vote

**0**answers

15 views

### How do I separate a word document according to a list and email

I am using Office 2010. Our payslip comes in a word document and I usually print out and deliver to each staff. Each page has each employee's payslip. However, I want a macro or VB script that can ...

**0**

votes

**0**answers

10 views

### Displaying data correctly in a chart Word 2013

On the horizontal axis on this graph, I only have data for 1, 5, and 25. I want the graph to display as if i had 25 values and have the data show it respectively.
For example, instead of reading
1 ...

**0**

votes

**0**answers

15 views

### How to know everything about Office Word and Excell? [on hold]

I'm looking for an on-line video training (free or paid) where I can learn everything about MS Word and MS Excel and how to use them professionally. Could you tell me about excellent website or ...

**0**

votes

**2**answers

18 views

### Data modelling, calculation and visualization tools?

I often need to make decisions based on various kinds of data and their calculation results/visualizations respectively. For simple, tabular data I usually make Excel spreadsheets, however most of the ...

**0**

votes

**0**answers

12 views

### Excel 2010 short cut keys - Ctrl + Left or Right Arrow Key - are not working anymore

My Excel 2010 short cut keys - Ctrl + Left or Right Arrow Key - are not working anymore. However, the short cut keys - Ctrl + up or down arrow keys are working. I will appreciate it if the learned ...

**0**

votes

**0**answers

14 views

### XL 2003 crashing on ANY VBA code in ANY class module - code module OK

Any sub in ANY class module including ThisWorkbook, an added class module, or even the worksheet class modules all crash IMMEDIATELY upon launch of XL 2003 or upon invocation via control or button. ...

**0**

votes

**1**answer

21 views

### how to create persistent random numbers &letters in excel?

Below is link for example sheets https://docs.google.com/spreadsheets/d/1D-D29csRGAAZl_h7fyMwLJ6am0FpZAtCZ5r0XlmQVqo/edit?usp=sharing. This is a live spreadsheet, which can't be pasted in this ...

**0**

votes

**1**answer

21 views

### Simples??? How to set all fields in Excel spreadsheet to convert from lower-case to UPPER-CASE

I know this must sound like I have no idea what I'm doing. Older versions of Excel had a page/sheet function which could be set to ensure all fields in an Excel spreadsheet would automatically convert ...

**0**

votes

**0**answers

8 views

### Matching Dr and Negative amount in particular column [on hold]

I have huge number of amount in the excel column. Many of the items are netting to zero. These netting to zero items I need to match manually by checking each items. Is there any macro codes where I ...

**0**

votes

**0**answers

12 views

### Google Docs Formula [migrated]

I have a problem creating a formula for my sheets. I want google docs to put either "yes" or "No" in a specific cell depending on the values in other cell. in other words I want it to put "Yes" when ...

**0**

votes

**1**answer

15 views

### Excel 2010 - Averaging columns data by different columns

My data includes several repeated measures (~4-5) for each participant and i want to be able to average all specific measures for each participant.
for example, in the screenshot attached, i want to ...

**0**

votes

**2**answers

22 views

### In excel, how can I format a raw so that the second number is in parentheses?

I have a row with the following numbers:
4 (8) 3.8 (12) 5 (7) 4.6 (35) 5 (8) 4.4 (27) 4.8 (104) 4.3 (38) 4.3 (2,634) 4.4 (54) 4.5 (90) 4.8 (156) 4.6 (297) 4.5 (26) ...

**0**

votes

**1**answer

17 views

### Merge two files with fuzzy / inexact key column

I have two spreadsheets with different dimensions. They share a common column, but not all the names are 100% similar. Specifically, I'm merging two data files from counties around the US, one has ...

**0**

votes

**2**answers

20 views

### Fatal error in excel “Errors where detected while saving filename”

I have some of excel files and I got an error while saving that says "Errors where detected while saving file name. Microsoft Excel may be able to save the file by removing or repairing some features. ...