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
macro - hide rows by Will
I will try this again but I do not understand all the lingo so please lead me. Cells A2:A60 contain formulas that return a result of either "" or a number....
September 17th, 2003 10:18 PM
by Will Go to last post
3 441
revision number of excel worksheet.. by PhantomSteve
Is there any way I can get a cell to show the revision number of the current document (ie how many times it has been saved)? In Word, this is done by...
September 17th, 2003 10:58 PM
by Andy Wiggins Go to last post
1 399
Formula Help by SFrick
In row 5 i have text, positve and negative numbers. I need a formula that will return 1 when the cell above in row 5 is positive and 0 when it is negative or...
September 17th, 2003 11:06 PM
by Harlan Grove Go to last post
1 257
This directed to John Wilson/or anyone else by Radio848
Hi Guys & Gals: John provided me with the enclosed macro, (I have made modifications, so the problem isn't his fault) Problem: I can only get the enclosed to...
September 17th, 2003 11:09 PM
by Radio848 Go to last post
6 389
Split Combined Name by dlaw
Cell A contains a name in the format 'first initial last'. I want to create cells from this: 'first' 'initial' and 'last'. Are there formulas for the 3 cells...
September 17th, 2003 11:14 PM
by mr Go to last post
1 433
Changing A1 to $A$1..... by 43fan
Is there any way to change a set of cells all at one time? The entire equation? I'm copying cells from one area in the worksheet to another, and I don't want...
September 17th, 2003 11:31 PM
by jr Go to last post
3 297
TROUBLESHOOTING VLOOKUP - PASTE NEW VALUES by Charlie Marcous
I have a workbook where column "I" looks up the value in "J" in another worksheet and returns a correct value for column "I" which works for 400+ rows just...
September 17th, 2003 11:36 PM
by L. Howard Kittle Go to last post
1 713
Counting by Jennifer
I have three columns that I am using. I am trying to count one column if the other two columns meet some criteria. B2:B2000 has data that is either: 1, 2, or...
September 17th, 2003 11:51 PM
by Alan Beban Go to last post
1 259
sumproduct formula by Sue
How do I get the following formula to work I want to count the # of lines that have vendor in column L and a date between the values referenced, and any cell...
September 18th, 2003 12:02 AM
by Harlan Grove Go to last post
1 274
AutoSum Limitation? by Kelly
Does anyone know what the limitation is on how many cells you can use in a Sum function? I ask because I'm trying to total about 60 cells into 1 and receive...
September 18th, 2003 12:12 AM
by Harlan Grove Go to last post
1 152
sum minus the smalles cell by Hai Nguyen
Hi All. How do create a formula which give me the sum of 5 cells minus the smallest cell? eg: if the cells contains numbers: 10, 12,15, 3, 14. The formulas...
September 18th, 2003 12:17 AM
by 2rrs Go to last post
4 317
Excel expression that would always show the Sunday date of the current week by Rudy
I would like to build an Excel expression that would always show the Sunday date of the current week Based on that date I would like to build a expression...
September 18th, 2003 12:51 AM
by Harlan Grove Go to last post
1 600
Formula help, CELL Function help needed. by Kenny McCormick
Thanks, That did help me see what matches i have in the two sets of colums but I am still lacking the second part where if there is a match in the two colums,...
September 18th, 2003 01:13 AM
by Biff Go to last post
2 585
sumproduct by sue
Can someone tell whats wrong with the following formula? i want to the number of lines that has vendor in column L etc and any cells in column F that contains...
September 18th, 2003 01:17 AM
by Don Guillett Go to last post
1 246
Excel 97 - finding No. of Months between 2 date ranges by RoyB
Hi I need to find how to work out the total number of months where I have a list of fixed start and end dates, always beging on the first day and end on the...
September 18th, 2003 01:34 AM
by acw Go to last post
1 435
Date Format by Susan
I have a spreadsheet with several hundred dates in diffferect cells. The dates are typed in as "01/01/2003" but show up in the spreadsheet as a five digit...
September 18th, 2003 01:38 AM
by robert kaye Go to last post
2 437
return in excel by Christian
i have a cell in a spreadsheet, which i was currently displaying the values of two other cells, with a space between the values. what i would like would be to...
September 18th, 2003 01:45 AM
by acw Go to last post
4 272
automatic links by Leticia
I have copied a file to re-use for another purpose. I made my changes, but now it has an automatic link from the original file. I have looked all over to try...
September 18th, 2003 01:50 AM
by acw Go to last post
2 462
Excel 2000 - PivotTable Sort and Top 10 by Craig Padoa
I have just purchased this Micosft published book Accessing and Analyzing Data with Microsoft Excel. I am currently on the Pivot Table section (Chapeter...
September 18th, 2003 02:13 AM
by Debra Dalgleish Go to last post
1 570
last day of month by Radeesh
Hi I am using a formula to get a sum amounts between the first of the month and the last day of the month. I am using 29 as the last day of the month. months...
September 18th, 2003 02:26 AM
by Ron Rosenfeld Go to last post
3 309
Post New Thread


Display Options
Showing threads 201 to 220 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 09:59 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.