The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

40 views

### getURL excel UDF

So in reference to a previous question I asked about displaying text and its hyperlink by referencing it in another cell, I found someone wrote this macro command for excel to retrieve the URL ...

**0**

votes

**0**answers

15 views

### How can manage stock as FIFO bases

Can someone help me to manage stock as FIFO bases?. (date wise or batch wise)
suppose, i have purchase the calculators having batch # 3 on date 1/1/15 and batch # 6 on date 10/1/15, now I want to make ...

**0**

votes

**0**answers

16 views

### Is there any formula in Excel 2010

How can I use formula value of one cell in another formula of another cell?
Suppose, I have a formula =(B2+C2+D2)/3, now I want to use the result value of this formula in another formula i.e, ...

**0**

votes

**1**answer

23 views

### Can excell put fields in a template that can then be copied as regular text?

Ive been trying to figure this out but havent found many answers for this function. Essentially what I am trying to do is have Excell put my data fields in a text template so I can copy and paste ...

**0**

votes

**2**answers

21 views

### Excel Find+Replace lowercase after a certain character

I have a column that requires specific formatting for summaries of articles. Everything after a : should appear as an uppercase for consitency
Example 1 - Markets: Comment on Ugandan Shilling
...

**0**

votes

**0**answers

24 views

### Is there a way to enter negative time into cell in Excel?

I am trying to enter a negative time value into a cell and receive the error "The formula you typed contains an error." I have tried changing to the 1904 date system but receive the same error. The ...

**0**

votes

**1**answer

29 views

### Excel - compare cells of columns and delete row if they contain partly the same value

I try to delete rows of a CSV file, where two columns contain partly the same value, like this:
ColA ColB ColC ColD
mydom/users/michael mydom2\michael ...

**0**

votes

**1**answer

68 views

### How to find matching cell values between 2 columns but return the value of another cell. Excel 2010

Image of the excel file is above/attached.
I have data in Column D that are matching in Column A
What I need is for Column C to output the value in Column B same row
So in an essence:
D2 has a ...

**2**

votes

**2**answers

39 views

### How to convert a string referencing another worksheet to an equation?

I have this cell:
="='C:\Daily Reports\" & A1 & "\" & B1 &"\[Report " & C1 & ".xls]Report'!K4
which creates a string like so:
='C:\Daily Reports\2015\11\[Report ...

**-1**

votes

**0**answers

31 views

### Create CSV from a formated table in Excel using Macro

I need a little help, I have a table in an Excel File, but I need to create differents CSV files according to when a field change in one column.
I need to create a different CSV each time that the ...

**0**

votes

**1**answer

25 views

### Categorising overall probabilities of jobs in Excel

EDIT
So I've managed to get everything largely working using the SUMIF function as follows.
For <30% and >70%:
=SUMIF(D2:D392,"<30%",E2:E392)
For 30-70%:
...

**1**

vote

**0**answers

30 views

### Programmatically rotate a pie chart to fix the labels

Part 1
I'm looking at a way to automatically rotate (with VBA) a pie chart depending on the data. The data is changed dynamically depending on the month selected. Here is an example of the kind of ...

**0**

votes

**0**answers

23 views

### Excel 2010 - multiple sheet error

I have a problem with multiple sheets: every time I try make a change in more than 1 sheet at a time it doesn't work properly.
The problem: If I select 2 or more sheets and write anything in cell A1 ...

**1**

vote

**1**answer

34 views

### Show only one window in taskbar per file in Excel?

In MS Excel 2010, under Options -> Advanced -> Display, there is a checkbox called "Show all windows in taskbar". As far as I can tell, this options is global for all files opened and local to the ...

**0**

votes

**1**answer

20 views

### Date range for jobs & conversions SUMPRODUCT

I'm trying to run a report within Excel that shows the total number of jobs completed by employees within a date range and also a count of the number of conversions per employee within the same date ...

**0**

votes

**0**answers

10 views

### How can I turn table column headers which hold dates into pivot table and be able to consolidate by fiscal year or quarter

I have a table that we use to standardize client company financial information.
How can I manipulate this table so that I can easily use pivot tables and group the dates by Year or by Quarter?
...

**0**

votes

**2**answers

26 views

### Excel: count unique instances across two columns

I have a spreadsheet that has a column for cell sites and another column for frequency like this:
SITE FREQUENCY
MA1084 687
MA1084 687
MA1084 687
MA1084 4382
MA1084 4382
MA1084 ...

