Search results for query: *

Hi all, I am trying to design an excel form that basically solicits input from the user via a series of input options on an excel form. These are: 1. Field Name is "Planted Date" and it's selected via a date time picker. I would like to extract the month and year from that. Let's assume the...

I am trying to lookup a heading of a column and am having difficulty with it. The spreadsheet looks like this: Field Number 1 2 07107 01/31/08 02/28/08 07108 06/30/08 07/31/08 Basically, I want to retrieve the values 1 or 2 based on the criteria...

So I'm not sure if a query is the best way to do what I'm trying to accomplish but essentially: 1. I am trying to create a table that hold's the life of a agricultural field. The table I set up has the following data: FieldNum PlantingDate 6133 07/10/2008 2. Based on that...

Hi, I aplologize if this doesn't lay out on the screen properly. I've been meesing with it a bit to format but hope it gives the general idea. Anyhow, I have a report that runs every month in in text that I want to parse via fixed width. The fixed width would be based on the spacing in the...

Hi again, I have some calculated items that I have inserted into a pivot table that are resulting in zero values for intersections where there is no valid data. Is there a way to suppress this calculated item when there is no data to calculate? I have tried hiding zeros etc.

Hi, I am trying to created a calculated field in a pivot table that effectively excludes two members. The field is account and I want to create a calculated field that excludes sales but am having trouble finding whether it can be done. To demonstrate: Account Amount Sales...

Hi, This is probably way easier than what I am making it. Essentially I have two tables I am trying to query off of. The first contains transactional data with an account code. The second table has three columns. The first two columns represent the upper and lower end of a range the account...

I am trying to write an excel macro that will copy a range called "Data" on sheet 1 into a series of sheets that are indicated by a range called "CountryNames" on sheet 2. So for each sheet I want to copy the information to there is an entry in the range containing that sheet name. I cannot...

I am trying to write an excel macro that will copy a range called "Data" on sheet 1 into a series of sheets that are indicated by a range called "CountryNames" on sheet 2. So for each sheet I want to copy the information to there is an entry in the range containing that sheet name. I cannot...