**0**

votes

**3**answers

40 views

### How to calculate the first occurrence of a given weekday in the next year in Excel?

I need to calculate the first occurrence in the next year of the weekday of the date in cell A1. For instance, if the date in cell A1 happens to fall on a Thursday, calculate the first Thursday of the ...

**0**

votes

**1**answer

35 views

### Using Dynamic Repeating Formulas in Excel Templates

I have an Excel merge template that compares Actions to Results. It is used by many different sales people. For that reason, the length of the spreadsheet can vary. The users have limited Excel ...

**0**

votes

**3**answers

37 views

### In Excel replacing a column with another column

I have a list of Variables in Column A > list of items
another list of variables in Column B > with corresponding Item Codes for >> column A
And in Column C > I have list of item codes randomly ...

**0**

votes

**2**answers

16 views

### Combine two excel documents with imported data and pivot tables

I have two excel documents. Each has a sheet with imported data from web and a sheet that contains a pivot table based on the imported data and chart summarizing that pivot table.
I want to combine ...

**0**

votes

**2**answers

25 views

### How to highlight strings that match pattern in Excel?

I have a large set of data that needs to have some visual formatting cues added for visual review. Essentially the particular matches are phone numbers that have to be matched and when found the row ...

**1**

vote

**1**answer

45 views

### Excel - Lookup to match varying criteria

I have a list of poles, some with more than one test result. I want to find the latest test result for each pole and then return the result. As we know, VLOOKUP only finds the first. I don't want ...

**0**

votes

**1**answer

50 views

### How to delete entire row when A1:A100000 columns are duplicated

I have to filter quite big data (102858 rows, 9 columns).
The idea is that between these rows (URL addresses) are a lot of duplicates. A1:A102000 contains URL addresses with and without comments. For ...

**-2**

votes

**1**answer

33 views

### How to calculate monthly sum from the entries for each date in Excel?

I have colums for my workout logging:
Date
Running (minutes)
Pushups
Pullups
Crunches
and the rest of my workout entries.
I insert my achievements each day.
How can I script Excel to ...

**0**

votes

**2**answers

28 views

### How do I make a button to add new fields in Excel?

I have a formula which uses a constant. Every time I copy and paste the cells for a new day, I want the constant to update to the new one.
I was thinking I could create a button to copy the fields ...

**0**

votes

**2**answers

36 views

### Formula update no longer working

I have the same formula update problem as others posted on this site.
I have a formula =SUM(B1+B20). I'm trying to enter dollar amount in B1 and updating the dollar amount in B20, thus increasing ...

**0**

votes

**1**answer

19 views

### Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...

**0**

votes

**1**answer

12 views

### Fixing numeric cell in a formula in excel on a Mac

I would like to use repeat a formula with some constants noted in an assumption table how do I do so in Excel on a Mac. In Excel on a non Apple device the formula would be something like this ...

**0**

votes

**3**answers

50 views

### Excel documents will open excel with blank window

When opening any excel document it will only bring up the excel window. To open the document I will have to goto file -> open.
I am using Office 2013 on windows 7 64bit
Only started happening the ...

**1**

vote

**0**answers

33 views

### Office 2013 can't open office 2010 protected file,vice versa

I couldn't achieve to produce an interchangeable protected file between Excel 2013 and Excel 2010.
Excel 2010 can't open 2013s protected one and 2013 can't open 2010s protected one.
I think their ...

**0**

votes

**3**answers

34 views

### One Excel file, multiple editing users, live updates

I have an automated program which is working on Excel workbooks. When someone opens the workbook currently being processed, they will get a read-only message. If multiple users/programs try to open a ...

**0**

votes

**2**answers

28 views

### How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates?

How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates?
I also want to limit another range of cells to maximum 24 alpha and "-" ...

**0**

votes

**1**answer

12 views

### Excel leaving formula when selecting another sheet

I am attempting to reference a range in another workbook in a vlookup. I type "=vlookup(a1," and then go to the other workbook to select the range, but alas, I am no longer in the vlookup formula. I ...

**0**

votes

**2**answers

36 views

### How to embed or link a text file in Excel?

