I have the records of a local angling club going back to 1932 and these records include the results of fishing matches matches held through that period. I want to analyze the catches of those matches in order to identify any trends that may exist on the river that those matches were fished and although I am reasonably computer literate I have never needed to use spread sheets.

If the data from those records were in metric measurement it would be no problem but they are in what I would refer to as Imperial measurement.

In other words they use measures in weight based on Pounds, Ounces and Drams.

There are 16 Drams in an Ounce and 16 Ounces in a Pound.

The software that is on my computer is Microsoft Excel Version 5.0c

Need formula that would convert grams to lbs,ozs and drams. I know that grams to drams is *0.564383391193 then divide by 256 to lbs but don't know now how to deal with the non full numbers

I am trying to creat an IF formula for a spread sheet I am working on with information from Bloomberg. I am referencing sheet one to sheet two so I have that forumula in, but in some of the cells this symbol #N/A N.A. appears because some of the information is not available on Bloomberg. How can keep the referenc formula but also include a formula that basically says if #N/A/N.A. symbol appears to replace it with just NA.

I'm trying to make my life a little easier at work. Here is what I am trying to do. I'm trying to create a "calculator" that will tell me the date that a client will leave my program. I understand that I can simply do xx/xx/xxxx-15 and it will get me a new date, easy. Here is the kicker...My office only utilizes 30 day calendars. Regardless if the month has 28 or 31 days, in the eyes of my agency it will have 30.

i'm been trying to mess around with it for 3-4 days now and I can't quite figure it out. I have attached a sample spreadsheet what i'm i'm trying to do.

I would eventually like to create this to be a little interactive (like a pop up or something that is more user friendly) but i'm just itching to get it to work!

I am creating a complex formula with UDF, this Hlookup is part of my complete formula. Meanwhile, I am working on this piece, not Sure what I am doing Wrong

I try to conver "MonthCurrent" Variable in a Year because the MonthCurrent is 06/01/2014, so will be Year(6/1/2014) = 2014

My Range called "DailyRates" is based per Year = 2014, 2015 ......

Basically I have a web page that I want to access with a command button http://www.wunderground.com/history/airport/KVTN/2009/3/28/DailyHistory.html The only problem is that the address is date specific - the blue numbers and probably every time that I use the command, it will be a different date.

I used this formula ="http://www.wunderground.com/history/airport/KVTN/"&TEXT(R2,"yyyy/mm/dd")&"/DailyHistory.html" and it gives me the right web address, I just need to figure out how to make it hyperlink to that web page and then use the command button to activate the hyperlink This is the first time I have tried to hyperlink to a web page and am lost

I am trying to get the following thing started but my loop doesn't succeed. I've got 3 columns. I need to place a formula in column C if A is empty.

Example:

A2 contains data so do nothing. A3 is empty do: C3=B3+B4. A4 contains data so do nothing. A5 contains data so do nothing. A6 contains data so do nothing. A7 is empty do: C7=B7+B8.

I am in the process of creating a template in excel with certain restrictions on the information that can be added to it. I've hunted several sites and forums to try and find a solution but find it difficult to see the best ones for my project. The template is roughly made up of say 10 references to large boxes, each box can hold smaller boxes. The smaller boxes vary in size. For example the large box is 60 inches long smaller boxes vary between 20 inches and 40 inches, can excel be made to tell me an error if i try to put 2 x 40 boxes in columns refering to 1 of the larger boxes as it exceed the maximum length of 60 inches?

I am trying to create a formula by comparing data in columns on a separate tab.

Basically, I want to take the value of one cell in the primary tab, find the matching value in a column on another tab, then once it is matched, pull in the data from another cell in the second tab on the same row of the matched data.

I cannot find the right catagorty I need to use to word this. I know there is a formula out there. I basically have 1k numbers I need to add into Collumn A of a worksheet - the numbers are from range 34-2501 through 34-3500. How can I get excel or VBA to do this automatically?

34-2501 34-2502 34-2503 repeat til 34-3500

Also, how to make it user friendly to create the same process over and over with a different set of numbers... meaning make it so I onlt have to input the range or numbers over and over. if it is an easy task I do this allot

I have been trying to create a formula that will save me DAYS of messing around at work.

What I am trying to achieve is to have a sequence of numbers as follows:

BNA01A01 to BNA01A09 then have it change to BNA01B01 to BNA01B09.

This needs to be repeated for all letters to BNA01I09.

Then this sequence needs to be repeated to BNA12.

