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
Count, Sum, Index,Match or other formula needed by Nadine
Using Excel 2003: One row is a set of numbers. I need to match that to another worksheet and find certain results in it. Here's the trick. This second...
May 4th, 2010 09:01 PM
by Tom Hutchins Go to last post
1 96
Identifying a label. by Nicole[_3_]
I have a spreadsheet that I need to edit a label in. The label pops up whenever I click in the cell - it disapears when I click in any other cell of the...
May 4th, 2010 08:05 PM
by Gord Dibben Go to last post
1 77
formatting a spreadsheet help by hj
I have a few different dilemas going on here. First: Can a conditional format be set up in Vista or Windows 7 both 64 bit, and saved in 97-2003 excel saving...
May 4th, 2010 08:04 PM
by Billns Go to last post
4 160
copied from web page to excel sheet and cant remove from sheet by mitch
copied info from web page and pasted onto excel sheet and cant remove contents copied from excel sheet . seems like it is not directly on the sheet.
May 4th, 2010 07:58 PM
by Billns Go to last post
2 93
May 4th, 2010 05:38 PM
by mitch Go to last post
0 93
Excel Security by Patp
•New HP Computer with Windows 7, Home Premium •Tried to install and use MS Office 2002 Pro •Most works well but there are issues with Excel •First,...
May 4th, 2010 05:32 PM
by Gord Dibben Go to last post
2 96
Formula to calculate Latest Cost (inventory valuation) by Curtis[_6_]
I have a worksheet that contains the daily purchases for 4 products. column B contains the products column D contains the purchase price column K contains...
May 4th, 2010 05:28 PM
by Curtis[_6_] Go to last post
6 78
keep formula delete contents by carspjcars
I'm trying to set up a template in Excel. I wish to keep the formula but delete contents, so i can us the same sheet again.
May 4th, 2010 04:46 PM
by Gord Dibben Go to last post
3 101
Vlookup? by Doug
I am trying to sum the cells in column "AY" for each row that has a positive value in column "S" I am very confused and this is what I have so far. Can you...
May 4th, 2010 04:46 PM
by Niek Otten Go to last post
2 72
Macro Help by karim
hi, i want to create a macro which copy the cell of colume "C"(there is a formula in column C) when there is any value in cell of colume "A" and paste only...
May 4th, 2010 04:31 PM
by Luke M[_4_] Go to last post
1 71
counting occurences specific month appears by MM
Afternoon all, You've helped out before and I come to you again. Here's the question... 5 worksheets in my workbook, each representing a different...
May 4th, 2010 04:27 PM
by MM Go to last post
4 95
IF Function Help by Dewayne
This is what I need to accomplish in H15: IF D30=0,0 IF E15/D45 = J30 return the value of E15/D45 otherwise "Error" I've been playing with this for some...
May 4th, 2010 02:55 PM
by Steve Dunn Go to last post
3 115
Aggregating data among multiple workbooks by Kadco
I am currently setting up a workbook. In this workbook I have a data input sheet where people would fill out information. Multiple people will be filling...
May 4th, 2010 02:52 PM
by Otto Moehrbach[_2_] Go to last post
1 87
Formula for competition pairing by Colin[_12_]
I have 20 teams who will each play 10 games against one of the other teams. Can anyone please advise a formula that will match 10 pairs 5 times ensuring that...
May 4th, 2010 10:14 AM
by Pete_UK Go to last post
1 96
change text color when the value become lower than a certain value by change text color automatically
Is it possible to set the text color which can be changed automatically. Say, if 50 is the middle number, the number in the cell higher than 50, the text...
May 4th, 2010 05:15 AM
by Jacob Skaria Go to last post
1 112
Formula to sum based on a change in another column by J Harris
I have a time sheet report that breaks down the employee ID, pay rate, date in, time in, date out, time out, and total hours worked. I need to calculate...
May 4th, 2010 05:09 AM
by Herbert Seidenberg Go to last post
2 98
Vlookup and match part of text in a cell by Joe Phan
Hi, I am trying to match text in an array that may not be exact match in the cell and return the value in the adjacent column. example: look up "today" in...
May 4th, 2010 04:11 AM
by T. Valko Go to last post
3 108
Help with Conditional Format Formula by David K.[_5_]
Hi, How can I highlight cells in a list of numbers on Sheet1 where the number of occurrences of that number on Sheet2 is not equal to 1? Sheet1 has a list...
May 4th, 2010 03:46 AM
by T. Valko Go to last post
6 89
filtering subtotals and if functions by fam
I have amount due in column G, who owes amount in column H, who provided the service in column f. I need to be able to Filter on column f, total amount due...
May 4th, 2010 01:55 AM
by Domenic Go to last post
2 94
how do I achieve my xl spread sheet in Alphabetical order by Generous
how do I structure my spread sheet to decend Alphabetical.
May 4th, 2010 12:34 AM
by JLatham Go to last post
1 79
Post New Thread

Display Options
Showing threads 801 to 820 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 02:49 AM.

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