# Archive by month December

## Add extra column to another table

Hi everyone,   I am not exactly an Excel geek so I could really really use your help. So I have two Excel files, both with 62 columns and 45530 rows. So …

## generate \$150 from random list of numbers

I have 17 zones by which my drivers earn a commission. Example: Zone 1 = \$13.00 this zone’s travel time is 1 hour. Zone 2 = \$14.25 this zone’s …

## If,and,or formula

Bonus will be given to manager and asst manager whose basic + da exceed \$32000 and for other it will be 1500   By: Kiran

## how to reformat a date

is there a formula that will convert the following date as shown? From 3/3/17 To 03/03/2017 By:

## referring to another cell

I am dragging down a row formula in excel that is referring to another cell. However as I drag the formula down it changes the referred values to the cell …

## A formula to create a sliding scale for calculating markup percentages against product cost.

In Excel, I am looking for a formula to apply a sliding scale price markup percentage. The size of the percentage markup would decrease as cost increases.The …

## Calculation

Create an excel sheet considering 10 users (5 experts and 5 normal users) and 10 restaurants of city (London) of type Romantic. Now, provide us an algorithm …

## Create a pie in pie chart

I need to create a pie in pie chart with the following data A. Organized Retail  8% Unorganized Retail 92%   B. For Organized Retail APPAREL 33 FOOD …

## Excel decimal and forula

Hi,  I have Excel 2010 and my worksheets use the comma as adecimal seperator, which is very annoying. I have tried changing this in the Advanced settings, …

## Record Date & Time on cell value change

Dear all Kindly solve one issue.   My requirement is that when user enter some value in a10 cell, & z10 = a10, now if user assigns some value in a10 …

## Automated Email Query

Hi All, I want to create an excel sheet in which email should be shooted every morning corresponding to the date column, For ex if the entry is made for …

## Copying rows containing cells exceeding certain values into a new sheet

I am using Excel 2016. I have a worksheet consisting of a series of data formatted into 12 columns and infinite amount of rows. I have a Macro pulling this …

## Formulae help

I need to use appropriate function or  functions to compare column G to B10 and return “Over budget” message whenever the results are +5% and …

## Need To Change date Formate

Dear Sir,   i want to change date format YYYYMMDD To YYYYMMWW. is this possible.   Regards, Aghariya By:

## advanced conditional color formatting

I have 2 columns and 7 rows with the following letters, one on each row column 1 has a,a,a,b,b,c,d and column 2 y,x,z,y,z,x,w Basicaly what we need to do is …

## When 4 criterias match extract the data in the first Column

I have a table with 5 Columns in Sheet one ( Lets say Column A – E ) Following are the headings  & Few Rows     A      …

## How to sum Count A Values

My Total is a CountA Formula   How do I sum CountA Results?   Or is there a better Formula to start with instead of CountA? Mary  …

## unsure of what function to use

In cell G22, type in Rent or Buy. (either word) In cell B10, create a formula that will display the total facility expenses depending on whether the club …

## By Vlookup

Please find following figures, As I have only Fig.1 & Fig.2 after that I have combined Fig.1 & Fig.2 which shows in Fig.3. By using Sumif Formula I …

## Excel Formula for calculating a grade

I want to create a cel that calculates a “participation” grade for a 2 hr class. I have a group of cells to record atendance: AO:BN. If the student …

## Summary and Percentage

Can you please advise how to calculate average of days late and percentage of on time deliveries?   Days late On time deliveries 0 1 0 1 1 0 2 0 2 0 0 1 …

## Userform; User to complete all visible fields

I have a userform that depends on various data types. When the user opens the form, all fields are hidden and based on the selection from drop down cetain …

## EB

I’m using Excel 2016 using Data Modeling. I have one tab that has the data using a Range. There is one Table in th eDta Model. Everything works but when …

## Format issues when copy picture and text from Excel to outlook

I have formatting issues when i copy a Row from Excel to Outlook. In Excel i have lot of data where i have 1 Row which contains 2 columns. 1st column contains …

## Breakdown of shift hours worked

Hey guys, I hope someone can help me with this. I’m trying to create a timetable to monitor my hours and what shift brackets they fall into but …

## Userform to parse information in excel table

Hello, I used to be semi profecient at VBA but haven’t touched it in quiet some time. I am hoping to do something quickly as I do not believe it is very …

## Excel Formulae

Would need a formulae to calculate Due Date including Week-end and Excluding Holidays only   Input = Start Date and No. of Days   Output = Due Date …

## Excel Formula need to extract the number in a position

Latency:   0   1   0   1   1   0   0 277 290 267 212 214   0 290    …

## Student

If I delete a template what happens to the workbooks based on that template? By:

## General Manager

After creating a pivot table  – say the pivot calculates the average of A (from the database) and the average of B (from the same database). I now …

## Business Analyst

I am trying to lookup data from one tab in a spreadsheet to another tab.  I need information from D6 and H6 to find the weight that I need.  I tried …

## Use macro to automatically copy/paste NEW data to another workbook?

Hi, I am trying to create a macro to copy and paste any new information into another workbook. The spreadsheet gets updated monthly, so each month I have to go …

## Export PDF to same directory with specific name (in cell) AND save as xlsm with same name as PDF

Hi, I have a very specific question. For a file containing price offers I am looking for some help. For your information: Cell B6 contains the company name …

## a simple excel formula please ..

Hello  Please could somebody show me how to set up a simple formula to add 5 to each number in a column? So first column has 15, next is 20, 25 etc Many …

## Count if X is used in 2 coumns

Hello,   I have two columns column E and column F. some cells have a X and some dont. I’ve tried using countif but it counts the rows that have …

## Time formula

I’m trying to create a formula for time but having no success.   I’m trying to create a sheet where meal breaks are automaticvally deducted …

## Adding Hours for Tech Support

I am currently having to track the time all my support members are spending on the phone. We are having them submit a form which then in return is …

## Loop help

Hi all, I’ve been looking to send out reminders automatically from my Action Tracker spreadsheet to all actionees. I assumed this would be a common use …

## How to print below alphabets from formulaes

Hello guys i need your help, according to my attendence policy, a deduction shall be made for employee’s late of work. its an accumulative pointing …