**0**

votes

**0**answers

24 views

### Looking for nearest value in multi-row / multi-column data

For my bachelors-paper I need to look up a value for the area (AE) of a rail given the current it must be withstand (Iz). So, I need to search for the value or the value closest to it. Also I must ...

**-5**

votes

**0**answers

30 views

### How to assign dollar amounts to numerical codes?

I am not even sure Excel can do this but I figured I would try. Maybe someone can suggest a solution. Here is what I am looking to do:
I am a unit based employee and I get paid by codes, each code ...

**0**

votes

**1**answer

16 views

### Searching a column for a set of values and listing missing values

I have a column of 45 spaces that will have letters and numbers. I want to write a formula that will search the column for the values 1-10 and list the values found more than once or not found. I ...

**-1**

votes

**1**answer

26 views

### VBA excel macro to search open workbooks that have a specific text in the Filename

I am a macro novice trying to add macro code that will find workbooks where first 6 characters in the file name are "Custom" and any characters after that are allowable. The code would be added to the ...

**0**

votes

**0**answers

15 views

### Excel 2010 - Find data and linear interpolate

I am looking for away to find where my data crosses a value (0 for example) and interpolate the position of that cross.
The number of rows of data will change, but I only want to calculate it for ...

**0**

votes

**0**answers

19 views

### Excel decimal separator decided by file not system

I am using Excel 2010, english version.
I want to create a file that uses "," delimited decimals instead of ".", that will inherit this setting on other computers too.
If I change Excel Options or ...

**-1**

votes

**0**answers

12 views

### Excel 2010 - Automatically Updating a Cell on with New Input

I'm a little familiar with Excel, not anywhere close to great. Hoping there is an easy solution to my challenge.
Let's say I have 2 sheets, Sheet 1 - Area Sales with a unlimited col (2014 Qtr1, 2014 ...

**1**

vote

**0**answers

30 views

### Can't calculate % of row in Excel Pivot Table

Product types A, B, C, D
Each type has numerous products, say type A has 100 products, type B 50 etc..
product# product type buyer
01 A john
02 A ...

**1**

vote

**1**answer

35 views

### Creating a distribution chart in Excel

I would like to replicate
in Excel, which groups hundreds of occupations under 12 major job categories, and plots them according to number of jobs and probability of computerisation.
I currently ...

**0**

votes

**1**answer

11 views

### View broken path of Excel hyperlink

Editing a working hyperlink shows the destination worksheet selected and the destination cell. However, if that link breaks (eg Sheet name was changed), the Edit Hyperlink window no longer shows where ...

**1**

vote

**1**answer

44 views

### Add Sheet reference to Excel formulas

Is there a way to add sheet references to a range of existing formulas that don't have any sheet references?
Simple Example:
Range A1:A2 of Sheet1
A1: =A1 → =Sheet1!A1
A2: =ROUNDUP(B2,0) → ...

**0**

votes

**2**answers

87 views

### Excel array functions — how to count non-blank cells over multiple worksheets?

I have an Excel workbook with numerous worksheets, some of them containing a numeric value in cell A1:
'DATA_1' 'DATA_2' 'DATA_3'
A A A ...

**0**

votes

**0**answers

40 views

### How to select random people for a match depending on many criteria?

I am stuck in a situation where I need to organize fight match in my school.
I was doing it manually but now thinking to automate it via excel. Automation will reduce my work & also the random ...

**2**

votes

**1**answer

39 views

### Excel 2010: Daylight Savings - calculate # of hours between timestamps for any given day

I have a checksheet which cross-checks various water measurement points, reading the average rates from around thirty different meters out of another system. I've automated this checksheet so a VBA ...

**-2**

votes

**1**answer

30 views

### Copy names from one sheet into another sheet based off date selected

I've created a workbook to track ticket sales for an event we have coming up. The guests have the choice of Thu, Fri, or Sun.
I'd like to pull the names form the list where the days are selected and ...

**0**

votes

**0**answers

17 views

### Excel - referencing tables of varying size

How do you reference a table (in a sheet which some department provides to you every month) which always starts at a specific cell, but can end at different cells, ie has a varying size?

**0**

votes

**0**answers

29 views

### Importing data to Excel does not calculate formulas

I have now read about 40 tips on this subject and it does not appear anybody has a solution other than "click inside the cell and hit enter".
I have to create many spreadsheets with thousands of ...