I have a text file containing a memory dump from an embedded system, which I update after every run (the file is formatted in the Motorola SREC format, but this is not too important). I am using Excel ...

**0**

votes

**1**answer

22 views

### How can I in a pivot filter detail to show new accounts in current month with sales where all other months show no sales?

I have a pivot table which is huge with raw data has more than 800,000 lines. I have customers in the row labels and month or year in the column labels.
Each month this pivot tablr grows adding on ...

**-4**

votes

**1**answer

40 views

### Have range of numbers and need to find repeats/missing sections contained in two columns

station start station end
0+00 50+00
50+00 100+00
100+00 150+00
150+00 200+00
250+00 275+00
300+00 350+00
325+00 350+00
350+00 400+00
I have two ...

**0**

votes

**1**answer

17 views

### Attempting to wrap text

I want to prepare a form in excel to be completed by others. The responses will require several lines. I've tried to merge cells and wrap text. Then when I begin to type, the text begins at the ...

**2**

votes

**1**answer

45 views

### Excel 2013 table formatting

I currently have a table that looks like this:
Company | 2013 Total | 2013 Gross $'s | 2013 Gross % | 2012 Total | etc..
| | | | |
...

**1**

vote

**1**answer

38 views

### How can I stop excel from rounding to .00?

My Excel formulas are producing answers that only give zeros after the decimal place. For example,
=QUOTIENT(10.90,0.0450)
gives the answer of 242.00, it should be 242.22. How can I keep this ...

**0**

votes

**1**answer

24 views

### How to prevent all-filtered-out row label values from appearing in a pivot table?

I have a pivot table in MS Excel. For the same of example, suppose the basic data has 3 columns:
Name: A string.
CountMe valued either 0 or 1.
Year an integral number.
Tokens the data we're ...

**1**

vote

**1**answer

74 views

### Unix Command to get number of lines in a csv file

Hi Iam new to UNIX and I have to get the count of lines from incoming csv files.
I have used the following command to get the count.
wc -l filename.csv
Consider files coming with 1 record iam ...

**0**

votes

**2**answers

31 views

### How do I calculate the number of months between two dates in Excel? [duplicate]

I have two columns on Microsoft Excel: F is the column with the date service ended; E is the column with the date service began.
How do I calculate and report the number of months served for each ...

**1**

vote

**1**answer

16 views

### Microsoft Excel - Formula query

I need to create a formula as follows:
IF SUM of Columns A2:D2 = 0, then excel should populate in column E, the value of "NO", else it should be a default "YES".
This is what I've tried
...

**1**

vote

**0**answers

19 views

### Make Excel 2007 pivot tables default to Classic View

When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be:
New view (not Classic view)
Autofit column widths on update = on
Subtotals = on (top of group)
I end up ...

**0**

votes

**4**answers

32 views

### Convert letter grades to number

In Mac Excel 2011, how can I convert a letter grade in one column to a gpa number and place it in the column next to the letter grade. I have about 70,000 grades I need to do this for.

**0**

votes

**1**answer

18 views

### Formatting an Excel date without space between elements

I am trying to format a Date in Excel (Office 2010 for what matters) in the following format:
<week day><day>/<month> (e.g. "Wednesday14/3").
I came up with the format dddd_dd/m ...

**0**

votes

**1**answer

35 views

### excel - if value grater than, use that value

I am having problems with my excel function. I want to:
if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell.
...

**0**

votes

**1**answer

27 views

### Excel dates formats

when users enter a date in excel using this format 19.03.2013, i need the cell to automatically change the format to Wed 19 Mar'14.
Please advice!
Please check in the attached image, where I copied ...

**0**

votes

**0**answers

41 views

### Excel test generator inserts extra data. VBA

I build a random test generator for Excel using VBA. It will randomly pull questions from a test question bank. It will also add the answers in a different cell. However, I found that occasionally ...

**2**

votes

**1**answer

22 views

### Is it possible to specify the decimal separator on Excel refreshable web queries?

When you create an Excel Web Query that points to a text file located in a web server, Excel doesn't ask for the decimal separator as it commonly does when using the Import Text File or Text to ...

