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
Range of a merged cell by ~L
Is there a function that returns the range covered by merged cells? For example, if A1 through A5 are merged, what function would return A1:A5 if one of the...
September 14th, 2006 07:21 PM
by ~L Go to last post
0 93
Index if conditional sum equals a value. by ~L
I have several columns of data. Column A is names, column B is hours, column C is dates. I'm looking for a formula that returns the date when the sum of...
February 9th, 2007 04:49 AM
by T. Valko Go to last post
2 48
Sumproduct Excluding Array by ~L
Hi, I have a list of names and a list of names with a list of values and I'm using Sumproduct to compare the two and give the sum of the values for each...
December 20th, 2006 10:07 PM
by T. Valko Go to last post
6 52
Conditional sum matching two columns and a row by ~L
I have a program that exports data to excel arranged like the following: Property 1 Property 2 ...
September 26th, 2006 07:28 PM
by Biff Go to last post
9 165
Formula Help IF? by ~Natasha~
I am in need of some help. I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know basics so I am running up into a problem once I pass 7...
September 22nd, 2004 04:44 PM
by Dana DeLouis Go to last post
7 116
comparing columns by ~Q
how do i compare a Cell A1 in Worksheet 1 to the whole Column B in Worksheet 2 to see if part of any of the contents in Cell A are anywhere in the list...
November 17th, 2005 08:41 PM
by Kleev Go to last post
1 89
Average more than 30 numeric arguments by ~SB
I need help on how to average more than 30 numbers in a single column when the numbers are not in contiguous rows. Excel tells me I can only have 1 to 30...
February 2nd, 2010 02:49 PM
by Lori Miller Go to last post
8 146
"the formula in this cell differs from the formula in this area o. by ~Summiya~
I keep getting this error "the formula in this cell differs from the formula in this area of the spreadsheet" when I put a formula in my time spreadsheet. I...
November 27th, 2005 11:10 PM
by Niek Otten Go to last post
1 723
Formula request by ~~~AAA~~~
I am trying to set up a formula each time the data changes in column A without having to do it manually. The formula would be using two other columns of data...
September 14th, 2006 05:05 AM
by Biff Go to last post
1 66
¤¤¤s¥«ªF¤ÉÂí¸fµØ°s©±-¶À½ä¬r by ¦@²£ÄÒ
http://onfinite.com/libraries/175399/440.jpg
November 27th, 2006 08:46 PM
by ¦@²£ÄÒ Go to last post
0 113
¤j³°ª±Lineݯ¤k by ¦óÄ_Às
@@ +86 13925265554 ´¶³q¸Ü¤k¤k-¼sªF¸Ü¤k¤k
June 22nd, 2007 01:22 PM
by ¦óÄ_Às Go to last post
0 80
³Ì·s¤â¾÷¶}*ܯS»ù, ¥itrade-in¤â¾÷ by ¦¿°¶±j
¦¿¥ý¥Í 24230092
August 15th, 2009 03:48 AM
by ¦¿°¶±j Go to last post
0 178
Type a number and data appears from another sheet by ©®
I have a document that lists volunteers and their personal info (name, email, phone etc.) with the Week number (1-5) of the Sunday when they help out. Some...
December 13th, 2007 01:51 AM
by Pete_UK Go to last post
2 86
¡É ±M¦¬¤â¾÷,«Oµý³Ì°ª»ù! by ªËªË
~ ¹q 28811084 °Ý»ù,¥þ´ä¦aÅK¯¸§¡¥i¥æ¦¬,¦nÃa³£¦¬.
August 9th, 2006 04:41 PM
by ªËªË Go to last post
0 77
seperate block of data to different columns by ­}­}¥J
Dear all, I have got some data something like this: | From: | Port: | | From: | Port: | | From: | Port: | | From: | Port: | | From: | Port: |
April 24th, 2004 03:53 PM
by ??? Go to last post
2 162
How to create a macro which performs a copy-and-paste task every 5mins after data is refreshed from web page? by ­»´ä®a©~¸Ë­×
I have built a web query in my worksheet and the data are imported every 5 minutes. I am trying to copy and paste the lastest data to the far right column so...
December 5th, 2006 09:57 AM
by ­»´ä®a©~¸Ë­× Go to last post
0 112
¤J¾¤À°±æ by ±þÀs¦â¡@
¦¬Å¥ÂI¼Ëª±¤k¤k! +86 13925265554
August 23rd, 2007 08:01 PM
by ±þÀs¦â¡@ Go to last post
0 114
¤J¾¤À°±æ by ±þÀs¦â¡@
¦¬Å¥ÂI¼Ëª±¤k¤k! +86 13925265554
August 23rd, 2007 08:01 PM
by ±þÀs¦â¡@ Go to last post
0 62
Midnight will not display in cell by ·!¦[··ï¡?¡ï·»Gen°Digger«·ï¡?¡ï··]¦!·
Ok... jeepers.. another problem... ggrrrr When I enter the time of midnight using military format 24:00, or using 0:00, it does not display in the cell, but...
October 23rd, 2007 11:03 AM
by David Biddulph Go to last post
3 89
Letter and numeral separation by º¼ÖÝÈË
Letter of alphabet and numeral separation If A1= asd123dsa, how to get the B1= asddsa, C1=123
(Multi-page thread 1 2)
April 27th, 2005 08:55 PM
by Sandy Mann Go to last post
13 177
Post New Thread


Display Options
Showing threads 87761 to 87780 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 03:52 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.