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
Adding numbers based on Range by Carla
In the C column I have categories and in the J column I have Hours Is there a formula to where I can look up the category "Library" in C and add only those...
June 18th, 2009 03:25 PM
by Shane Devenshire[_3_] Go to last post
2 137
Return a value if item does not appear on list by Staceyglow
I'm sure there is a way to do this with VLOOKUP or a similar function, I just don't know how..... I want to compare two lists of numbers. If the second list...
June 18th, 2009 03:13 PM
by Staceyglow Go to last post
2 136
3 Weeks Forecast-Excel 2003 by Denver
Hi, Jan3-8 Jan10-15 Jan17-22 Jan24-29 Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7 RcvdRL 6728 6732 7462 ...
June 18th, 2009 03:01 PM
by Denver Go to last post
4 213
COUNTIF function for multiple criteria by yorkshirelass
I hope someone can help me. I devised a s/sheet in Excel 2007 using the COUNTIFS function. However, not all my colleagues like 2007 and have reverted back to...
June 18th, 2009 01:45 PM
by Bernd P Go to last post
8 305
Replacing only the empty cells. by Colin Hayes
Hi In column P I have cells which are blank , and cells which have word content. I need to replace all the blank cells with the words 'A-Z' , and leave...
June 18th, 2009 01:44 PM
by Colin Hayes Go to last post
3 234
insert muliple rows, every 4th row by davisk
I have one column with data down the first 50 rows. I need to insert 3 new rows for each of the existing rows of data. I failed an attemp using a formula...
June 18th, 2009 01:41 PM
by Dave Peterson Go to last post
7 276
Excel 2003 by RJ
Where can I find the Auto FIll Options Button in Excel 2003?
June 18th, 2009 01:22 PM
by RJ Go to last post
2 226
Help with multiplication formula by Josh W
1) I want to do the following calculation in cell E20: total of cells D1 to D20 multiplied by 3. What is the correct formula? 2) Also if I want to add up...
June 18th, 2009 01:20 PM
by Jacob Skaria Go to last post
3 217
formula recalculation in Excel 2003 - oddity? by Jarek Kujawa[_2_]
have 2 worksheets in a workbook with SUM functions summing up several cells/rows above them in worksheet 1 SOME of those SUM functions recalculate ONLY...
June 18th, 2009 10:57 AM
by Jarek Kujawa[_2_] Go to last post
3 222
Force entry into cell, based on validation selection in adjacent cell by Richhall[_2_]
Hi I've looked at other posts and can't seem to find what I need so apologies if it is posted elsewhere. I have two columns, the first column has validation...
June 18th, 2009 10:28 AM
by Richhall[_2_] Go to last post
3 440
transpose array of non-adjacent cells by ignite ice
I have a range of cells in a single row. This range is C3:AD3. I am trying to transpose this specific cells from that range into a single column, B34:B43. In...
June 18th, 2009 09:58 AM
by Ragdyer Go to last post
3 218
Hyperlinks to many Sheets within a Workbook by hardeep.kanwar[_11_]
Hi! Experts I have Workbook which have 98 Sheets include a "UNIQUE LIST" Which have Names of the Sheets. Now i want to insert Hyperlinks in the "UNIQUE LIST"...
June 18th, 2009 08:48 AM
by hardeep.kanwar[_15_] Go to last post
5 281
Need to convert Minutes:Seconds format to minutes with seconds con by Cliff
Need to convert Minutes:Seconds format to minutes with seconds converted to a decimal
June 18th, 2009 05:22 AM
by David Biddulph Go to last post
3 226
Numbering by Kumar
Hi there. I would like to inquire on how to create formula for sequential numbering for examples given below: 1. CMD/BCN/AMD/001 2. CMD/BCN/AMD/002 3....
June 18th, 2009 04:55 AM
by Rich/rerat Go to last post
3 224
Conditionally format entire worksheet by JDesmarais
I want to format the worksheet to look in every cell for a letter and if that letter is present, color the background a color. I cannot figure out how to...
June 18th, 2009 02:23 AM
by T. Valko Go to last post
3 214
margins keeping changing by excel margins
everytime i try to print out a full work sheet on excel it keeps changing my margins and not taking up the whole page...how do i fix that?
June 18th, 2009 02:16 AM
by Bassman62 Go to last post
1 218
June 18th, 2009 02:07 AM
by Max Go to last post
4 215
find duplicates with the first three digit that are the same. by Steved
Hello from Steved Can I please find duplicates with the first three digit that are the same. And can the bottom formula be Altered please to do...
June 18th, 2009 01:52 AM
by Steved Go to last post
2 186
I forgot how to duplicate SCH 051 by Steved
Hello from Steved With the formula below why is it not displaying "dup" for "SCH 051" "SCH 051" please. =IF(COUNT(F3,B3)2,"",IF(F3=B3, "dup","")) SCH 051...
June 18th, 2009 12:28 AM
by FSt1 Go to last post
3 231
retrieving deleted spreadsheet by sugamola
Somehow my expense spreadsheet was deleted.Is there anyway to retrieve it?
June 17th, 2009 11:40 PM
by Gord Dibben Go to last post
1 282
Post New Thread


Display Options
Showing threads 10001 to 10020 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:48 PM.


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