# Archive by category Excel 2010 Help

Excel 2010 Help. Free Excel help for formulas, functions, macros, spreadsheets and VBA.

## Hi!

1     1| 2     1|2| 3     1|2|3| 4       5       6       7       8 …

## TRANSPOSE-type question

I have a spreadsheet with 1000 rows that look like this: LNAME FNAME YEAR DONATION Adams John 1995 100Adams John 1996 150Smith Bob 1995 100Smith Bob 1997 …

## formula

To make along story short, in my excel program, I have a formula that reads =sum(24+a1-b1)/2. Up until yesterday, when I changed the value of either a1 or b1, …

## Calculating a sum of certain data based on other dats

I am trying to see how a mailing affects the response rate of customers over the next week after it is sent. I want to do some sort of SUM IF fucntion but I …

## If Blank Calculate, if Not Blank Calculate

I’m trying to calculate days between dates.  If Column M is blank, calculate days between Column N minus Column J.  If Column M is not …

## Msg Box -VBA code

I have 2 different worksheets: ·         worksheet-1 ·         …

## Finance manager

We have a workbook that HR will add certain deductionns or reimburesments that are owed to certain employees.  Example below HR will add \$10 next to …

## Excel “Save As” Text delimited” saving as PDF

When I go to save and excel sheet as text, I used the “Save As – Text delimited” and it is converting it to a PDF. I am using Excel 2016. I …

## Histogram not showing properly

I am trying to create a histogram with the data I have, but no matter how I edit it, it is not displaying correctly. Herei is my data: Cell boundaries Cell …

## change date

hi Is there any function that records the time whenever it changes in the amount of a cell associated with it? By:

## Sumproduct with Year

Hi! Sumproduct returns a blank cell when I use following formula in the year column =TEXT(A1,”YYYY”) It DOES recognise =TEXT(A1,”MMMM”) …

## excel doubt

hello sir, i need to transfer data to other spreadsheet like name address city number email favourate colour etc now i want to create separate workbook for …

## Copying the sorted data and it’s relevant columns together in new columns

Hi everyone. Consider there are 3 columns. I want to sort the 3rd column, in a way that the sorted data of the 3rd column are now in the 4th column. I do this …

## Duplication in Multiple Sheets

Hello everyone, Here is my problem in short sentenses: – I am trying to find dublicates through 10 or more sheets on excel. – I want that if …

## PDF Combine

I pulled out a code from the net for Combining pdf files in a folder using excel macro and (Acrobat) my only problem is that for every folder the naming …

## vba edit help

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ‘Updateby Extendoffice 20160725 Cancel = True …

## Excel MailMerge questions

I have two questions that I am hoping someone can help me with.  I can code ActiveDocument.MailMerge.Fields.Add Range:=Selection.Range, …

## Trying to create page to automatically populate and calculate reaction time by subtracting time

The last line cel derives its information from another pre-populated cel using the = sign. Reaction time is 1st box minus last line. The 1st box is filled in …

## Trying to create page to automatically populate and calculate reaction time by subtracting time

Last Line 1st Box Reaction Time 6/1/2018 7:30 6/1/2018 7:58 0:28 6/5/2018 11:00 6/5/2018 11:56 0:56 6/6/2018 9:30 6/6/2018 10:45 1:15 6/6/2018 16:55 6/6/2018 …

## Consolidate data from many sheets

Hi I’ve got about 100 worksheets that’s been saved over the last 8 years containing a list (data dump) of all employees in the company. Each file …

## Adding a Pivot calulation field – Subtracting a Max column from a Sum column

Hi all I am looking to subtract one pivot table column from another, but the issue I currently have is that one columns value field must be the SUM of all the …

## Excel

Hello,   I’d need help for Excel as I am organising an schedule on excel and I wanted to categorize the different shifts. So some of my people have …

## Share Access

I was wondering if there was a way for multiple people to aceess a spreadsheet at one time. Say 3 users have a password to edit the spreadsheet and 5 other …

## Dr.

How can I count the number of sequence or spell of data in a column ?? By:

## TOP 10

my list contains an item(METHANOL,ADIPIC ACID) theN below it name of suppliers that provide the item now how can i find the top 10 suppliers for particular …

## Excel Help

Ive created a spreadsheet for my towing business. The rows are dedicated to date specific transactions where the colomns are used for description of …

## Filename in Chart Series Values

Hello I have a Defined Name for a calcualtion that works out the set of values I need for a series to use in a graph. So… I need to use this defined name …

## Daily Sales target conditional formula

Hello. I run a small delivery firm with a team of 13 people. Our daily delivery target is 450 parcels per day. So I wanted to prepare an excel file where a …

I am trying to create a spreadsheet in excel that will give me the three highest ranked fantasy football players for each position left available in my …

## Sumifs with date range

trying to do a sum ifs with a date condition. running into a problem. Could you please help me combine the below???? Thanks ðŸ™‚   Sumifs with date …

## copy paste a lsit of data into cells without having to copy every time.

I want to know if it’s possible to do the following. I have a list of app. 40 names. I want to be able to copy them on another sheet without using copy …

## Values wanted from various worksheets

My workbook contains a worksheet for every month of the year plus one more as a precis sheet. In each monthly worksheet a person (not me) makes entries of …

## Count specific to month

Hi I need help with excel  In sheet 1 I have: Column B has dates, Column C drop down list FAI, LTI,MTI,and RO. In sheet 2 I want a formula to count all …

## General Manager

In Sheet 3 (Services), Column D (Code), there is a alphanumerical code. The same code is mirrored in Sheet 6 (ServiceEquipmentLinks), Column B (Service.Code). …

## Vlookup or Hlookup attempting to count variances at a bar.

Hello,  I am a bar manager at the Ameristar casino in Blackhawk Colorado. Every night we get a variance report in excel from our finance team about how …

## Formula help

I am looking for how I would find the difference between two sets of numbers with one common factor. Any help is greatly appreciated!! By: LaTrisha

## excel formula

if cell A1 contain some name cell B1 contain values of formula and if b1 becames 0 than it should automatically became red till this i have use command …

## Consultant

I am attempting to read from one column based on a criteria, and then reference another column that can then determine the median of those in the other coulmn …

## Dependent Drop downs

I want to have a dependent drop down list of Divisions and Business units. The menu items are in Sheet 1 and working sheet is 2 Divisions are HDC, Comm Ops, …