# Archive by category Excel 2007 Help

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

## Date-Format correction in

Hi, I have applied “&” formula in my excel sheet to combine multiple values in one single cell. But the date-format is showing wrong into the …

## Trend Percentage

I am trying to calculate the percentage difference year over year for inventory adjustments Lets say FY17 you adjusted 400.00 up and in FY18 you adjusted -300 …

## Using Averageif formulae

Want to use averageif to calculate an average if a student has SEN.  This I can do.  If a class has not SEN students, I dont want it ot return to …

## Please help me with calculating the crossing point of the regression lines of tw part of one graph, the X axis is column B and Y axis is column D, and please formta the axis to logaritm, I want to crossing point of the regression lines for the early flat part and non linear dropping part of the graph

A B C D E F G 1|1 0.1 -0.00392 -25.53 25.69 12.79 10.4 1|2 0.1272 -0.00124 -102.4 25.69 23.53 21.14 1|3 0.1619 -0.00038 -422.1 25.69 34.27 31.88 1|4 …

## Pulling data from multiple sheets to a master but more difficult than that

OK so i work for a casino and I need to update a workbook with multiple sheet. The master is stripped down to SSN and then the deductions associated with that …

## Unable to record macros

I have two Excel workbooks created in MS Office Excel 2007 home edition with perfectly functioning macros which are stored in the respective workbooks.  …

## nest if statement excel

i have column A1 to A10  and another column B1 to B10   In my Column C1 to C10 the value is from any One of A1-A10 ( that is customer enter) If C1 = …

## excel formula

Helo, i am a document controller, i am the person who taking care of complete documents master file. my doubt is, in my log sheet importantly two columns. 1. …

## How to sum quantity for a particular date from a data of entire month

hi, i have a data of entire month which shows each date wise output quantity. Each date have more than 100 rows. i need sum of output quantity of each date …

## Data analisis help

Hi , I have the folowing information.  Customers names, visit history, and how much they spent. I need to create a visual chart or graph that can be …

## Consolidating text data by reference number

Hi,   I have a spreadsheet with 35000 lines. Each line contains a customer name and the archive box code where their information is stored. I need to …

## EXCEL FORMULA

i Have creat a list of comapany name list there address and GST Numbers, Do a data validation its works but it can happed that the i m select comapny list bye …

## Compare text using if function in Excel 2007

I have two cells and wish to dislpay diferent text in onem dependant upon the text in the other. Cell A1 usually has “result” dosplayed and cell A2 …

## Tab bing issues on secured worksheet

Used to be able to tab through a locked worksheet to locate unlocked cells to quickly enter data into those unlocked cells. Now  my worksheet will go …

## Nesting

I woiuld like to find all the students in a particular prgram sorted by subject code.  If there is only one subject code per program, my formula works, I …

## Want to split the data in one row to different rows.

I have an Excel bulk data, some of the rows including double data, I want to split that data into separate rows. By: Narasimha

## Excel page subtotak

I have an excel sheet with 1500 records. I want to insert pagewise subtotals of some columns with numerical data and print. Please help By:

## worker

I have a spread sheet with data. Column A is date stamped for a month. Columns c-I have readings. What I need is a formula to capture the individual day in …

## Conditional Formatting

I have an excel spreadsheet that takes information from a main sheet and uses formulas to break it down into smaller sheets. I also need it to format the …

## Procedure on Enter pressed

I have set up a Conversion sheet(mac excel 2007) and would like the cell selection to go to the “RESULTS” column once the user has entered data in …

## Conditional Summations

Hi,  I have a spread sheet where we enter expenses in a column, in a corresponding column, we have who paid it.  I want to show sum values based on …

## Excel data

Hi Can you please help me as i have made a patients data mentioning the disease now i want the disease data to change in icd codes which i have in other excel …

## Scenario Manager in Excel

kindly tell me about the Protection section which include (Protection Changes & Hide) in Scenario Manger in MS Excel. Thanks By:

## finding duplicate values from two sheets…..

I have two sheets in EXCEL data like these…. sheet1 : 2000, 3000, 4500, 300, 2000, 3000        sheet2: 300, 2000, 3000, …

## Index match with date range and condition

From 1-Oct-18   To 4-Oct-18       Date Product Sale 1-Oct-18 coffee 100 1-Oct-18 tea 55 1-Oct-18 milk 75 2-Oct-18 tea 25 2-Oct-18 …

## how to add cell’s values of significant parameters repeating many times in large excel

name  Rs.     a 805   how to get a’s sum in a single row  a 1449     a 384     b 352   how to get …

## Complex IF THEN question

Hello,  I have created an excel spreadsheet and need help creating the proper formula to do the following: Column K currently has the following formula …

## Combining 2 sheets

I have 2 separate non-linked spreadsheets. Each one of them has one row which called OrderID. The rest of the columns are different in each spreadsheet. …

## Split cell

I have one row in my spreadsheet for First and Surname of my customers. How can I split this row into 2 seperate rows – First Name and Surname. Obviously …

## particular balance cell should be automatically colored when i debit an amount.

debit credit balance 500 500 200 300 700 1000 500 500 whenever i will enter any debit amount it should be colored in red both debit and credit column and …

## Mr.

I wish to calculate a percentage of a negative number (-\$50) say 5% and have it return a positive result. By:

## I need an empty cell instead of date

Hi, I’ve spent all day trying to figure this out but nothing seemed to be working. Basically I have 2 lists. In the first list I have a cell with a date …

## Conditional formatting rules

Hi i’m wondering if and how i can apply the same conditional formatting for multiple words. I need it for the work schedule where multiple people are …

## Claim Allocation

I want excel formula to equally allocate claim to assessor as per list. By:

## notepad to excel keeping same format

so i have a text file saved and i would like to import it to an empty excel spreadsheet and i was able to get that done but when i import it, the format doesnt …

## Data scientist

I have column in excel where in i have values like given below in each row of that column:   …

## VBA Loop through excel Cells from Word Document and change text in Word Document

Hi I am Using This Macro I want to Loop through a Colomn of Sheet 2 of Excel Workbook Marketing.xls From C2 to C67 and I want to change the word in “ABC …

## excel file

I HAVE AN EXCEL FILE. IN THIS EXCEL FILE VBA AND MACRO IS PROTECTED.WHEN I OPEN THIS FILE ANOTHER SYSTEM THISA FILE NOT OPEN. THIS FILE SHOWS “PLEASE …

## Shared Workbook

I have a spreadsheet (Microsoft Excel 2007) used by several employees saved to a shared drive.  I would like to set it up so multiple users can open, …