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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Excel fails to update call to user-written function. by Jim Luedke
I run Excel 2002 under cringe Win 2000. Although recalc is set to automatic, Excel often fails to calc cells that call functions I wrote in VBA--i.e. whose...
August 28th, 2009 12:46 AM
by Dave Peterson Go to last post
9 160
Reference List by Gene L.
I am currently using Excel from Microsoft Office 2007 and could use some help. I have a list of about 50 suppliers to which I have assigned individual vendor...
August 27th, 2009 07:45 PM
by Lars-Åke Aspelin[_2_] Go to last post
1 144
Cell References: R[-2]C[0] vs A10 by Arthur[_4_]
One of my excel spreadsheet suddenly replaced all of the "normal" Ax references to RC references. How to I restore the default reference system??? Thanks
August 27th, 2009 06:03 PM
by Dave Peterson Go to last post
4 152
August 27th, 2009 05:42 PM
by Otto Moehrbach[_2_] Go to last post
2 131
list choice depending on the value in another cell by James
I want to be able to change the list used in validaiton of a cell based the value in another cell. Scenario, user selects a value in column A using...
August 27th, 2009 03:44 PM
by Bernie Deitrick Go to last post
1 143
I need to create a link that refers to the cell by Dee
I need to create a link that refers to a cell on my Guest List sheet H74 to my Budget sheet C7 that contains the total number number of adults planning on...
August 27th, 2009 02:10 PM
by Bernie Deitrick Go to last post
1 140
Rounding in Excel by egg_grader
When I enter a number into a cell that has a formula I am using the results are not accurate. For example when I enter a number 946399, I get a result of...
August 27th, 2009 01:41 PM
by egg_grader Go to last post
2 148
vlookup by Rohit
how can i use vlookup to return value using the col_index_num to be a cell refence instead of column number. =vlookup(...............,2,false) to...
August 27th, 2009 03:09 AM
by Dave Peterson Go to last post
6 191
prevent reading or any access to selected cells by R[_4_]
Spreadsheet has personal data such as names, addresses. Also has Social Security Numbers, which should be private. Trying to send the file to someone so they...
August 26th, 2009 10:06 PM
by Gord Dibben Go to last post
2 129
Add 1 hour to data by israel
I have data 1 tru 200 with time "12:01:04". How can I add a hour to read "1:01:04" so when they move the clock in March '10 I will have the correct...
August 26th, 2009 08:56 PM
by Max Go to last post
1 245
Need help with displaying 0's after decimals by mike
Hi, I have 2 cells. One with the number that has 2 decimals and one with text. When I use the "&" function to combine the 2 into 1 cell, all of the numbers...
August 26th, 2009 05:44 PM
by mike Go to last post
2 130
Save as comma csv problems by rock
Hello, I hace Excel 2002. I have near 6000 addresses and contacts and wish to save the xls to a comma csv. I have done that before and then imported the...
August 26th, 2009 01:44 PM
by Dave Peterson Go to last post
1 138
assign next serial number based on contents of another cell by clint
column A titled "serial number", column B titled "line item", column C titled "cargo". If column B contains 5 line items for the same cargo in column C, how...
August 26th, 2009 01:57 AM
by pshepard Go to last post
2 168
IF and Vlookup? by Heather
Hi - is there a way to incorporate 1 more IF to this formula? I need to use this formula but add which kind of currency to it so in cell B4 they choose...
August 26th, 2009 12:49 AM
by Heather Go to last post
3 129
Linking sheets to summarize data by Robertya
I have a spreadsheet which has employee details on. One sheet has main details Employee no., salary, pension %, job grade, job title etc. Then I have...
August 26th, 2009 12:47 AM
by pshepard Go to last post
1 127
Autofilter includes extra row by George Gee
Just recently Autofilter has started including the last row of data in the sheet, even though this row does NOT contain the filter criteria. Anything I can...
August 26th, 2009 12:31 AM
by Dave Peterson Go to last post
4 183
Excel doesn't recognize stock symbol and won't update price by Usainsomthing
Excel doesn't recognize stock symbol and won't update price. Is there a simple work around?
August 25th, 2009 04:55 PM
by Don Guillett Go to last post
5 138
SUMIF Problem by tuafc
I am on Excel 2003 and having difficulty with a seemingly simple function. Month 1 Month 2 Month 3 a 10 100 1000 b 20 200 2000 c 30 300 3000 I want to sum...
August 25th, 2009 04:50 PM
by Don Guillett Go to last post
2 123
SUMIF Formula (I think...) by JS
Hi, I have a workbook (well obviously or I wouldn't be here...), Excel 2003. One sheet is a running sheet containing a summary of invoices for the month -...
August 25th, 2009 02:41 PM
by Max Go to last post
9 225
How can I group a set of documents needs to be opened repetatively by Prithvi
How can I group a set of documents needs to be opened repetatively?
August 25th, 2009 02:13 PM
by JudithJubilee Go to last post
1 126
Post New Thread


Display Options
Showing threads 1141 to 1160 of 13737
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 11:25 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.