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 Reverse Sort Order Last Post Replies Views
Help with Value in one column... by David M
If you have an ethnicity column I want to go to the next column and for all of a certain ethnicity I want to return either a 1 or a zero. Column A ...
March 26th, 2010 11:20 PM
by L. Howard Kittle Go to last post
3 95
Averaging Times by David M
I am wanting to try and average times, but I do not want to include the 0:00 in the formula for the average. Is there something that I can use to simply...
September 4th, 2009 12:39 AM
by Ashish Mathur[_2_] Go to last post
2 123
Time Extraction In Minutes by David M
This one is hard to explain but I will give it a shot... I have a start time and an end time of an incident...lets say the start time is 1:40am and the end...
May 6th, 2004 09:14 PM
by David M Go to last post
2 367
Pick a Random name from a list. by David M Fritzke
I am working on a Free Give Away of some products. Our systems give me a list of individuals who we have had contact which are then placed in excel. We would...
August 25th, 2006 03:11 PM
by Stafford Go to last post
5 97
How Do I format Background pictures? by David Marinez
Thanks to a member I was able to insert a picture into the background. But now I need to know how do I format that picture. I'm sure it's not difficult,...
July 18th, 2006 09:35 PM
by David Marinez Go to last post
4 140
How Do I Write over Pictures? by David Marinez
I pasted a scan picture onto my spreadsheet. Send it to the back and made it transparent. I want to be able to type on the cells over the picture in order...
July 15th, 2006 02:48 AM
by CLR Go to last post
3 66
Excel should let you sort by subtotals by David Matsumoto
Does anyone know if or how Excel can sort by subtotals without a bunch of workarounds? ---------------- This post is a suggestion for Microsoft, and Microsoft...
May 24th, 2005 02:52 AM
by David Matsumoto Go to last post
2 80
Referecing Worksheet names that are dates in a formula by David McLean
Hi There, I've got a tricky one here, and I'm not sure if anything can be done about it. Here's the situation... I've got a workbook that I use to track the...
March 11th, 2010 12:37 AM
by T. Valko Go to last post
2 120
Single word subjects and anonymous posters by David McRitchie
"Single word subjects and anonymous posters" sure takes any enjoyment out of trying to find solutions and posting replies. You can get a free email address...
November 14th, 2003 12:08 PM
by onedaywhen Go to last post
7 295
Warning -- Do NOT open any newsgroup postings with attachments... by David McRitchie
ALL of the postings with attachments you are currently seeing in the Excel newsgroups ALL have viruses -- DO NOT OPEN. Be suspicious of any posting that is ...
October 4th, 2003 07:21 PM
by Ken Wright Go to last post
8 366
Formula to color cells based on result by David McRitchie
Hi Vinny, Conditional Formatting is certainly the easiest to use and it does not matter how the value changed, but the limitation of 3 formatting choices per...
January 5th, 2004 05:14 PM
by Vinny Go to last post
1 330
Comment Boxes and Gridlines by David McRitchie
Hi Andy, HTML will show borders but your gridlines will be ignored even if you have checked Print gridlines on your setup, sheets it has nothing to do...
June 17th, 2004 04:29 AM
by David McRitchie Go to last post
0 286
Carry forward totals at each page break by David McRitchie
Hi Paul, This is not provided for in Excel. It can get quite messy trying to create such feature. How about a running balance instead. G22: ...
May 18th, 2004 07:26 PM
by paulb Go to last post
1 287
function to place page number in a cell by David McRitchie
http://google.com/groups?threadm=e4FqF7hvCHA.2600%40TK2MSFTNGP11 -- --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: ...
March 25th, 2004 06:39 PM
by David McRitchie Go to last post
0 240
Excel symbols!!! HELP!!! by David McRitchie
Hi Michael, I really don't have any idea what your two columns of data represents, but a char(217) in the wingdings font would be a star. So maybe take a...
March 27th, 2004 07:47 AM
by David McRitchie Go to last post
0 121
HYPERLINK Worksheet Function by David Messenger
Working in Excel 2000. Trying to use the HYPERLINK Worksheet Function to Hyperlink from one sheet to a Cell on another Sheet. I can get it to work easily by...
October 11th, 2007 08:55 PM
by Pete_UK Go to last post
3 67
HLookUp by David Mok
Help! I can get a simple HLookup fundtion working.. see example below: (table and the Hlookup formula extracts the number 0.65 Counter GIL SYNF FRC ...
August 24th, 2007 08:50 PM
by Debra Dalgleish Go to last post
1 76
I need a cell to be blank. by David Moore
I'm linking cells from another worksheet and I have two questions which are somewhat related. 1. When I link the cell using ='Worksheet2'A2 the cell that I'm...
September 17th, 2009 09:26 AM
by Pete_UK Go to last post
4 121
Getting text data from a pivot table by David Morris Evans
AIG Policy # State WC Code DOUBLE HOUR OVER Grand Total WC 968-5711 AZ 8810 11,797 50 11,847 9040 435,558 18,577 454,135 CO...
June 28th, 2007 01:36 AM
by David Morris Evans Go to last post
0 57
Query column for unique values by David Morrison
I have a worksheet that has numerous duplicate values in a column. I'd like to do the equivalent of a SQL "select distinct" but don't know how to do this in...
March 27th, 2004 02:45 AM
by David Morrison Go to last post
3 493
Post New Thread


Display Options
Showing threads 19981 to 20000 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 10:19 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.