# Archive by month June

## Calculating no. of calls per person per month

Hi All,   I’d appreciate your help on the below:   Outline: –       3 people (Amy, Harry, Sophie) …

## Sum specific cells , divide cells that have numerical data, not 0, X by 52

I wish to sum the following data. Each “E” cell refers to a weeks income.   …

## I want to type initials in a cell and have it generate the first name in a different cell, from a custom list

I hope the title makes sense, I don’t know enough about Excel to even be sure I’m phrasing it right. I’ve had difficulty searching because …

## Analyst

I have an external data source which I connected to using Excel. I used MS Query to make several pivot tables. However each pivot table is a connection. Can I …

## Cell limit exceeded onto new/next cell

Hello, i’m using excell 2013 if it makes a difference. I could find a way around not being able to do this but here is what i was trying/hoping to …

## Automatically Fill out the cell.

Dear Sir/Madam, I have encounter a problem using the Excel, I have given an assignment to do, I have been asked to use the Excel to help the assembler of the …

## Show data as a score in pivot table

Hi, I am using a pivot table to summarize the results I get while playing matches of a game. My input is 1 line per match and I have a win column, I put when I …

## Excel Problem

I have 2 columns both with text.  In column 1 each cell has the same 5 text options and in the other column each cell has 4 text options. There are 20 …

## Excel functions help

How can you combine an iferror formula with an roundup formula (but I need to round up 2 places)? Is there a way you can combine them? Can you show me on my …

## IF statement with 3 possible outcomes

I am struggling with an if and statement. I have 3 possible outcomes (B1000, B2000, B3000) based on certain critera. Want answer in column A, based on …

## Combine items from two pivot tables into the third table

Dear all, I am currently having a problem combining information from two tables. I will try to explain what exaclty I am trying to do here and I hope someone …

## Time Sheet Help

Hi,   I am putting togethere a time sheet and i want to include exception codes. Specifically staff can only work between 07:00 and 19:00 and they can …

## How to “Autofill” on different column “B” UPON my selection on column “A”?

Dear all,   Assuming Column A has been set with Data Validation function which provides me the convenience of having a set of datas to select, i wish …

## Matching cells that contain a text that is found within a certain criteria

So I have a data set of lets say (for confidential purposes) doctor offices, the set looks like this; A B C D 1 Office Info 1 info 2 District Manager (DM) 2 …

## Linking excel to website data and setting a date threshold

I am currently running a few ad manager accounts on Facebook, I know how to link the information to excel, however, as I have to do weekly updates, how do I …

## Odometer to date and time.

Sorry if this confuses you but i will do my best to lay it out there.  At work we use a chronometer or odmeter to record the hours the machine is running. …

Politics of Russia We n we publish all of them hot and topical news USA, estimates experts. All bad on earth happens with the quiet tacit consent of the …

## COMBINE FORMULES

I want to combine sum and multiplication in one cell, But it doesn’t work, for example:   =(A1*B1)+(A2*B2)+…(A20*B20) By:

## PictureCalling

i have pictures of Animals in Column B, and  their Names  in Column C. now i want to Show the Picture in Cell G1 when i Type Name from (Column C) in …

## What is the way to approach the following what-if analysis in Excel

Imagine a league-based tournament. How can I perform the following analysis: What would happen had a particular team had not played in the tournament? (That …

## Categorizing number ranges in Excel

I need a cell to show the following= 1= A>B 2= A is between 0.833B – 1.000B 3= A is between 0.667B – 0.833B 4 = A<0.667B Thanks in …

## Creating X number of groups from a list that sum to X number

Hi,   I have a list of countries in A1 with their respective points in A2. Note that some of the point values in A2 repeat.  Ex: Eastern United …

## Macro for consolidate multiple workbooks in one worksheet

hello all, thanks in advance for answering this problem.. now come to problem  i have to consolidate excel worbooks in one new master excel worksheet (in …

## Print out from drop down list

I have made drop down list and to print out data I hv to select one by one and print each page separately. Is there any other way to print all in once ? Please …

## self

for example,i sold house for 100/- [70/- for land &30/- for construction].now when i get 60/- its go for land ,then i get 40/-,,,then i want 10/- is go for …

## Formula to analyze columns that have some of the same data.

I have data within an excel spreadsheet where the plant/mat field repeats, however the purchase order date and net order price do not repeat.   I …

## find, count, return title

I have a timetable for my school.  In the first column are the staff.  Across the rows are the days of the week.  The content of the table is …

## Using a hyperlink as table in vlookup

Hi! I trying to construct a vlookup that gets values from another worksheet in the same workbook. The problem is I will have a different worksheet for every …

## Column head applied to each row

My question is: how to apply the column heading to multiple rows in one shot? eg. New York  -> This is the column heading Jake Eric Richard what I want …

## Excel and online audios

Hello, Say I had 10 audio’s in my website. Each can be accessed with their own URLs. I want excel to play those audio’s on link click of particular audio …

## finding unique addresses in a list of column A, based on weekday criteria in column B

I have a list of a few hundred addresses and have a day of the week matched with those days. I need to know how many of the weekdays have a unique address …

## KeepText Only (T) message when pasting data

Hi, When I copy database results into excel I get the message ‘ KeepText Only (T)’ when trying to past into 1A and only get the headings …

## Query regarding Relative cell reference

I have 1 question I used formula in Cell A1 in sheet 1 is =sheet2!B1 But when copy this formula to Cell A15 in sheet1 , it should return to =Sheet2!B2 not …

## Macro/Looping in VBA ?!

In one tab I have information, where I have made it output the information on a second tab (It’s more in depth than this but I tried making this as …

## Excel date conversion

I am not sure if this is possible – I want to know if there is an easy way to convert a date entered for example  June 16/2016 @ 1335 hrs to …

## jason

I am looking for help with a macro.  I have written to make a new day for our log sheets.  the macro works fine sets up a new day saves the old day …

## Copying Cell Reference Pattern Sideways

Hi,   I am faced with a problem, where I have a data set in a sheet where for each date there are three columns – Manager, Time Scheduled & Time …

## IF OR query (or VLOOKUP?) inside an Index-Match

Hey   First time poster so hope i’m doing this right! I’m new to excel formulas and apst 2 days have learnt a lot! I’ve got the forumla …

## Import XML to new page does not work, but to same page it does. Why?

Hi and thanks for having a look at my issue. I use Excel 2007. I am importing xml from a webpage using get external data > from other sources > from xml …