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 Reverse Sort Order Replies Views
Total a column (or row0 by highlighting cells by Goldar
Isn't there a way to total a column of numbers without using the AutoSum function. I seem to remember that I could just highlight a series of cells and the...
April 20th, 2010 08:13 PM
by Luke M[_4_] Go to last post
1 192
pulling a list of hyperlinks from a worksheet by Dale
I have a worksheet with over 800 cells. Each cell displays a churches website url. I need to display the actual hyperlink http://www.whatever.com not the...
April 20th, 2010 07:36 PM
by JLatham Go to last post
3 298
conditional formula needed by kylefoley2000
it might be possible to do this as a conditional formula (=if) otherwise a macro might be needed. the thing i'm unsure about is this formula looks at the...
April 20th, 2010 07:17 PM
by Duke Carey Go to last post
2 209
transfer cell value from 1 sheet to another without copy/paste? by sbmiller
I need to enter a value 1 time and have it appear on additional sheets, without copying and pasting to other sheets. Please help. I'm trying to
April 20th, 2010 06:51 PM
by Luke M[_4_] Go to last post
3 216
Counting consecutive negative value by Wallace
Hi, I have a column with positive and negative numbers. I need to count the largest number of consecutive negative numbers and don't really know how to do...
April 20th, 2010 06:47 PM
by Joe User[_2_] Go to last post
6 257
Sum Function Visible Cells only by Brian
if column a has the number 1, column b has the number 1 and column c has the number 1, column d has the function sum(A1:C1) for a total of 3. how can a...
April 20th, 2010 06:04 PM
by Mike H Go to last post
5 285
Averaging times that are not in a range by Nancy D[_2_]
I am trying to get an average response time for numbers that are not listed in a range. They are formated as a custom format like this: h:mm:ss. I have been...
April 20th, 2010 05:19 PM
by Nancy D Go to last post
3 245
Count if past today () - 30 days by Scott_goddard
Hi all, Trying to count the amount of risks the are open and and past todays date by 30 days... So far i have =COUNTIF(C9:C98,"Open"'(R2) Risks...
April 20th, 2010 04:59 PM
by Scott_goddard Go to last post
3 202
Reconciling Invoice & Credit by Casper
Hi there, can somebody please help. Below is the data table I have. On the 4th column "Status", I need to know which invoices remain outstanding and which...
April 20th, 2010 04:58 PM
by Duke Carey Go to last post
2 195
Vlookup issue by Tomwireless
When using vlookup fuction - not looking up numeric only data =IF(ISNA(VLOOKUP(A3,'Inventory Items'!$A$3:$D$888,'Inventory...
April 20th, 2010 04:50 PM
by Duke Carey Go to last post
2 242
Multiple variables to sort and sum, return values0 with sum refer by Stinky
Can anyone help me with this one please? I have this table of data. I'd like to be able to write a formula(s) which sums the No according to date and code,...
April 20th, 2010 04:18 PM
by Steve Dunn Go to last post
5 204
revised q on report from tables by UKMAN
Hi Would still love help on previous regarding 20 tables but in a panic. :( I have now ref all tables to 1 long list so as a quick fix: the col headings of...
April 20th, 2010 04:15 PM
by Steve Dunn Go to last post
7 210
Date refrencing by Amin
hi i have two sheets one is inventory the other is summary with the same style and clumn headings. now i want the date of the summary sheet to record the...
April 20th, 2010 04:08 PM
by Amin Go to last post
3 199
Avg % above 0% by Wendy
How can I get the average percentage of a collumn of percentages without it including any 0%. e.g. A1=0% A2=100%, A3=70% if it averaged the 3 cells it...
April 20th, 2010 03:30 PM
by Bernard Liengme Go to last post
2 162
Functions / Drop Downs won't calculate by Bunecke
I have a complex workbook (Excel 2003) that has been in use for over a year. Most users can use the workbook just fine. However, recently, I have had two...
April 20th, 2010 03:16 PM
by Don Guillett[_2_] Go to last post
1 203
Changing the range for averages with out changing the formula. by JessLRC
Hi I would like to create a column to list cells that would be excluded from an average. I don't want to change the formula because I want to lock those...
April 20th, 2010 03:10 PM
by JessLRC Go to last post
0 166
how do I drag and fill hyperlinks? by coreygreat
I have a master lists of document names that I'm trying to hyperlink sections to different sheets in the same workbook. I can't seem to figure out how to...
April 20th, 2010 02:10 PM
by Don Guillett[_2_] Go to last post
3 207
Data Encryption by Confused
Is there a way to anonymize say a column of employee numbers in Excel? I want it done in such a way that for each year of data the number is encrypted the...
April 20th, 2010 01:46 PM
by JLatham Go to last post
1 213
Excel corrupts when asking to update vlookups by Bob-ISTA
We are experiencing weird behavior with some Office 2K3 Excel spreadsheets that contain lots of calculations, but no macros. On some pc’s Excel acts...
April 20th, 2010 01:42 PM
by Don Guillett[_2_] Go to last post
1 203
worksheet by Abhishek
i have saved a excel file in workspaces wrongly what is the proceedure to change this file in excel
April 20th, 2010 01:00 PM
by Eduardo Go to last post
2 172
Post New Thread


Display Options
Showing threads 1141 to 1160 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 05:45 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.