**0**

votes

**1**answer

17 views

### Excel Chart from Multiple Sheets

I have a bunch of sheets and each one has a value in cell K15 and call K20. How do I make a stacked column chart that shows these values stacked for each sheet?
Forgive my crude drawing, but ...

**-2**

votes

**0**answers

42 views

### Looking for formula in Excel to take the set of cells in the row and check for a match in a column

For each row in my spreadsheet I want to use a formula to check the values in the 17 columns B:R for a match in a smaller vertically oriented table and then check to see if the corresponding value in ...

**0**

votes

**3**answers

36 views

### How to add progressive 'count' in rows

How do I format cells such that when entering data, formatting automagically add a number before the text such that the number is equal to a number+1 from a an adjacent cell (in my case from above)

**0**

votes

**3**answers

53 views

### How to use =VLOOKUP under these circumstances?

So I know how to use =VLOOKUP when you are searching for a single value within a cell, but I'm not sure how to do it when I have a range, ex. say the cells value is 1-5, the next is 5-10.
This is ...

**0**

votes

**1**answer

34 views

### Run Command to open csv file in excel

My first question on the site, so hopefully I'm doing this right.
I use file juggler on my windows machine. The program can watch for new files and trigger run commands.
When a new csv file arrives ...

**2**

votes

**2**answers

32 views

### Excel: Select the cell to the left that is greater than/less than some value

I have a data entry form that is used to input data from image analysis. I take segments of images of membranes in ImageJ which I then paste the intensity values into an Excel spreadsheet. A graph ...

**1**

vote

**1**answer

171 views

### Excel TEXT function does not work properly

Let say I have the following values in the cells
A1 : `=Now()` which displays 17.03.2014 13:45
A2 : 12.03.2014
Both are in date format and I have the function in another cells like this:
B1 : ...

**0**

votes

**1**answer

24 views

### Formating data to fit report?

A friend needs to turn the few sheets she has in an Excel file into a report.
Before I learn about how to use Word's mail merge feature, I was wondering if there weren't a good solution in Excel to ...

**1**

vote

**3**answers

47 views

### ,“>”&0),“”) at the end of a countif formula

I have the below formula, but don't understand why the last part of it ,">"&0),""). Can somebody clarify pls?
...

**0**

votes

**1**answer

21 views

### VLOOKUP with string returning #REF

I have the following set up in Excel, and I am attempting to lookup the first column in the range A5:A7, and return column 8 (the rate) plus the custom rate.
This is the link to the current setup I ...

**0**

votes

**1**answer

38 views

### Excel - How can I highlight duplicate cells in near-matching worksheets?

I'm running a March Madness bracket tournament using Excel spreadsheets. I have one sheet where I will input the actual winners. I have an additional sheet per participant that is near-identical, only ...

**0**

votes

**0**answers

30 views

### Keyboard media keys (play, pause etc) don't work while Excel 2013 is active

Excel 2013 appears to "swallow" these keys: whenever it's active, play/pause and similar keyboard keys don't work at all. Activate any other application and they work again.
Is there a known fix?
...

**0**

votes

**2**answers

42 views

### Index and Match to a file posted on SharePoint returning #Ref Error

I have two Excel files posted on SharePoint. With the master file, I've created INDEX, MATCH array formula, referencing the other file. I've entered the entire NUC, and the formula works fine while ...

**1**

vote

**1**answer

17 views

### custom conditional formats in excel 2013

my goal is to format an entered text if a certain condition is met
e.g.
user enters "5" in a cell
format detects that it is greater than 3, appends "/a" [result: "5/a"]
user enters "2" in cell
...

**0**

votes

**1**answer

22 views

### Ctrl+[ not working in Excel 2013

The keyboard shortcut Ctrl+[ (trace precedents) is not working on my new laptop. I am using Excel 2013. Can anyone explain how to set it to work?

**0**

votes

**1**answer

21 views

### Relative cell reference in Excel using different axis

Is it possible to make a relative cell reference that extends downwards when I copy the value to the right? Consider this example:
10% 100 150 200 250 300
15%
20%
25%
30%
I would like to ...