**2**

votes

**1**answer

24 views

### How can I use Excel data bars to format cells with text values?

I'm creating a spreadsheet for project planning and have a column that lists estimated effort as follows:
Unknown
Very High
High
Medium
Low
Very Low
None
I like the visual cues provided by ...

**0**

votes

**2**answers

29 views

### Excel: Do not open files in multiple instances

How do I open all excel files in the same instance/window by default (happens only when I open from the menu, but not from the windows explorer)?
I have this option unchecked, but is still not ...

**2**

votes

**2**answers

26 views

### Dynamic formulas based on other cell formula results

I have 10 years of monthly data for 300 plants. While Excel can do moving averages for various time periods I am looking to do a moving median value for this data set.
I can obviously figure out the ...

**0**

votes

**1**answer

33 views

### How to disable specific Excel 2010 add-ins at startup?

I want to disable specific add-ins from loading in Excel 2010 every time I open up a new workbook or instance. How do I achieve this?
When I disable the specific add-ins by unchecking them in the ...

**0**

votes

**1**answer

32 views

### Word document loads incredibly slow

I have a word document (286kb) which takes almost 2 min to load. The document contains a large number of excel objects (as links from the same workbook).
This is what I've tried:
Remove the "old" ...

**1**

vote

**0**answers

15 views

### Feeding Data from SQL Server to Excel Template with visual studio c++ program [on hold]

I started a projet of automatic reporting.
To realize this i am using Microsft Visual Studio 2010 C++ (Ultimate edition)
Right now the project is almost finish, but i am getting stuck at the last ...

**1**

vote

**2**answers

25 views

### Deleting segments of a text cell value in Excel

I have many lines that follow a similar suit to the below format in my Excel sheet:
JFB001 D (2 Stem Flower Spray Orange Handcrafted Sugar Decorations) Web.jpg
What do I have to do, in order to ...

**0**

votes

**0**answers

23 views

### Excel import/ format problems

After clearing out lots of junk and formatting to a legible layout in excel im having problems crossing one final hurdle. My data I've imported is really hard to work with as its in the following ...

**1**

vote

**1**answer

22 views

### Two Columns Sum if

I have an "amount column" and a "Date Vouchered column". What I would like is a formula in a "summary cell" that will show the sum total of the amounts once a date vouchered has been placed next to ...

**4**

votes

**2**answers

89 views

### Showing a zero in front of a number in Excel

How do you get a zero to show up in front of a number if the numbers in the column are all different sizes, such as bank account numbers?

**0**

votes

**2**answers

32 views

### Shortening an Excel formula if possible

I am unable to shorten an Excel formula I am using in an Excel database. I have googled it, but this appears to be the shortest way already from the first page on Google.
...

**3**

votes

**1**answer

37 views

### How to convert data in Excel to percentages of total?

Is there a quick way to convert all cell values in a table to a percentage of a total listed in a separate column? I tried posting an image of my data as an example, but my reputation here isn't ...

**0**

votes

**1**answer

25 views

### Formula Required for Costs to date based on number of project days completed

I am trying to put together a template for project costs and am looking for a way to roll forward daily costs for each account code that avoids the need to change the formula on a daily basis.
I have ...

**0**

votes

**1**answer

22 views

### MS Excel : point a cell by concatenating text

In Microsoft Excel 2013, I want to point to a cell with this kind of formula :
=Sheet1!["A"+E1]
Where E1 contains the number of the line, for instance 25.
So the purpose of the formula is to get ...

**0**

votes

**1**answer

13 views

### excel: compare 3 column's numbers, decide on the largest number and place the column header in the 4th column

i want to compare the numbers of three columns, row by row, decide on the largest number and then place the title of the column of the largest number in a fourth column. the fourth column will end up ...

**2**

votes

**2**answers

19 views

### Excel: Auto-updating chart with changeable starting point

I have hooked up excel to an auto-updating database, but now I want to go a step further and make all essential report items automatic as well. And not only that - I want to make the way report looks ...

**-3**

votes

**1**answer

23 views

### Find and Replace in all excel files

I am no programmer. Is there a macro/vba/tool that allows me to find and replace in all opened excel files, at once?
If not, an external tool that allow me to drag & drop files, because I have ...

