Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

1
vote
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
0answers
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
3answers
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
1answer
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
1answer
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
2answers
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
0answers
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
2answers
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
1answer
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
2answers
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
0answers
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
1answer
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
2answers
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
2answers
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
0answers
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
1answer
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
0answers
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
2answers
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
3answers
73 views

How to divide duplicate rows in excel?

Say I have: ============== | a | | a | | a | | a | | b | | b | | b | | b | | b | | b | | ...
0
votes
0answers
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
1answer
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
2answers
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
3answers
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
1answer
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 ...