# Tagged Questions

**0**

votes

**1**answer

23 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

100 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

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

**0**

votes

**3**answers

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

**1**

vote

**1**answer

14 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)

**1**

vote

**1**answer

35 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

16 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

20 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

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

**0**

votes

**0**answers

21 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

16 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

27 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

**1**answer

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

**3**

votes

**1**answer

53 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

12 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

18 views

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

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

11 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

**2**answers

21 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

19 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

17 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

32 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

23 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

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

16 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

24 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

19 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

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

**0**

votes

**2**answers

33 views

### If there are values in specific cells, I need them to subtract from one main cell

I need to find an equation so if there are any values from B2-R2 it will subtract 1 from W2 which needs to start at a value of 17.
For example, if the value of D2 is 6 it will subtract 1 from W2. ...

**0**

votes

**2**answers

40 views

### Excel IF Formula Not Working Correctly

I have an Excel IF formula that is not working correctly and I cannot figure out why.
Here is the formula:
=IF(D17<=200%, C17*130%, IF(D17<=150%, C17*120%, C17*140%))
When D17 > 200% it is ...

**1**

vote

**1**answer

43 views

### Align unique values in two columns in Excel

COL 1 COL 2
A E
B G
C A
G A
D C
E F
D F
F F
I want it to look like:
COL 1 COL 2
A A
BLANK A
B BLANK
C C
D BLANK
D ...

**2**

votes

**1**answer

30 views

### IF and then condtional format

In Column C, I Want to rename the Column A Name in order of Date Of Birth, but only if a duplicate is found. Otherwise, the name in Column C should be the same as Column A. For example, there are ...

**0**

votes

**1**answer

40 views

### Calculate the difference in hours from now and next workday's 9am

How do I calculate the difference in hours from now and the next workday's 9am?
If NOW() is Thursday 6pm and the next workday is Friday, the function would then return 15.
If NOW() is Friday 5pm and ...

**-1**

votes

**1**answer

32 views

### How can I use 2 different sizes of the same font in one cell?

For instance, I want to list a person's name in one size font, and his graduation year ('14) in a smaller font.

**0**

votes

**1**answer

61 views

### Copy Active Cell Comment in Excel into a new word file

i do not know much about Macros, is it possible someone could help me out.
I have a simple excel file with names of Clients that have a lot of comments on each name. is there a fast way other than ...

**1**

vote

**3**answers

53 views

### Checking whether a label exists between two other labels in a column

I have a column (call it A) in Excel lists off different items and their properties. Every item has the word "Type" associated with it and so there is a cell with that label in column A so that in ...

**-1**

votes

**1**answer

33 views

### Excel- SUM formula not working on IF formula converted data [closed]

In excel I used an if formula to change values to 1 or 0. This worked fine. I tried to sum the data from J2:J2103 but it always shows a zero for the total. I used auto sum and it showed the total to ...

**0**

votes

**1**answer

28 views

### Excel item value data to line graphs with labels

I have a data set like this:
Set Type x y
S1 A 1 24
S1 A 2 87
S1 A 3 33
S1 B 1 66
S1 B 2 11
S1 B 3 20
S1 C 1 79
S1 C ...

**0**

votes

**1**answer

20 views

### Looking up the row number of a shared identifier in Excel, and counting the number of cells in that row that meet specific criteria?

I have a sheet that contains a lookup value in columns. I want Excel to look for each value in another sheet, and count the number of instances of a certain word in the row in which it found that ...

**0**

votes

**1**answer

36 views

### Can I separate email id in spreadsheet based on domain in columns? [duplicate]

I have a list of 20000 email id which have emails from domains like gmail, ymail, gmx, hotmail, custom domains etc I have those list in a spreadsheet Column A. Can you help me separate them according ...

**1**

vote

**1**answer

16 views

### Powerpivot: how do I avoid measures from computing until I'm done entering multiple measures?

With Powerpivot, I have many measures (>25) to enter in a dataset that has millions of entries. When entering the DAX expressions for the measures, each time I enter one, Powerpivot takes a long time ...

**0**

votes

**1**answer

23 views

### Dynamic chart updates only when I let go of the scroll bar

I have done the usual scroll-bar to update the chart using dynamic name range. Now the problem is the chart only updates when I release the scroll bar. It does not update if I keep it pressed.
I can ...

**0**

votes

**2**answers

38 views

### how to check for a value in excel and populate column based on it

I have the following query :
My input table is
Basically I want to lookup columns for each ID.
Value3>Value2>Value1
If value3 and value column has data then ouput should show ID having value3
If ...

**0**

votes

**2**answers

53 views

### Excel Formula- Having a number automtically divide in half after 6 months

I'm tracking Transitional Housing in a Microsoft Excel- we pay a client's full rent for 6 months, and then half of that for the following 3. Is there a simple excel formula that can automatically half ...

**2**

votes

**2**answers

31 views

### Return a value given that a number is within a certain range

I'm looking for a little help on my scheduled withdrawals problem. I currently solve this with nested IF functions, but I'm getting more and more ranges and that leads to more and more nested IF ...

**0**

votes

**0**answers

22 views

### Expored XLS file opens the first time, can't be subsequently opened, even if it first opened in ReadOnly mode?

I have an application that exports a lot of various sets of data to Excel. One of our exportation routines is generating a very-basic Excel file. Our users have sent in a ticket claiming that when ...

**1**

vote

**1**answer

30 views

### Excel VBA to add cumulative total to new sheet

I am trying to create a workbook that creates a new page and puts the cumulative total from two cells to add to the new totals entered on the new page. I've been able to create a new page, but can't ...

**0**

votes

**1**answer

16 views

### Network resources being called when no connections are configured

Some users were reporting awful performance in Excel 2010 when doing simple things like clicking a cell or changing sheets for many workbooks they use.
I made sure there were no dead connections ...

**0**

votes

**1**answer

21 views

### Excel Data Validation List as Formula in “Source” Field?

I am using Excel 2007.
Is it possible to enter a short list of allowed values directly into the "Source" field in the Data Validation -->Settings Tab?
If I want to allow a cell to have one of two ...

**0**

votes

**1**answer

21 views

### Insert formula for each row in Excel or LibreOffice

I have the following data in LibreOffice:
As you can see there are 3 sets of measurement. I want to automatically feel in the D column with the following formula automatically. For example D2 will ...

**0**

votes

**1**answer

24 views

### Is there a formula I can use which when i drag automatically references +5 columns each time? [duplicate]

Trying to reference cells A1, then + 5 columns so F1, then + another 5 columns K1, and so on......
Is there a formula I can use which when i drag automatically references +5 columns each time?