A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Views Reverse Sort Order
excel 2007 by Stan Halls
i have a script for saving a file to 2 locations, 1st location saves in excell2007 macro enabled, 2nd location saves in excel2003 compatable version, i have...
March 22nd, 2007 10:36 PM
by Stan Halls Go to last post
0 34
Data Extraction Problem by Duke Carey
Since you have Excel 2003, make your range of data a list (Data-List...). Excel will outline the range with a border and add a new row with an asterisk. ...
February 28th, 2007 03:11 PM
by Duke Carey Go to last post
0 34
get date function result as text by Andrew[_2_]
Hello, I am grabbing weekday names with this function =DATE(E5,C5,D5) where E5 is 2007 C5 is 1 and D5 is1 the result is Mon I wish to look at some data by...
February 27th, 2007 02:37 AM
by David Biddulph Go to last post
2 34
Columns are numbers (instead of letters). How to revert? XLS by bobcat
In Excel...My rows are still numbers, but somehow columns are also numbers. So cell A1 is now cell R1C1. How do I revert back? Version 2003
April 26th, 2007 04:25 PM
by Dave Peterson Go to last post
1 34
Trying to open Excel From Visual Basic 2005 by [email protected]
I'm trying to open Excel with Visual Basic 2005 with the following Code Dim myExcelObj as New Excel.Application myExcelObj.visible = true dim wb as...
March 22nd, 2007 04:44 AM
by Anne Troy[_2_] Go to last post
1 34
Only the last rows... by Lars
I have a spreadsheet with about 50 rows that gradually will be filled up with numbers. How can I make formula that will count and ad up only the 12 last rows...
March 22nd, 2007 02:41 AM
by L. Howard Kittle Go to last post
2 35
Autofilter multiple columns by Saintsman
I need to filter 2 columns (from about 30) using VBA Select Client (drop down box) &/or Select Contractor (drop down box) I can select on either one using ...
January 18th, 2007 11:06 AM
by Saintsman Go to last post
2 35
condition formatting involving formula by [email protected]
if cell is A1=100 how do i set a conditional formating for the following 1) if cell B1 value is greater than A1 by 20% fill blue 2) if cell B1 value is lower...
May 17th, 2007 02:19 AM
by Barb Reinhardt Go to last post
2 35
Cell placement by Dianethetech
I am trying to take data from 3 different columns and put it in either of two other columns. For example: F47 is a date formatted MM/DD/YY and T47 is a...
May 17th, 2007 08:50 PM
by soconfused Go to last post
4 35
Count occurences and return total by Daniel A.
HELP! I know someone here can help me! I want to count the number of times a specific ID number occurs in a column, and return the total count in the cell...
October 20th, 2007 07:29 AM
by T. Valko Go to last post
2 35
difference between + or = in entering a formula by Lencastre
Hello I'm a long time MS Excel user and working with it on a daily basis, I find myself puzzled with it sometimes. For instance,... What is the difference...
March 7th, 2007 09:54 PM
by Dave Peterson Go to last post
3 35
Rounding by Steve[_3_]
Hello, I have a spreadsheet for calculating labor rate. Column A contains tenths of an hour (.1, .2, .3 etc...) Column B has a simple formula (=A1*32.39),...
March 1st, 2007 12:53 AM
by Sandy Mann Go to last post
3 35
Averaging last 5 cells in a column by Bob Smith
Hi folks, In my workbook, I have a bunch of worsheets, where I'm average all numbers in one column. I'd like to add one more stat, to where I'd like to...
February 28th, 2007 09:36 PM
by Bob Smith Go to last post
4 35
dynamic range and series by Cass Calculator
I am doing regression analysis for tree size (independent variable) and tree age (dependent variable). I want to make a template that will allow me to chart a...
February 24th, 2007 12:46 AM
by Don Guillett Go to last post
1 35
Access to Excel by Steve.M
Basically I want to type a name in an access table/field titled name. I want the name to simply be inserted in a cell named name in excel. I want that done...
February 17th, 2007 06:06 AM
by Steve.M Go to last post
0 35
Help needed would this be an IF statement by pano
How do I write this formula I have been given the first part but cant work out the rest myself =IF(A1"",8.26,"") If A1 is blank make b1 blank if A1 is not...
February 11th, 2007 07:37 PM
by T. Valko Go to last post
5 35
VLOOKUP, Sorting, Calculate by rldjda
I have a project to create a "running" report that calculates various formulas for each particular jobID, but the job ID's aren't entered yet ( to be entered...
February 7th, 2007 10:41 PM
by driller Go to last post
3 35
Macro hot button in Spreadsheet by watchtower
How can I create a hot button/key in my spreadsheet and attach a Macro that will be available to everyone that opens it? For example, I have a formatting...
February 2nd, 2007 06:27 PM
by CLR Go to last post
3 35
excel worksheet by fubar1
Jn my excel worksheet, there are a few boxes, that change the data I enter...For example row F, line 155, I type in the number 46....push the tab for the...
January 31st, 2007 12:51 PM
by David Biddulph Go to last post
2 35
Formula in cell by albericht
Excel Help says enter 10-5 and it will read the answer as 5 in the cell. I tried it, but it just read 10-5. So I then tried clicking Enter, but it then...
November 5th, 2007 09:29 PM
by CLR Go to last post
2 35
Post New Thread


Display Options
Showing threads 1 to 20 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.