# Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

**1**

vote

**1**answer

29 views

### Excel MIN with nested IF statement — Trying to ID a date closest to 30 days after a date

I have 16K plus records with an Auction Date. I need to find the date and amount that is closest to the Auction Date BUT more than 30 days later.
I have calculated a row that shows the difference ...

**0**

votes

**1**answer

17 views

### How to prevent #REF errors appearing in formulas when referenced workbook is opened

In my workbook A, I have formulas that reference my workbook B. Once I open workbook B and enable editing, all of the formulas in workbook A show workbook B's worksheet name as #REF (but the filepath ...

**1**

vote

**2**answers

19 views

### Deleting numbers before a letter without any spaces

I would like to remove the numbers, including the colon, from each row.
Example data:
22:18:01(165):access-list OUTSIDE_IN extended permit deny IP
I tried using the formula
=RIGHT(A2,LEN(A2)-FIND("...

**0**

votes

**0**answers

4 views

### Merging duplicate rows Excel but keep Max / Min dates of associated fields

I need to merge duplicate rows based on Name and Arrival Date/time but keep
Min(Start Date/time) and Max(End Date/time) of associated rows in final row.
My Spreadsheet

**-1**

votes

**1**answer

40 views

### How to sync same excel workbook between 2 computers on the same network

I need some help with this please.
I have an input workbook where product data is entered, and an output workbook(Report) where this said data is copied into a single line using vba macros.
The ...

**-1**

votes

**1**answer

26 views

### Excel check formula, return specific text on error

I have an excel sheet that uses an array to return the most common text found, and then the result is copied to a separate sheet so we can view the most common text per month of the year. This sheet ...

**0**

votes

**0**answers

16 views

### Excel - How do I change the color of a data bar based on its value

I have a column in excel that has been formatted to display a progress bar based on the value in the cell 0 - 100.
I did this by going to:
Home > Conditional formatting > Data bars > More Rules:
...

**1**

vote

**1**answer

63 views

### How to filter data in excel and use it in calculations?

So the setup I would like is:
Sheet 1: the data (aka database)
Sheet 2: where we have the criteria for the filtering and also run various formulas/calculations on the returned filtered results
Sheet ...

**0**

votes

**2**answers

26 views

### Excel offset from two different workbook, create a copy of one without affecting the other

I am using two different workbooks the first one [Excel Data only] created as a databse and the second one [Invoice Template] created to create an invoice.
When creating an invoice i am using offset ...

**0**

votes

**0**answers

5 views

### Mail Merge pulling ALL records instead of specific database

I created 3 databases in excel. They are in different workbooks.
When I select the workbook spreadsheet I want, ALL of the records in the 3 separate worksheets merge and I get 186 records instead of ...

**2**

votes

**1**answer

38 views

### Excel 2010 - Auto populating a sheet based on data from another sheet in the workbook

Thanks for taking the time to view my question!
I'm pretty new to Excel, trying to teach myself the basics to get stuff done at work. I've been asked to create a tracking spreadsheet for the ...

**0**

votes

**1**answer

28 views

### EXCEL Cell content based on content in other cell (same row)

I've got a sheet of about 500 entries. This sheet contains 4-letter words in one column, a corresponding number to this row, and a corresponding gender. I need to make a function that finds all rows ...

**-1**

votes

**0**answers

29 views

### VBA to copy and paste a formula on a set number of rows [on hold]

I'm trying to write a VBA code to copy and paste a formula on a set number of rows, but to move columns every time I run the macro.
Here is what I've done so far, I basically need this to be ...

**0**

votes

**3**answers

118 views

### Excel Formula to Select only items from a list which are within a limit based on selected criteria

We are working with a table of hundreds of projects, with a total value well above our budget. In order to prioritise the projects, we have decided to select the oldest projects first, selecting all ...

**1**

vote

**1**answer

72 views

### Trying to export single column's data from large CSV file

Problem: I am trying to export a single column of a .CSV file that is 7 gigs in size (large enough that I can't open the entire file in excel... or most text editors for that matter) to a smaller file ...

**0**

votes

**1**answer

38 views

### Finding the Min/Max of subsets of data without the use of an Array/VBA

I have two columns of data, say something like Fruit and Weight. I need to parse this data to find the minimum value within each individual subset - the smallest weight of all apples listed, for ...

**1**

vote

**2**answers

41 views

### Excel 2013: VBA to copy formula from one cell to the next

I need to copy a formula from Cell A3 to B3 in Excel, using a button to run below macro:
Sub Copy()
Range("A3").Select
ActiveCell.Offset(0, 1).Formula = ActiveCell.Formula
End Sub
Then with ...

**-1**

votes

**0**answers

19 views

### Excel Array Pulling Duplicates

I am trying to pull rows from another sheet into a different sheet. The criteria that I am looking for is "Open" and "(employee's name)". Both these criterion are going to be constant for all twenty ...

**0**

votes

**2**answers

38 views

### Programmatically count how many times ALL values in a column appears from an excel document

I Understand there are many similar questions, but i cant find the answer anywhere.
My problem is that have 40.000 rows in an excel document, and i need to count how many times each requester appears ...

**0**

votes

**1**answer

13 views

### Is there a way to link workbook data without getting REF errors when a row is deleted?

I currently have two workbooks, workbook 1 and workbook 2.
Workbook 1 - Sheet 1 is directly linking data to Workbook 2 - sheet 1.
I am linking by inputting the below formula into workbook 2.
='[...

**0**

votes

**0**answers

23 views

### How to split comma-separated values for Pivot Table?

I have data which has the following format:
Electricity
Electricity, Cooling
Electricity, Heat
Electricity, Heat, Cooling
I want to use this data in a Pivot Table so I can count the number of items. ...

**0**

votes

**0**answers

27 views

### Highlight Rows with Multiple Criteria

Need to highlight rows that fall into criteria based on two or more columns:
For example,
I want to highlight rows that say "No" and also have values above $0.00.
BUT
I want to highlight the rows ...

**1**

vote

**2**answers

86 views

### Excel Formula Assistance

this is my first excel post ever so I hope you can help me on this. I'm stuck trying to figure out how to do this formula.
In here, I have Form Input where the start date, end date and outlet are ...

**0**

votes

**1**answer

30 views

### Copying cell from one sheet to another without formatting

probably a simple one to your geniuses however I need a fresh pair of eyes as I've been on this a while and can't see my error. I'm merely wanting to copy the contents of a cell from one cell to ...

**0**

votes

**1**answer

45 views

### Copying only certain cells from a row to another worksheet

I have a workbook that has a large number of sheets designed to help my team manage their workload more efficiently.
When someone requests a job to be done, a row is added to a sheet called 'pending ...

**0**

votes

**1**answer

29 views

### Input data from one workbook form into another workbooks worksheet

What I am trying to achieve:
I have one workbook with an application form to request additional training. A person fills out all the cells on the form and clicks submit.
I then want all the data ...

**1**

vote

**2**answers

59 views

### Separating comma delimited data from one cell to multiple cells when the entry is a live data link

My Excel model imports live data from some trading software. If I insert the following formula, I get the details of current tender offers, which are constantly changing:
=RTD("rit2.rtd",, "...

**1**

vote

**1**answer

36 views

### Excel Subtraction from Baseline

How can I get Excel to subtract the baseline number (first number in the column) and the most recent value entered?
In my first column I will have a baseline number. What I want is for excel to ...

**0**

votes

**1**answer

43 views

### give number value in one cell based on a number being generated from another formula on a separate sheet

Trying to get a specific number to generate when another cell gives a number from a different sheet.
If the below formula gives back the number, different cell on different sheet gets a value.
=IF(...

**0**

votes

**1**answer

72 views

### Copy Data from One Sheet to Another if Criteria Met, Relative Rows

I need to copy data from one worksheet to another based on criteria being met. On Sheet 1 (All Projects), information is collected in columns A - L. If "Project 1" has been selected in column M on ...

**0**

votes

**0**answers

28 views

### How to filter data without moving or collapsing the other rows

Just for example I want to filter only columns A to D by not moving or collapsing column E, meaning datas on Column E remains visible even if I filtered column A or B etc..

**0**

votes

**0**answers

25 views

### Sort Function Treats Headers Inconsistently in Excel

When I select an area of my worksheet and then use the "Sort" function in Excel 2010 (in the "Data" tab), sometimes the row above my selection is treated as a header row, and sometimes the top row of ...

**0**

votes

**1**answer

64 views

### Excel Formula output error

As per below previous question link please find attached , formula is not giving output properly as if i need number inside the bracket only, hope any one can help enter image description here
Split ...

**0**

votes

**2**answers

109 views

### Auto fill letters in Excel 2010

I want to make a list with the letters A...Z. Is it possible to do that with the auto fill feature through drag&drop or auto fill through the menu? For example if I use A, B, C as a "starting list"...

**1**

vote

**1**answer

63 views

### How do I conditionally format all rows in a table, to display a different colour based on a cells value

I have developed a table (as seen below) which is designed to show a persons duties based on priority.
If a person clicks the toggle on/off button, this will toggle colours on the rows of the table, ...

**0**

votes

**2**answers

55 views

### Split data into new column

As per attachment i have column A having name with underscore "_' and bracket " [ " . I need a formula to get answer of column B means I need formula to get id before underscore and inside bracket .
...

**0**

votes

**0**answers

27 views

### Extract distinct row values from a sheet to another sheet based on max dates per unique rows

I want to extract rows based on max date or max B per unique values of col A and col c. Doesn't matter if it is vba or excel formula. Help please.
Old Sheet
New Sheet
[2

**0**

votes

**1**answer

23 views

### Copy data from one sheet's cell to multiple cells in another sheet

I have this database where I store sales. I can find particular sales by filtering. I would like to have a button that then regenerates the sales as "receipts" in another sheet.
This is my code for ...

**0**

votes

**2**answers

68 views

### Excel freezes when running macro

Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range
Dim i As Integer
Set KeyCells = Range("H4:H100")
If Not Application.Intersect(KeyCells, Range(Target.Address)...

**0**

votes

**2**answers

267 views

### How to solve “current printer is unavailable” message on opening workbook?

I have an Excel workbook that, on opening, displays a message "Current printer is unavailable. Select another printer." Followed by a dialogue box with a list of print drivers.
Based on this thread, ...

**0**

votes

**0**answers

18 views

### Calculate multiple worksheets using index match sum

I have a formula that works
=INDEX('[Test.xlsx]Report 1'!F:F,MATCH(B8,'[Test.xlsx]Report 1'!A:A,0))
This will being me back the value 37; in report 1.
-report 1 is a worksheet, and there is 6 in ...

**0**

votes

**1**answer

28 views

### Index match finding the first value only

I have a list of employees with duplicates and each employee has a number which represents the number of sales. I'm trying to use the following formula to extract the highest sale for a given name, ...

**0**

votes

**0**answers

52 views

### Graph and organize multiple categories with multiple data series each

I'm trying to organize and graph data on some cooling devices in a way that's expandable and easy to modify, i.e. graph only certain coolers, manipulate data/add new calculated data as needed.
Here ...

**1**

vote

**2**answers

32 views

### Select next row in Excel?

I've searched everywhere but can't seem to find a proper answer to this. Maybe I'm not using the right terms or something? Or maybe there is no answer...
So as an example, if you select the cell A1 ...

**-1**

votes

**3**answers

73 views

### How to divide duplicate rows in excel?

Say I have:
==============
| a |
| a |
| a |
| a |
| b |
| b |
| b |
| b |
| b |
| b |
| ...

**0**

votes

**0**answers

11 views

### VBA Excel Modeless Userform - unable to interact with another workbook

I have tried a search but I am unsure as to what to search for.
I have a modeless Userform but when I try to manually interact another workbook it doesn't react until I click on the form then the ...

**0**

votes

**1**answer

15 views

### How can I count combinations of text across different columns in Excel 2010?

I have a worksheet in Excel 2010 (see below for sample) where the column headings are: Solicitor, Net Fees, Case Type
I am trying to work out how to count the number of times each case type appears ...

**0**

votes

**2**answers

80 views

### How can I Extract Characters between two words in excel but search from Right to Left

Currently I have this in Cell A1:
"timeZone":"Etc/UTC"},"body":"[~kevin.tom] [~sergio.Melle]
[~seema.item] Was the report delivered to the
client?","updateAuthor":"body":"[~katelyn.robert]\r\n\...

**2**

votes

**3**answers

36 views

### I need an excel formula to tell how many numbers and alphabets are in a cell

Hey Guys I need help sorting series of plate numbers out on excel.
so I have a sample BMA759JA, and I need a formula that tells me how many Alphabets are contained in the cell and how many numbers ...

**0**

votes

**1**answer

25 views

### How to sort based on excel or sheets column data

I have a form that submits to a google sheet with the following columns:
Entry Date, First Name, Last Name, Address, Phone, Email, Member Type, Vote Date, Result
(The 'result' column has three ...