# Archive by month June

## Calculating amount of work done by different people

Hello. Could you please advise on a formula i could use to determine the amount of work completed by each of my staff over a month.    The table i …

## Table that changes size based on values

Hello, I am working on a project and have encountered a problem that I cannot find an answer for online. I have multiple pages of customer account numbers and …

## Sum of different columns with a multiplying based on condition

Hello,  I need to sum different columns to calculate a share ratio.  When  i use “SUMIFS” i can calculate the potentials for A and …

## Convert single column data into rows based on color

Current Table 2259 Gautam Kasliwal Central Reporting Subscriber Community Afford Immed Access Internal Auditor RPM – Conventional Temp Setup 2260 Gautam1 …

## Formula

Hello I need some help with a formula   I had it once but it got deleted. Here is the run down. I have a set of ranges that I want to make equal different …

## putting date and text in one cell?

Hi guys We have a spreadsheet in work that pulls data uaing microsoft dynamics (sort of what is on the system we have is brought across to the …

## Baz13000

Hi, thank you very much for sharing. I have a Q, how can I change the color of one series only, a group of bars only ? How can I select multi bars ? Excel …

## FIND A CELL BASED ON ANOTHER CELL

Hello, I am doing an excel analysis in which we the four quarters of 5 years. in the row underneath it, we have claim numbers and next to it we have how much …

## FIND A CELL BASED ON ANOTHER CELL

Hello, I am doing an excel analysis in which we the four quarters of 5 years. in the row underneath it, we have claim numbers and next to it we have how much …

## Cheap MLB Jerseys

Brand new Self-esteem: Because Anandgram develops, this provides it’s occupants the actual feeling associated with self-esteem they was missing within …

## If a Cell Contains a Certain Text Then Put a Specific Text in Another if even spelling not exactly match

Hello Team,     Please help me, If a Cell Contains a Certain Text Then Put a Specific Text in Another cell if even spelling isnot matching exactly. …

## HELP

Is it possible to make it so when you type a specific number another specific number will pop up in a specified column? and if possible how?   By:

## Advanced Match and Mark duplicates help needed

I have 2 customer csv files.   (A) 1 has all of customer data and is 50k records. (B) 1 has phone numbers only and has 2k records.   I want to mark …

## IF-Statement / V Lookup

Not sure how to write an If statement/V lookup or other for the following example;   Monday, White, Yes = -20 Monday, Black, No = -10 Tuesday, Blue, Yes = …

## Make A software

i want to creat software on ms excel 2007 for count aqare foot area for exp one aluminium window size 4*4, now i want count 4*4 section name, feet and price …

## Support Analyst

Hi, I’m currently learning more about Excel formula so that I am better at it for my job and in general. My question is, what would the formula look like …

## Excel vba about string array

‘ Returns String array of all heights to be used, ‘   within the range [MinHt, MaxHt], spaced apart by Interval Function LoadHeights(MinHt As …

I am a Police Detective and while I am not at all familiar with excel, I use it every day to manage and track cases I am currently working.  I …

## Require Help Distributing Data

To give you some context, there is a survey that I want to roll-out across all my customers. If I ask my entire sales team to go to their customers and get the …

## Returns to previous text

Folks, In a spreadsheet, one in one line of cells, in one particular cell, we wanted to change the color of one thing, the listing of \$5.00.  We wanted to …

## aligning two columns

Hi i can’t find a tutorial for this, I am having a problem aligning matching names from column A to column B with 12 columns of data from column B.  …

## Tracking specific data in cells.

How can you track a specific number in cells from multiple worksheets? I want to track the number of times 100% shows up in a cell, and on which date. By: Me

## Lookup function

Hi there, How can I write the Lookup function on Excel 2010 to return the result if I have 3 columns, A, B, and C, column A has unsorted data, Column B has …

## Google drive account to excel

Is it possible to have a google drive account with an excel sheet that has been opened with google sheets to connect to an excel workbook. What im trying to do …

## Skip columns when dragging a formula

Hi. let’s say i have 2 sheets.The first one is CE and the second is 1E. In CE cell E9 i have the number 1000, in F9 i have the number 8 and in G9 i have …

## Excel formula

Hi, I’m looking for a formula that will work out if the start and finish times in cell b5 and b6 meet the following requiremnts, if so put the value of …

## Multiple lookup populating a list

How do I program Excel 15.35 (MAC version) to provide the following: I have a table table { }td { padding: 0px; color: windowtext; font-size: 11pt; …

## Run-Time error ‘1004’: AutoFill Method of range class Failed

Hi, I am getting the above error message with the below code in VBA. background; I have 4 workheets on the same workbook and i am trying to repeat the process …

## Row height

I have 20 rows with content .I set the first row width on my own need.I need to set all rows as the same row height . By:

## Formulas not calculating

Using Excel 2008. We have set a formula and when copying to other cells, the formula doesn’t work. It doesn’t transpose across the other cells. …

## SUMPRODUCT and COUNTIFS Help

I’m looking to get assistance on how to count the number of employees who servered customers during each hour, of each day. I have the employee name, …

## The word “figure” is being pasted over

Hello,   I am working on excel 2016 and I have been trying to copy cells from excel to word 2016 by using the paste special function:  paste …

## Problem in opening an Excel 13 Macro Enabled Workbook in Excel 10

I have designed a Macro Enabled workbook in Excel 13. The workbook contains Userforms, Commandbuttons, Checkboxes and other macro functionalities. These are …

## I think I Need an ANDIF / Match formula, but not sure

Hi All, thanks so much for taking the time to read this, hopefully I am clear in what I am asking and doing everything correct according to the forum …

## Making Binder tabs from text and numbers

Hello All; Spread sheet with 3 columns Column A is text Column B is numbers Column C is a formula to make binder labels Label is the column A text + space + …

## Help with a formula

I have Excel 2016 running on Windows 10 I have searched and can’t find the answer to this problem.  On a quarterly basis I add a new number to the …

## Marketing Intelligence

I’m doing a VLOOKUP to find a value. On the following column, I need to find the value immediately below the one that VLOOKUP got. How would I go about …

## VBA – split reports based on column values

Hi, I’m new to this site so I hope I can articulate this appropriately. I have some familiarity with VBA and want to do more, however I’m running …