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
Area display help by mustbezim
I am trying to find out how to display information over multiple cells. By this i mean i have a formula (not sure if i should use another) (=IF(A6="Wet...
March 4th, 2010 08:41 PM
by Squeaky Go to last post
1 135
Cannot get the column to total with =sum by kmg
I am working on a lengthy worksheet and have many link to one colmn from other worksheets so that I can get the totals of all in the column. When I put in...
March 4th, 2010 08:36 PM
by pmartglass Go to last post
7 165
Formula to return value from multiple sheets if volume matched by Julie HSV
I have a worksheet with average unit prices for =50k, =100k,=200k,=300k,500k and am creating a cover worksheet which will pull the relevant unit cost...
March 4th, 2010 08:31 PM
by Fred Smith[_4_] Go to last post
2 93
Stop numbering rows for Titles by Volunteer_Atwork
Hello, I would like counting of the rows to start at row 5, instead of row 1, because it is just titles that do not need to be counted, in other words,...
March 4th, 2010 08:30 PM
by Gord Dibben Go to last post
3 90
Count Instances by Chad Wodskow[_2_]
I am trying to count the number of instances a list of products appear on a report. The list of products is in a range on a seperate sheet. Line 1. Widget...
March 4th, 2010 08:29 PM
by JLatham Go to last post
4 164
Cancel printing a worksheet by Johnny W.
Actually, I've tried printing by selecting the workbook icon and printing in the blocked sheet and the entire workbook, I've right clicked on a tab and...
March 4th, 2010 08:13 PM
by Johnny W. Go to last post
0 99
Friday thru Thursday by JoeM
I need to pull weekly data (Friday thru Thursday) and also, create my weeks by Friday thru Thursday
March 4th, 2010 07:32 PM
by Ron Rosenfeld Go to last post
8 144
VLookUp Error by Chad Cameron
Hi All, I have the following function: =VLOOKUP(C46,'Pipe and Fitting Details'!C24:D42,2) C46 is a dropdown list. It works for everything except for...
March 4th, 2010 07:23 PM
by Niek Otten Go to last post
2 92
Function help requested please by cinnie
Hello to all I have worked with functions in other programs, but I am totally new to Excel. Here's my situation - I have a table like the following that...
March 4th, 2010 06:55 PM
by Fred Smith[_4_] Go to last post
6 117
edit the cell contents command in Excel 2007 macro by Safia
In Excel 2007, I want to write a macor which edits the cell contnets and goes to right or left adjacent cell and again eidts the cell contents. Will higly...
March 4th, 2010 06:48 PM
by Gord Dibben Go to last post
1 132
Disable automatic text wrap? by Staceyglow
It appears that when one cuts and pastes from one Excel spreadsheet to another, it automatically assumes that you want to wrap text if the column is too...
March 4th, 2010 06:10 PM
by Staceyglow Go to last post
2 110
formula x % format by Neia
I have the following numbers 412 493 1093 Totais 1998 And I need the percent, so I used 412/1998, 493/1998 .... I found the following values 0,206206206,...
March 4th, 2010 06:09 PM
by Joe User[_2_] Go to last post
2 81
Conditionally format a cell using a list of data defined in a rang by Chad Wodskow[_2_]
Is it possible to conditionally format a cell using data defined in a range on a seperat tab? The data sheet information being pulled from the range, and i...
March 4th, 2010 06:04 PM
by Teethless mama Go to last post
2 137
Report using dates as a criteria by UKMAN
Hi I have a register (list) that has headings such as name, start date, end date, course duration in days (4) example is Name Start Date End...
March 4th, 2010 05:10 PM
by UKMAN Go to last post
1 110
Index Match with Min by New Hope UMC
I have 3 columns; Market #, Start Date and End Date Currently when I match Market #1 in Cell A3 the following...
March 4th, 2010 04:59 PM
by New Hope UMC Go to last post
2 115
fill a cell based on another cells value by r2rcode
can i fill a cell with a color based on a value from another cell?
March 4th, 2010 04:56 PM
by pmartglass Go to last post
3 126
Skipping rows by Rob
I'm trying to copy the contents from one sheet to another. My objective is take data that is in a row and move it into a column on another sheet. EX. move c2...
March 4th, 2010 04:52 PM
by Mike H Go to last post
1 96
search for text then add by r2rcode
Cat. No. Cost per M 20 $2.00 W 10 $1.00 M/W 5 $1.00 M 20 $2.00 based on the matrix above i need a...
March 4th, 2010 04:32 PM
by T. Valko Go to last post
3 118
Cancel printing a worksheet by Johnny W.
Having a similar problem where I never wanted a selected sheet to print. The solutions posted at best still printed something when the sheet that I did not...
March 4th, 2010 04:30 PM
by Dave Peterson Go to last post
1 104
Function help needed please. by David D.
I need a formula that can read vertically down the contents of a column of data and list all of the results in another column. I do not want to list...
March 4th, 2010 04:23 PM
by Dave Peterson Go to last post
3 115
Post New Thread


Display Options
Showing threads 2401 to 2420 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 08:10 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.