Posts by Rennie

Thank you for your response Paddy.

It can either be the lower or the higher number. I am not too concerned about this.

Thanks,
Rennie

Thank you for your reply Richard. I posted a bad example.

Paddyyd - thank you. You are closer to solving my problem.

Assume Now.

>A1
1>1200
2>2000
3>3000

B1=Cell to Lookup = 1250

Your formula returns 2000, is it possible to make it return 1200 because this is the nearest match.

Sorry for the trouble.

I appreciate your help Richard ans Paddy.

Thanks,
Rennie

Is there a function is excel where the nearest value can be looked up?

For an example consider the following.

> A1
1>1000
2>1500
3>2000

Assume this information is in the range (A1:A3). if I use vlookup(1499,A1:A3,1) this returns 1000. Is there another function that would choose 1500 which is the closest match.

I would appreciate any comments on this.

Thanks,
Rennie:puzzled:

Hi Iperson,

Chris's solution is an excellent one. However this would only work if your data only has 5s.

I have attached another solution that will also work for other numbers.

Hope this helps.

Thanks,
Rennie

Kt,

I am finding it hard to follow your requirement.

Coud you re-structure your question as follows please.

1.Input cells (with examples)
2.Desired result from inputs.

e.g.

1.Inputs = A1 = 1, B1=1
2.Desired output = C1 = 2

Thanks,
Rennie

Transadmin1,

Please follow the thread below for VBA code to do this.

http://ozgrid.com/forum/viewthread.php?tid=700

Hope this helps,
Thanks,
Rennie

Try the following link for a taster!

http://www2.chem.queensu.ca/PR…m210/TEXT/chap7/index.htm

Good luck,
Rennie

Another way of doing this not using macros is as follows. In the adjasent column to your data type in an if formula -if(cell=0,"T",1) and copy it down to your data range. Then select the formula range and edit>goto>special>text. This will select all the rows that have 0 values. Now edit>delete>row.

Hope this helps.
Rennie

Sorry folks, my single brain cell has forgotten how to attach. This is the third attempt.

Hi Jeremy,

You could use the offset function to achieve what you want to do.

I have attached a sample for you. Although longwinded this may help for the time being.

If you need more information on how it works email me on [email protected]
Thanks,
Rennie

Thank you very much bruce my email address is [email protected]rcallcentres.com.au

Regards,
Rennie

Good to see there is some interest on this topic.

I have tried sharing a workbook and then publishing it. I am still not effecting the desired behaviour.

However, there is a longwinded way of doing this (I believe - worked for me once).

The users will need to download the file work on it and save it on the webserver location. In doing this, they will have to remember to save the workbook/sheet with the same name and also to select the appropriate options to save it as an interactive web page.

In short this would require quite a bit of training and users having publishing access to the webserver - needless to say this is much more difficult than updating and saving.

The other issue is once the information is captured it can not be (I could not do it) consolidated the normal way using links etc.

I know an excel spreadsheet can be saved as an interactive web page and published on the web.

Is it possible I capture infornation using this published web page?

In other words I want to users to input information in the webpage and save it.

Thank you in advance

Thank you, that works well
Rennie

If you want to automatically enter a date into the template, you might need to also use.

Sub Auto_Open()
Worksheets("Sheet1").Range("A1").Formula = Now()
End Sub

Hope this helps.
Rennie

is there a formula I can use to locate the possition of a certain character in a cell.

Eg.

Assume cell A1 has the following text "The tiny elephant"
- The location of the last "space" is = 9
- The location of the second "T" is =5

I would appreciate any help on this.

Thanks,
Rennie

Please Try Format>sheet>Background. Note that you will not be able to print this.

If you would like to print this please try the following web site and search for watermarks.

http://www.xl-logic.com/menu.html

Hope this helps.
Rennie

Thankk you Dave I appreciate your help.

Excellent work Neale. Thank you

What is the easiest way to count the number of specific charecters in a cell.

e.g = Cell A1 = Dog Cat Animal
number of As = 2
number of Spaces =2
number of Ds = 1

etc.

any help will be much appreciated.
Thanks,
Rennie