I want to create a chart that plots values which are calculated by a formula which incorporates 'log (e)'
How do I type this function into a cell?
My formula is P log(e) xt
P = 1.71
x = 0...
Greetings!
I have an excel file where users enter data on a page. Those numbers get totaled & transfered to other pages in the workbook. Just had a user trash it because she either moved a ce...
Hi,
I am trying to create a userform with two list boxes. These listboxes will have 3 colums and a checkbox. To show the checkboxes I set the ListStyle Property to "1 - fmListStyleOption". ...
Hello Experts,
I'm not sure if it's possible but here's the deal.
In row A I have values that contains my employee number and some other data.
I want to keep only the first three digit ...
Here's the scenario: I've created an Excel (2003) Spreadsheet which I indend to use for calculating stop-loss points for stock trades based on the "SafeZone" method developed by Dr. Alexander...
Simple but Urgent.
Is there a way to change the Author of all comments in an Excel workbook programmatcally. Manually is not acceptable.
Thanks
I may be in the wrong place but... I created several files in BIF8 (MS Excel 8) format using IBM's Client Access. All but one import into Access with a macro with no problem. One of them produ...
Is it possible to use Excel's SLOPE function on a non-continuous range?
Slope works fine if you have data in A1:C1 that you want to compare to A2:C2 ( =SLOPE(A1:C1,A2:C2) ). However, as ...
I have a VLOOKUP question:
The formula, I'm using is "=VLOOKUP(K16,TABLES!AS2:AT1000,2,FALSE)" which looks to cell K16, but cell K16 is a formula as well "=((E16+G16)/2+(C16+I16))/3" It work...
Hi all,
What is, in your opinion, the best way to select all of the active cells on a sheet, without selecting the phantom formatted cells? I've seen three ways. The one I typically use is....
I am currently using Excel 2000 and my question is like this. In column A I have many rows of project name and in column B I have labelled it "Project Nature". In each single cell under the "P...
When transferring a spreedsheet between two colleagues the drop down combo-boxs that were on a form on the Excel sheet somehow became protected and embedded in the cells.
The sheet was bein...
I'm using Excel in a log application. One large table of:
date event follow-up
----- ------- -----------
Problem is I want the date to be automatic when I enter a log
If ...
I have a need to send an email from an excel macro - which I have done - see below. What I would like to do now is display a listbox that people then choose an option from and then depending o...
This should be a cake walk for some of experts here.
I have a simple spreadsheet that is about 700 rows by 5 or 6 columns. I have 700 employees, sometimes they go on vacation or across cou...
I have a list of postcodes, some of which do not have a space separating the 2 parts.
BT367PZ
BT388BY
BT4 1JH
BT4 1JT
The space is missing for those postcodes that have 2 digits in t...
I have the rows merged: A2:f10. These merged cells are linked to another worksheet pulling info into them. These cells force a carriage return after every value, which works great.
I want t...
Hi guys,
I have a excel sheet, have alot of Rows with teext information and numbers.
I want to know how to reorder it from bottom to top. Note tehe no.is not in ascending or descending ord...
Hi all
I want to be able to calcalcute the road distance from one central postcode to many others without having to do every one indivually. Is there any way of doing without expensive soft...
Hi all,
I have an excel file with values for start time and end time in the format described above, how can i convert them into this format hh:mm:ss . How do I calculate the difference betwe...
Message: There is a crcular reference but cannot show where?
Any help?
Can someone help me with this error message. Application developed in Excel 2000 runs fine. Some users in Excel 2003 run fine also. We have a few users that get the error "SendMail returns...
Hi All,
I have a list of 128 lines of text:
.acgi text/html
.ai application/postscript
.aif audio/x-aiff
.aifc audio/x-aiff
.aiff audio/x-aiff
.asf video/x-ms-asf
.asp text/a...
Hello,
My goal is for the user to choose a selection (radio button) which points to a particular column and then I just want to see that column near the column that has been frozen. I am loo...
Working in excel (within the range A1:DJ250) I wish to find the bottom of my longest column of data, insert a COUNTA formula in the next free cell and then copy this to all ajacent cells in th...