The last thing is for me to be able to change the formula in order to implement the same sequence on a separate sheet for BNB01A01 - BNB12I09 to BNL01A01 - BNL12I09

Now, I need a formula that will sum the entire column B, by looking up the array of column A on another sheet and only summing the numbers on sheet 1 that also have a value of "West" on sheet 2. Sheet 2 looks like this:

This needs to be functional as a template to be used each month - the entire point of the formula is to save time and eliminate the current (and lengthy method that is in use). I can tweak the formulas as needed. But am trying to avoid having to concatenate anything or do any modifications to the format of the sheets.

I have a formula which looks in a folder for a file and returns the cell I want from that folder and work book

='H:NCHOCall CentreCall Centre ResourcingStats[NHC_Telephony_Daily_2012-11-27.xls]NHC Daily'!$E$55

as you can see I have a date in the middle, I want it to reference to a cell with a date in and return the information from that document with the change in date. So all I have to do is drag the formula down and it will return the info i want out of each report.I think it might be an add on that I need to download?

I am creating a report and I am using the following Formula with condition.

(IN Q2 in the file attached) =IF(P2="","Enter New to IMP check Date",DATEDIF(P2,C2,"d"))

Where in P2 is the START Date and C2End date. P2 = 01 Jan 13 C2 = 10 Mar 14

When I apply the DATEIF formula its ignoring the year differ ace and give a result of 8 days not sure whats wrong here as the "Y" & "M" function works correctly and give proper result.

In worksheet named, " My Overview", if the total sales values are a zero in C47:C59 the consultant name is duplicated in B47:B59 because of the values being a zero in C47:C59. How can i have the formula not duplicate this?

I need to know if its possible, and if it is, what the formula would be to get the correct "Rate" to pull based on the criteria given:

User would input the following information:

Zip Code: 56559 Pallets: 3 Weight: 1200

The formula needs to use the following table to use the criteria listed above, to fine the correct "Rate". The "Zip Code" and "Weight" both need to fall between the correct ranges and then match the "Pallet" to find the correct "Rate".

From Zip Code To Zip Code Pallets Weight From Weight To

Creating a formula that would generate a perfect and full circle - see attached picture example. The circle needs to remain centered in the X,Y axis. Also the circle diameter will either be 1, 2, 3, or 4 units large depending on user selection.

I am trying to get a grip on my gas n electric bills. My problem is in creating a formula to convert the info I have into the final bill.

The info I have is -: days of use, amount of G n E used, standing charge, price/unit and discounts applicable. For simplicity I have converted them all into a rate per day and £GB. I tried the following formula

:-(standing charge per day * days used)+(cost per KWH * No.of KWH used) - (discounts * days used) / (100) * (94)

This last one is to account for a direct debit 6% discount. I used cell address for things like No of days usage and KWHs used in the period. The values in these cells have themselves been calculated via a formula from other info. The results I get seem to be a constant variable which indicates that I am doing it wrong.

All is well, except for my x-axis (which is a text axis). It currently looks like this: Dynamic axis.jpg

I am using the Offset formula. The formula for my x-axis is =OFFSET(Worksheet1!$D$4,0,-3,COUNT(Worksheet1!$D$4:$D$36)). This is to show the axis if cells in Column D are filled up appropriately.

However, in the cells containing the axis name itself, this formula is used =IF(D9=0,NA(),'Worksheet2'!A6). I've tried removing the formula from these cell, but that didn't solve the problem.

i need to create a formula to calculate rankings for a race series. there are 10 events in the series, only the best 7 individual results count. and there are 4 events which are mandatory and must be included in the rankings. sample attached.

I'm trying to create a formula similar to this: =sum(B7:B & 8*A2+3). What I want the formula to do is start in B7 and go to B###. The cell number is based on user input. So if the user enters "24" in cell A2, then 8*24 = 192, 192 + 3 = 195, so the formula would be: =sum(B7:B195). Can I do this in a cell, or do I need to run it in a macro?

On the attached spreadsheet, ormula on 'UserForm2'.

When I hit the 'Submit Changes' button I want a formula so that it will look up the product row in Product List (Sheet 1) that is select in the ComboBox1.

Once this row has been found I want the values in TextBox1 to be copy and pasted into Column D of that row and value of TextBox2 to be copy and pasted into Column G of that products row.

In my business I deal with a ton of different dimensions for my products. A lot of times the dimension will be within the cell as follows, "Product A 17x27 Brown", is in a single cell.

Is it even possible to write a code or formula that will find the "17x27" in the description, recognize it as a "dimension" and then run the formula that I need which is