**-1**

votes

**0**answers

19 views

### Source code vCard to MS Excel [closed]

Do you have any source code to convert contacts from vCard to MS Excel? Any type of language such as Java, C# and C++. Thanks in advance

**0**

votes

**0**answers

12 views

### Adding to ranges within the XIRR function

The following (left side) is the standard example from the help on the XIRR function.
The 37.43% is the XIRR.
Now, assume that the initial row values are from somewhere else and I want to somehow ...

**1**

vote

**1**answer

63 views

### Setup Excel 2010 sheet that automatically popluates bi weekly dates

I'm trying to set it up where if I fill in a date it will automatically fill in the next column and on down. For example:
A1= 10/06/14 B1= 10/19/14
I want A/B 2 to be 10/20/14 and 11/02/14. I found ...

**1**

vote

**2**answers

29 views

### Excel - Pick Top 3 Choices

I exported a Qualtrics survey which had users rank 6 options. I want to then take their top 3 options and list them in the row.
Example:
Choice A Choice B Choice C Choice D Choice E ...

**0**

votes

**1**answer

45 views

### Compare Excel Columns A & B and return C

I am a High School Principal and I need help figuring out how to use excel to create a class tracer for my students. A tracer is a spreadsheet that tells you what classroom a student is in during a ...

**0**

votes

**1**answer

21 views

### LO Calc / Excel - Dropbox change another cell

I am creating a simple Point of Sale System for a store using an excel/libre office spreadsheet.
The spreadsheet has a sheet called "Inventory" which has the following columns:
Name
Price
This ...

**-2**

votes

**1**answer

28 views

### Compare two rows and two columns and sum the 3rd row of the common value

I want to compare two rows and two columns and have to sum the third row of the common value.
I have two sheets. In one, I have the work the students made, ordered by date. In the same sheet, I have ...

**2**

votes

**1**answer

34 views

### Can I sort in excel but read the cell values from right to left?

I have an excel worksheet list of names and email addresses. Some of the email addresses, however, are cutoff on the right and have "...".
For example: some email addresses are "test@test_user...". ...

**0**

votes

**0**answers

12 views

### How can Excel add-ins be managed in an environment with multiple version of Office?

I have both Excel 2010 and 2013 installed. COM add-ins appear to be shared by all versions of Office. This is problematic because the whole point of having multiple version installed was to be able to ...

**0**

votes

**1**answer

48 views

### Lookup Values Based on Values in Other Cells

I have an inventory list that contains a manufacturer name and product category for each product. I want to look up the code for the manufacturer and the category code for the product and place the ...

**1**

vote

**2**answers

34 views

### How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date).
The chart is printed or worked on at ...

**-1**

votes

**2**answers

68 views

### Use Excel VBA If value in column a is not in column b then add value to column c

Dim i As Variant
'For i = 1 To 5
For Each i In rngWatch
Dim c As Variant
c = rngWatch.Cells(i, 1).Value
If i <> rngReconcile.Cells(i, 1).Value Then
MsgBox i
...

**-3**

votes

**0**answers

23 views

### Password protect excel sheets [duplicate]

How Do I password protect excel spreadsheets? I am making dashboards for employees and I would like to assign each employee a certain password to access their worksheet.

**0**

votes

**2**answers

26 views

### Reference cell range parameter from other cell dynamically in excel

I've got a simple range based formula
=SUM(A3:A$5)
I would like to dynamically assign the range value in the formula by referencing another cell's value, for example
cell B1 = 3 and cell B2 = 5
...

**0**

votes

**1**answer

50 views

### How to make Excel treat days/dates as starting at 8 p.m. rather than 12 a.m

Our 24-hour day is 8PM to 7:59PM. That's considered 1 day, not 12AM to 11:59PM. For times after 8PM, I need the entries to be considered part of the next day. For example:
Actual Date/Time ...

**0**

votes

**1**answer

25 views

### Inserting N Values into N Blocks

I have a column with values that repeat an arbitrary number of times before the next block begins. Some of these blocks, however, contain no number at all. While every other block is unique, these ...

**1**

vote

**0**answers

33 views

### Return a value adjacent to the first negative number in a column

