# Archive by month April

## Data Analysis help

I have a hypothesis that sales of marijuana by month over 42 months has a positive correlation with the car crashes over the same 42 months. I need to show …

## Wont autosum

I am using excel 2010 and I am working with cells that have percentages in them. For example, 0.62, all of the numbers in each cell are shifted to the left. …

## Find the count of dates whose bg colour is green , month is january , year is 2016

Hello All, I have a set of data where in there are several dates (For eg in cell A1) and alphabets (in cell A2). When I don’t have the alphabets in …

## Error with cut and past

I get the following message when I cut and attempt paste a line from one sheet to another sheet in the same document; This can’t be done on a multiple …

## listfillrange

im trying to type “DropDownList” into my listfillrange, but it keeps disappearing, any ideas why please? By:

## Count using a Tally Chart based on a unique reference

Hi   I was wondering if any one could help me. I will try to explain it in writing in details.   So i have created a Tally chart on excel and i am …

## Pivot Table

I am using Execl 2016 with Windows 7.  I have a pivot table and i want to use one of the columns in a separate calculation.  I want to reference the …

## Rand Formula explaination

Hello Guys,   I hope your all doing great!, Am lookin for some help in creating Random paragraphes in the same cell , I did a formula to generate random …

## How to convert square feet to cubic feet

Hi,   I need a helf that how to calculate square feet to cubic feet in excel,   If the square lbh was 6*3*3 feet then what was the cubic feet …

## IF OR Formula question

I have a cell in which I need to use the logic IF this service is selected the rate is x but if that service is selected and assigned to this person, the rate …

## Populate source Table with set of numbers

I am trying to make player batting cards for a game that uses a three dice, 10-39 numbering sytem with 216 possible results.  I have two …

## Entire tables inside a filter, possible?

Hi all,  I’ve recently been tasked with a bit of a difficult situation at work. We have a pricing tool that is essentially a bunch of excel pages …

## Copy / Paste within Data Filter, selecting individual cells instead of range?

I am working with Data Filters for the first time and keep running into this bug or “feature”? I am attempting to copy and paste a range but …

## Error Calculated Item Pivot Table Excel 2010

Hello, when trying to create in Excel 2010 a calculated item in a Pivot Table the following message appears: “the item cannot be added or modified. There …

## Combine primary and seconary axis with several values

Hi all, I am having problems with creating a graph with several variables in primary and secondary axis.   Lets say I have 5 countries which I want to …

## Auto Filtering Will Not Turn On In Excel 2000

I am in the midst of editing a complex Excel 2000 spreadsheet. I can turn off Auto Filtering without a problem. However when I go to turn it on again only the …

## Sort multiple cells based on frequency

Hi all, first off a big thank-you to anyone who responds because I cant work this out! I have a set of numbers in different cells. I want to sort the range …

## 2 values to lookup

Excel 2016 I have some data which requires a 2 value lookup and i cannot work out which formula to use:   Example line item=1 column item =1 …

## HELP!

I need to create a Macro that will pull in a list of healthcare claims per identifying store ID.  I have a list of a million claims from a query that I …

## If formula

Hi, can anybody help me with a formula? It needs to be : IF the value in cell A1 is “3”, then put a mark i.e. “X” in cell B3. So : IF …

## what formula….

Hello I have a worksheet containing 2 worksheets. Worksheet 1 contains 22k records which contain customer numbers in column A and  their contact type in …

## How to transfer specific data from one sheet to another

Hello, I have a sheet containing data on country names and aid given to each country over a period of 21 years (there are 250 countries and the data is …

## data validetion formula

i want allow only ifsc code in excel. first four lettar only capital alphabate only. and fifth lettar “0” and text length = 11 plz help me By:

## Sumproduct and Sumif

Hi All! My data: Column A is the category name Column B,C,D is the month (Apr,May,Jun) How can i sumif the multiple of Column (Apr, May, Jun) in one formula …

## Engineer

Dear Experts, I need to import some word files with (embedded excel) charts into excel and then extract the source data (paste it in excel). I have been able …

## Gather pivot table field data from multiple sources

Hello, I have an accounts workbook. Each of my bank accounts is imported onto a different sheet, sadly each bank has a different format. I then add my own …

## Excel master sheet splitting

Hi,   I would like to split my master sheet into multiple worksheets within the same excel file. My mast sheet is grouped and shows the field in column 1, …

## if and and time

I’ll outline the situation: I’m assigning different prices for energy being consumed within different time periods within a day. 23:00-7:59 is x, …

## Separate Excel Company Record with Multiple Contacts into Multiple Records

Hello. I have a CSV file that I’ll be importing into Excel/Numbers. The file is built with 1 record for each of many companies. Each company has several …

## change first letter to a B from a A in one go, or can i only do it indivdualy

A9-1A A9-1B A9-1C A9-1D A9-1E A9-1G A9-1H A9-1J A9-1K A9-1L   A11-1A A11-1B A11-1C A11-1D A11-1E A11-1G A11-1H A11-1J A11-1K A11-1L By: martin …

## access data from worlksheets

On sheet1 I have a list of other tab names in column. i want to access data from those sheets using the column data.   ex.: Let A1 column contains …

## Rows in Range to Arrays

I’m writing a function and one of the inputs will be a range say, A1:G3. The seven rows need to become arrays with three entries.   My approach so …

## Pivot Table query

Hi,   I have two columns in excel. Column 1 = Month-Year, Column 2 = Total sales of the Month. I want to creat a pivot chart which shows yearly sales. For …

## Excel VBA Userform Combo Referencing

I have two Combo Boxes in Workbook2. If i enter cloumn A1 in combo 1 which is referenced from workbook1 Row 1 I want Combo 2 to be populated with column H1 of …

## exclude rows with formulas from range in macro

I made a Data Entry Form that ads or updates rows in a datasheet. With this http://www.contextures.com/exceldataentryupdateform.html as the base. The …

## help

how does this formula work i do not understand =LOOKUP(2,1/(\$A\$2:\$A\$7<=F1)/(\$B\$2:\$B\$7>=F1),\$C\$2:\$C\$7), By:

## =IF or =VLOOKUP: Find all cells that contain a date and create a list of dates

Hi, I created a spreadsheet into which I enter certain data for swimmers to track their progress. I would like to extract some of the data to create a graph. …

## Auto checkbox info to quote sheet

Sorry but that’s the best heading I could think of. I have a price list on “Sheet1” and a quote/receipt layout on “Sheet2” I …