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
Adding character to text string by Adam
Hello All, I have a spreadsheet that has customer information. I need to add a few characters to an existing text string in hundreds of fields. For example,...
September 25th, 2003 08:58 AM
by JMay Go to last post
2 342
Script Editor Grayed Out by Adam
I have a file that has three External Database Queries. I am trying to change the Database Path, but the Script Editor is Grayed out. Any idea why it is...
March 12th, 2007 05:55 PM
by Adam Go to last post
1 79
D count Criteria by Adam
I've made a spreadsheet to report on a sheet of raw data. Is there a maximum number of column heading that can be used when defining the criteria? I've got up...
September 13th, 2004 12:24 PM
by Debra Dalgleish Go to last post
4 84
how do i count rows, and count them by color or a highlight? blue. by adam
my goal is to tally some counts, and i have certain rows highlighted for different reasons, i want to have a count of the rows with those certain colors and...
September 9th, 2004 10:05 PM
by Frank Kabel Go to last post
1 284
move cells to other sheet(s) based on color by Adam
ok, I've been able to get the color index for cells and sum only certain colored cells, but what I really is a function to move a row to another sheet once I...
June 15th, 2004 02:43 PM
by Adam Go to last post
1 424
using a decimal point changes cell to label by Adam
When I type a decimal (110.25) it changes it to a label (100. 00). I have reloaded the operating system and the program. Any ideas.
February 28th, 2004 06:11 AM
by Vasant Nanavati Go to last post
1 260
Shortcut to select column? by Adam
Is there a shortcut in excel to select the entire active column? also to select the active row? Thanks Adam
December 17th, 2003 04:38 PM
by Andy Brown Go to last post
1 163
Extracting data from alpa numeric string by Adam
I have about 5,000 alpha numeric records. I need to derive three separate fields from these individual records. For example: ABC5DE -- ABC 5 DE XYZ77EF ...
October 22nd, 2003 07:20 AM
by Harlan Grove Go to last post
2 126
How many records with xl 03 hold? by Adam
The current record limit is 256 columns and 65kish rows, will this be extended in the 2003 version? I've heard that quattro pro looks at 1 million...
October 14th, 2003 05:07 PM
by J.E. McGimpsey Go to last post
1 86
Date re-formatting by Adam
I have data in mm/dd/yyyy format and was wondering how (or if) I could convert that to just day of the year (1-365)? thanks adam
October 13th, 2003 11:43 PM
by Bob Phillips Go to last post
1 131
What function to use? by Adam
What function should I use to find the probability of 2 girls being absent out of 5 total students being absent in a class of 25 total students?
February 28th, 2007 08:51 PM
by Jerry W. Lewis Go to last post
1 40
How do I create a formula to retun a value of 0 (zero) when a VLO. by Adam at GTOFL
When searching multiple tables with a V or HLOOKUP formula, I want a search that doe not find anything to result in a zero instead of an error (#N/A) I have...
February 20th, 2005 07:15 AM
by Ola Go to last post
4 87
SUM Condition by Adam Bradley
I have collumn A as referece numbers such as 0535 which relate to several values in collumn D eg. 0535 £235 0535 £82 0535 ...
June 8th, 2009 04:16 PM
by Shane Devenshire[_3_] Go to last post
4 112
SumProduct making things work slow by Adam Graham
I was using DSUM to sum financial transactions based on a variety of criteria, many of which involved dates. The problem for this is that I would have to...
February 4th, 2007 09:41 AM
by Charles Williams Go to last post
7 146
Excel 97/2000 - Help with looking up external data. by Adam Harris
Hi, Can someone please help me with a formula that I am having problems creating? In a folder I have 500+ 'randomly' named workbooks, plus one...
February 18th, 2005 11:43 AM
by Adam Harris Go to last post
1 113
Returning Multiple Matches by Adam Hodge
I have an worksheet that has data that is sorted like the following Bar NumberProperty Node...
November 13th, 2008 05:09 PM
by Max Go to last post
4 150
Check Boxes by Adam H[_3_]
Hiya, I need to set up two check boxes in excel. The first box needs to be there, on show, all the time, but the second only needs to appear once the first...
February 17th, 2009 11:32 PM
by Adam H[_3_] Go to last post
5 62
Is there a worksheet function that will... by Adam Kroger
Is there a worksheet function that will copy (or return) the value of another cell (not its formula), with the result being stable, even though the orriginal...
November 20th, 2005 08:41 PM
by Ron Rosenfeld Go to last post
1 67
Lookup Problem by Adam L
I have an array of data. I want to use a lookup function to find a particular value, then produce the value directly below this reference. For example if...
February 18th, 2009 10:56 PM
by Lars-Åke Aspelin[_2_] Go to last post
3 72
Excluding formulas in hidden cells? by Adam L. Kehl
If I type 1 in a1 and =sum(a1,1) in a2 then copy a2 and paste it in a3 thru a100 I get 1, 2, 3, 4 and so on all the way down to 100. If I hide several of...
April 10th, 2008 03:35 PM
by Gaurav[_3_] Go to last post
3 85
Post New Thread


Display Options
Showing threads 1201 to 1220 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 12:08 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.