I have a retirement calculator and I'd like to add a cell showing how long into retirement my savings will last. So I want to have it display the date (column A) that my balance (column C) first drops ...

**1**

vote

**1**answer

30 views

### Glitch in Excel's MATCH?

The formula bellow returns #N/A but I was expecting 3( because the 3rd row contains smallest value that is equal or greater that 4).
=MATCH(4,M37:M41,-1)
Contents of M37:M41
1
3
6
12
24
Does ...

**0**

votes

**1**answer

34 views

### Count the number of Files assigned each month only if in current year

I have a date column which is labeled "Date Assigned" and I want to total the number of occurrences of a certain month (which represents how many files I assigned that month) only if it's in the ...

**2**

votes

**1**answer

9 views

### Excel 2013 Date Grouping - Pivot Table

In Excel 2013, once i group my date column by Year,Months,Days it is converting the date value to a string which results in it sorting out of order. I have already double checked that the values are ...

**0**

votes

**1**answer

33 views

### How to use DATEVALUE with diffent locale setting without changing system settings

I have an Excel column that uses US date format, i.e. MM/DD/YYYY, but is a text column. I need to convert it to the date column for which I'd normally use the DATEVALUE() function. However, because my ...

**-3**

votes

**0**answers

28 views

### I need to know the formula for below [closed]

I need the formula to find the intersection value on table.
now when i enter the zone & billable weight, then it want to show the correct intersection value & one more trick is also know the ...

**-2**

votes

**1**answer

32 views

### What formula can I use to colouring in columns?

I am creating a planning spreadsheet for the operators to use on the shop floor.
Products have a specific time in which they are made. All I want to do is, when I type a product name into ANY cell, ...

**1**

vote

**2**answers

24 views

### Can you save font choice in a CSV file?

I have an XLSX file where there are two different fonts. One cell contains English, while the other contains another language. I would like to save this XLSX file as a CSV file without losing the ...

**0**

votes

**1**answer

32 views

### in Excel, Can I replace “sheet1!” with a formula?

I have 100 sheets named as 1,2,3....100
then in each sheet, there's a value in cell A1.
I am building a summary sheet now, in the summary sheet, I want A1 = 1!A1, A2 = 2!A1, A3 = 3!A1 ...... A100 = ...

**0**

votes

**0**answers

21 views

### Mac Excel 2011 xlsm file will not open

I really hope someone might be able to help. I have just saved my research data base as a macro-enabled file. The screen went grey and hence I closed the app. On reopening, the file can be seen, and ...

**-1**

votes

**1**answer

27 views

### Remove duplicate PERSONAL spreadsheet [on hold]

I have apparently two PERSONAL workbooks on my computer. I understand that I need one to store custom macros that aren't part of add-ins or attached to specific workbooks.
I only need one, but due ...

**1**

vote

**1**answer

40 views

### Conditional Formatting if one time is greater than the other

I'm attempting to get excel to conditionally format a cell based on if it is 5 minutes greater than the value in the column next to it. It's to compare times to see if a person was late to work, we ...

**-1**

votes

**0**answers

11 views

### Excel Charts in charts sheets always selected when open file

when I open an excel file with chart sheets the charts are always "selected" why is this happening. I have to unselect them by clicking outside chart.

**0**

votes

**1**answer

28 views

### Search a range for a string- check if string of the cell beside matches

The title is a bit weird I admit.
Okay:
Cells B:B contain a single character
Cells C:C contain strings
Cells D:D contain a single character
Cells E:E contain strings
Cell F1 wants to return ...

**0**

votes

**1**answer

30 views

### Convert a range to a percentage in Excel

I have a range of figures I want to convert to percentage.
For example I have temperature readings taken every hour over a full day. The range is from 4.5deg to 15.5deg. I want 4.5deg to equal 0% and ...

**-4**

votes

**0**answers

26 views

### Excel copy paste if macro vba [closed]

In excel, can you help me build a macro/vba for this task:
Copy-paste $M$1:$N$1 to Column M:N, if Cell in column C="price".
Thank you all!

**0**

votes

**1**answer

11 views

### Expression in Access involving dates

I have written the following formular in Excel to calculate the year a person will be 18 by 1st September based on their DoB (in cell F2). It seems to work ok in Excel:
...