# Archive by month March

## Excel Formula Assistance

I am working with data from a relational database exported to excel. A 6 digit code in one cell will drive what codes go into the other cells. The third, …

## Need formula

I have a column called VISITS, where numbers are from 3,4,6,12.   Now depend on the number I should have these numbers equally distributed in months. …

## Is it possible to create a range of values evenly distributed in rows of column from single value

Hello,    Is it possible to create a range of values evenly distributed in rows of column from single value? For example: from the value of 35, I …

## Transformation of data

How do i get my data from this:       Scott Virgil Penelope  Alan Gordon  Parker  Capital Of United Kingdom  London …

## Conditional Formatting

I have Red in Cell A1 and below values in B1:B4  Red Blue Yellow Green I have used below formula in conditional formatting new rule to …

## search for 0.00 to delete and it deletes 160.00

I created a macro to search for the 0.00 values in a column and then delete the entire row. however any number in the column with 0.00 in it is deleted also. …

I have a list of business addresses. They are listed vertically (name, address, phone number all in their own cell). There are hundreds of them and I need them …

## Trouble with Lookup & If Formulas

Hi, I feel like this is a pretty basic formula, but I can’t seem to find it solved where I’ve looked formulas up.  I’m using Excel 2013. …

## Finding MIN Invoice Number Per Customer

Hi,   I have an Excel file that shows online sales data. There are multiple columns, as you would expect, two of which are Customer ID and Invoice Number. …

## How to combine formula for: If A1=09, THEN B1=18 AND C1=EOL, D1=EOL, E1=E ; Else Misalignment?

How to combine formula for: If A1=09, THEN B1=18 AND C1=EOL, D1=EOL, E1=E ; Else Misalignment? By: Monika

## Macro to populate columns from input boxes putting information in wrong areas

Hello, I have a macro to populate the column data in an autofill.  One column will be for the # of evalution days in a month, the other will be the number …

## Sum multiple columns, one with a variable

Hi I need a formula that will calculate the total of    – all in column C * £35 – all in Column D * £35 – all in Column …

## counting values from 3 columns help!!

Hi i am an excel beginner need help with this formula.I need to calculate values from 2 rows if one of the rows meet the condition. This is what i tryed ,but …

## IF Formula

=IF(AND(OR(C34=1,D34=1,E34=1,F34=1,G34=1)*C35=1),”TRUE”,””) Hello, I have the formula above working but its not quite right. I am …

## Sales Coordinator

I have a phone report that is pulled at the end of each day listing the times of the phone calls and all the phone numbers dialed and incoming calls.  Can …

## Workday data into daily data (known values)

Hi,  I have data for Apple stock prices since 2010. Since there is no trading on weekends or holidays, some of the dates are missing, for …

## can’t sum !!!

02:00 02:00 02:00 02:00 00:45 02:00 02:00 02:00 02:00 02:00 By:

## Lab Assistant

I have few sheets of tables with different categories and formulas.  Lets says Category 1. Latex  (consist of chemical A+B+C)       …

## Cell autofill

I need help with autofill fields in the table. so that from the table that I have previously made with the names of the products and their codes pulls into a …

## Data Attributes in Excel

Hi, I want to ask if there is a way to “tag” cells, rows or culums with attributes, and then reference them in formulas, either on the same sheet …

## Self-Taught & Stumped!

I have created a spreadsheet for work and would like to expand it. Stumped. For my office I must account for each agents’ time on each project everyday. …

## Sum Column Until Condition Is Reached

Hello, I have 3 columns: Column A has categories: Column B has Amounts, and I would like Column C to auto sum every time there is a new category in A.  So …

## if, vlook up iwth a match and then return

“=IF(AND(VLOOKUP(Tallie1!”absent”,F:F,F21(MATCH(Tallie1!C:C,P21)))..formula not working.. Looking for the following:<br/>Look for the …

## Excel reporting Help

Hi Team, I need your help on the excel file . Reference: 1. Master sheet is where i need to update data 2. Etract is the data which we get from A tool to …

## a loop code for a macro

Could you please help me write a loop code for this sequence?  I copy the table Y1:AT4 (containing information from the table A2:X8 I insert the …

## VBA help

‘ The Code begins with the correct Worksheet being selected.     ‘ Then, the User is asked to enter their NetID through an Input Box. …

## VBA to work on multiple lines

Hi all, I will try make this as clear as possible as I don’t think it is too hard to explain.   I have a macro to add a comment to a cell and insert …

## IF Function Question

I am trying to determine thw proper IF function equation for this problem – I have tried it numerous ways and keep coming up with a #VALUE! error. I need …

## Excel PROBLEMMM

Hello I have a set of values in one column, and i want to multiply values between 0 and 20 by 2 , between 20 and 50 by 1.8 , between 50 and 100 by 1.6 …

I Have a table set out with Employee names as column headers and Dates as Row Headers. What I am trying to acheive is to have a dropdown list in a cell, where …

## i need to use variable in formula

“find” variable contain the column value as 49   now i need to use this variable in below formula, the “AW” column should be …

## Autofill with specific condition

Pls, help.   How to populate Amout data in calendar fiel in right table from left with date on/off condition?   2016 2017 Amount date on date off …

## Data Analysis

I have a a time sheet in which the dropdown lists allows the clients name to be clicked and inserted. I want to be able to see which clients have not had any …

## Excel sheet is not showing the updated data.

Hi. I am facing a serious issue regarding an excel file. Let me describe this clearly. I was using Computer “A” with Windows 7 version and Office …

## Sourcing Manager

Hi; Could you please help. I m on Excel 2013. I have a large file and would like to copy the “cell above” to the “cell below” on all …

## Phased allocation of hours over time

Hello – I’m having difficulties in writing a formula that will count ‘x’ number of years and apply a quanity in that cell. I have 3 …

## PowerPivot drill-down excludes columns used in relationships

Hello, I am working with a PowerPivot with two linked tables with which I created a relationship to the main data file.  I noticed that if I perform a …