**0**

votes

**0**answers

14 views

### Can I set number of rows in table by the value of a cell?

Is there a way to change size of a table (created through ctrl+t), by typing the number of rows in some cell? If the table has formulas they should be copied to new rows too.
For example I have a ...

**0**

votes

**0**answers

24 views

### Pasting Paragraphs into Excel cells with Automatic HTML line breaks

Hello All Excel masters,
Using Microsoft Excel
I'm Working with Magento & creating large product lists in a .CSV format.
The Problem I'm having is when I Paste Ex. paragraph
LEGO movie ...

**1**

vote

**0**answers

30 views

### Excel 2010 R1C1 reference style inexplicably became selected

This really isn't a problem, it's just weird. I opened Excel 2010 at work a few days ago, and noticed that my columns were numbered instead of lettered. A quick Google search found the fix, which ...

**0**

votes

**0**answers

21 views

### Excel dynamic range selection and look up

There is a list of unique identifiers. The list is dynamic (one day it has 7 and another day it has 17).
Based on this list, we download data related to those identifiers in another sheet.
This ...

**1**

vote

**1**answer

22 views

### Need to multiply only certain cells

Here is a screenshot of my spreadsheet:
I am trying to format the "Annual Cost" cell where it will show: Frequency Per Year * The cell that has a value between Linear Feet / Square Feet / Acre * ...

**1**

vote

**1**answer

29 views

### How to “merge” multiple rows in one column while keeping the rest of rows separate? Excel 2010

I have several rows with different data. One of my columns is for names. How can I merge the cells with the same name, so there is only one cell with the name up front, and several rows with the ...

**1**

vote

**2**answers

21 views

### Excel: take horizontal data from table, organize vertically in a different sheet, ignoring blanks

I have a table of vendor contact info organized like:
vendorname | address | city | state | zip | phone | fax | contactperson | phone | email
...and I want to select vendorname from a dropdown menu ...

**0**

votes

**0**answers

33 views

### Excel Highlight cells with matching text when hovering over cell

I have an excel sheet showing a College course progression, When I hover over a cell with a class name in them, I want cells matching the names of the dependent classes to be highlighted, what's going ...

**-1**

votes

**1**answer

30 views

### In Excel is there a way to copy and paste from one column to another when there are filters? [closed]

When there is filter which give discontinued numbered visible rows, Excel usual copy and paste does not work for all visible rows : you have to copy and paste multiple times.
Is there a way to do ...

**0**

votes

**2**answers

41 views

### Spreadsheet hide formula result [closed]

I have the following formula in cell D255.
=$C$3+(D255*$C$2)
I wish to copy this down to D1000, but do not want to show the result until data is entered into the cells between D255 and D1000 ...

**0**

votes

**1**answer

60 views

### EXCEL: How to Search multiple files for value corresponding to text in same row?

I know this is a blatant help me post, but I have been given this task and I don't know how to get it done in time.
I have moderate knowledge of excel, but I dont know any VBA. I have learnt C++ so ...

**0**

votes

**0**answers

11 views

### Excel Adding comments from current worksheet to new imported data that has changed

I import data daily, format it, add notes in multiple columns, and save this. The next day, a new import is run (data will have changed), formatted and saved under a new name. I need to get the ...

**0**

votes

**0**answers

15 views

### Inserting Another Files Information into Excel (last few characters are always changing)

I'm not sure if excel can even do this but I have created a file (Top 3 Sort) and I am working on creating a macro to pull information in from other files and put them into a formula {this part I ...

**3**

votes

**1**answer

37 views

### IF formula in Excel to calculate various outputs, defined by days between 2 dates

I'm trying to write an IF formula to calculate 4 types of data based on 2 dates.
Example:
Cell I4 (Install Start)
Data entered here, eg 20/10/2015
Cell J4 (Install End)
Date entered here, eg ...

**1**

vote

**1**answer

64 views

### How to count number of cells over multiple worksheets whose values are in between a given range?

I have an Excel workbook with numerous worksheets containing data like:
'DATA_1' 'DATA_2' 'DATA_3'
A B A ...

**0**

votes

**1**answer

20 views

### Excel Lookup for work sheet comparison

I have 3 sheets. The first one contains data for Shop A, the second data for Shop B, and the last sheet contains the results.
Sheet A & B: Item Code, Name, Brand,and Stock
I want to compare ...