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 Replies Views Reverse Sort Order
Some cells or styles in this workbook contain formatting that is by [email protected]
Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest...
March 3rd, 2010 02:47 AM
by FSt1 Go to last post
1 1,176
How to give a string of data into different columns by Elton Law[_2_]
Super expert, If I have cell containing a series of data like this .... 1,12,9 1,2,9 1,22,17,18 23,23,1,9 24,21,1 1,23,11
June 4th, 2010 02:24 PM
by Teethless mama Go to last post
8 1,175
Selecting from a list by Mike
I want to be able to select from a list based on the contents of another cell. For example, in A1 I can select the value from a list of 4 options. Cell B1 has...
September 15th, 2003 04:46 PM
by Anon Go to last post
1 1,172
vendor matches by John
This is my first question on this site, so I hope I hope this makes sense. I have vendor numbers in Col A-each vendor number would only be listed one time...
June 4th, 2010 10:43 PM
by John Go to last post
6 1,171
Setting Print Titles on multiple worksheets by Judd Starr
Does anyone know how to set up the same print title on several pages on several worksheets at once?
March 11th, 2004 11:17 PM
by Frank Kabel Go to last post
1 1,170
Fill in Column with a series of repeating numbers by mimi
I am trying to fill in an amortization years column. The first 12 rows are "1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've got...
June 5th, 2010 01:42 AM
by David Biddulph Go to last post
2 1,167
How do I extract specific data out of a cell to another cell by red bioroid
Anone one got any ideas on this? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet...
September 15th, 2003 12:27 PM
by Ron Rosenfeld Go to last post
1 1,163
Determine "on time" status by Teri
I'm trying to write a formula to determine if a delivery is on time. In the example below, I used =IF(O6=N6,"Yes","No") and Excel returned "No", but this...
June 3rd, 2010 11:18 PM
by Teri Go to last post
9 1,159
fax multiple worksheets by volleyman
does anyone know how to fax multiple worksheets in the same fax job? I am using MS Windows 2003 Fax Services and Office 2003 running on Windows XP. when I...
March 30th, 2005 05:51 PM
by volleyman Go to last post
0 1,155
Can I SUM column C IF Column A=X AND Column D=Y? by Minx
If you could follow that... I have a number of columns of information for any given row. I would like to set up a sheet that will sum Column C for all rows IF...
(Multi-page thread 1 2)
April 25th, 2010 06:52 PM
by Gord Dibben Go to last post
10 1,154
Change Font Color when I type the letter by Anne Fu
I need to know how to set up a function (maybe) to change the font color when I type the letter. For example, I have a field (column) contains Femal and Male...
May 19th, 2004 06:06 AM
by support Go to last post
3 1,153
Copy cell format to cell on another worksht and update automatical by kevinm
I have two worksheets, I have entered the formula for a cell on the 2nd worksheet so that the cell contents are copied from a cell on the...
(Multi-page thread 1 2 3)
May 19th, 2005 11:07 AM
by paul Go to last post
21 1,148
If/Then Formulas by Bk Goto
Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any...
(Multi-page thread 1 2 3 ... Last Page)
August 13th, 2008 09:27 PM
by John C[_2_] Go to last post
38 1,148
Pre-configuring Pivot table "views" by Mahurshi Akilla
I need to create several different pivot tables from the same set of data. However, I need to keep switching between the different tables and it quickly...
June 4th, 2010 06:42 AM
by Roger Govier[_8_] Go to last post
4 1,146
Totaling columns by John
I was so impressed with the wonderful responses and spot on answers to my first question on this site I thought I would give this one a try. I did try to...
June 6th, 2010 03:15 AM
by John Go to last post
4 1,146
Copying daily data from one tab to a weekly summary table by Dam
I have been working on this for a little while now and can't seem to grasp the right formula to use. I have columns of data sorted by name to be tracked...
June 3rd, 2010 06:54 AM
by Jacob Skaria Go to last post
6 1,144
Match Last Occurrence of two numbers and Count to Previous Occurence by Sam via OfficeKB.com
Hi All, Thank you very much for taking the time to provide various formulas. I need to find /match the LAST time two specific numbers appeared together and...
(Multi-page thread 1 2 3 ... Last Page)
April 4th, 2005 02:17 PM
by Max Go to last post
33 1,144
modifying T. Valko ws function by Steve
Howdee all. I received some help from T. Valko back in January on a complicated worksheet function. It's been working really great, and today I found that I...
June 1st, 2010 09:30 PM
by Steve Go to last post
5 1,137
Excel Printing by Annette
In lotus, a print button could be defined on each spreadsheet within a file. So when I wanted to just print spreadsheet "A" I would click on the "print" button...
October 17th, 2003 01:14 AM
by RagDyer Go to last post
2 1,135
Change 18-digit dec number to hex by Toria
Hello, When I have this number, 268435457800737937, Excel gives me an error when I do the DEC2HEX formula. In an online converter, I get 3B9ACA06B551480....
(Multi-page thread 1 2)
March 12th, 2009 10:05 PM
by Toria Go to last post
10 1,126
Post New Thread


Display Options
Showing threads 121 to 140 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 06:08 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.