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
visible rowindex by Chris
Is there any possible way to change this formula to only use the visible rows so I can filter my list? =INDIRECT("PrintData!B" &RowIndex)
September 2nd, 2008 02:40 PM
by Spiky Go to last post
3 57
Sumif function? by Esradekan
I have a summary sheet of 30 staff (staff 1, staff 2 etc at top of columns), dates down the A Column with figures in the relevant cells. What I need is a...
(Multi-page thread 1 2)
September 2nd, 2008 02:30 PM
by Spiky Go to last post
11 143
Evaluate boolean values as 1 or 0 by hmm
How do I use boolean values so that a formula would evaluate TRUE as 1 and FALSE as 0? For example, if column A contains boolean values, I want to avoid...
September 2nd, 2008 01:32 PM
by Duke Carey Go to last post
3 90
For Each Sheet in Range - Sort Descending by NPell
In a macro can i do something like.. Dim MySheet as Variant MySheet = ("Sheet1", "Sheet2") For Each Sheet in MySheet Sort Range("A3").Descending Next...
September 2nd, 2008 01:31 PM
by Don Guillett Go to last post
7 86
Compare two columns by Jeanne T[_2_]
How can I compare two columns to find only those that are different? Ex: Col A Col B Difference EA EA None ...
September 2nd, 2008 01:26 PM
by Jeanne T[_2_] Go to last post
2 96
Command Button by Freshman
Dear experts, I want to create a command button and when I click it, rows under row 30 will be collapsed. When I click the button again, it toggles to expand...
September 2nd, 2008 01:16 PM
by Freshman Go to last post
3 92
Auto Filter - Add visible cells by Doobrifurkin
Hi, I have a list containing numerical and text values. I have applied an auto filter and would like to place a formula that adds up these values of the...
September 2nd, 2008 01:16 PM
by Doobrifurkin Go to last post
3 129
sumproduct text by A.Mourice[_2_]
Hello, A1 A,B,X,C,X A2 X,D,G,X A3 F,G,K,L,X I need to count how many X repeated at many cells using sumproduct function.
September 2nd, 2008 10:31 AM
by Gary''s Student Go to last post
5 103
How do I omit a blank cell from a calculation?? by marklg
How do I discriminate between a blank cell and a zero value cell in a formula?
September 2nd, 2008 10:16 AM
by Dave Go to last post
5 92
how to unproctect the sheet if password is not remember? by how to decode the password if forget
dear plz guide how to unprotect the sheet if password is not remember or forget.
September 2nd, 2008 07:14 AM
by Gav123 Go to last post
1 115
Lists by Varney
Hi, I have a problem I need help with. I will attempt to explain what I am trying to do. I have created a drop down box with several customer's names to...
September 2nd, 2008 03:55 AM
by T. Valko Go to last post
4 86
2007 Conditional Formatting by BigDDDD
In older versions of Excel, I used to set 3-4 conditions in cells A1 to A4. Then, I would copy these 4 cells across to Column BZ and all would be well. Now,...
September 2nd, 2008 02:46 AM
by T. Valko Go to last post
1 114
Paste Link between Worksheets by JC
Hi, I have been using 2003 and 2007 versions of Excel and trying to link graphs from one master sheet to another file so that it automatically updates when i...
September 2nd, 2008 02:32 AM
by JC Go to last post
0 100
indirect formula question by Chris
Hello - I have been trying to wrap my head around getting an indirect formula that indexes rows to be printed to only recognize visible rows so I can run a...
September 2nd, 2008 12:03 AM
by Chris Go to last post
6 88
Excel Cell Reference by Jer
I am trying Office 2007 and in Excel I have at one attempt tried to reference a cell in another sheet in the same workbook and another time have attempted to...
September 1st, 2008 11:51 PM
by smartin Go to last post
1 106
Monday Following by robzrob
Hello I'm sure I've done this before, but I can't remember how. I need a cell to return the date of the first Monday after today.
September 1st, 2008 11:47 PM
by Bernd P Go to last post
8 120
Finding the solution to an Exel problem. by MJohn
My scenario is as follows: I have 2 adjacent cells that have 'VLOOKUP' functions and they return a value when certain criteria are met. There are only 4...
September 1st, 2008 10:24 PM
by Bob Phillips[_2_] Go to last post
3 93
Exclamation
Need Help with Highlighting duplicates across several sheets by vote4pedro
Hello, I only know the basics within Excel and I need to develop a spreadsheet that has 3 sheets within a spreadsheet and highlight duplicate names entered...
September 1st, 2008 10:05 PM
by Herbert Seidenberg Go to last post
1 78
Look up a value from a row after verifying two other values by Paul W
I have a spreadsheet that I am populating with miles from point to point. Each spreadsheet has the same point tp oint listed twice, the second time in...
(Multi-page thread 1 2)
September 1st, 2008 08:59 PM
by T. Valko Go to last post
11 260
Calculating Information by Andrew
I have created a workflow to determine work hours from when a request was received until it is completed. The date / time is captured as yyyy/mm/dd hh:mm In...
September 1st, 2008 08:28 PM
by JMB Go to last post
3 77
Post New Thread


Display Options
Showing threads 20901 to 20920 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 07:44 AM.


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