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 Reverse Sort Order / Thread Starter Last Post Replies Views
"count if" function based on value of another cell by Anauna
Hello, (Excel 2003) Column A contains list of buildings (25+ building names, 1000+ rows) Column D contains a letter indicating if work done ("c") Column E...
February 24th, 2005 07:33 PM
by Bernie Deitrick Go to last post
3 184
"Count" specific field by Deepak
Hi all Please help me to sort out the following Problem: I've a list in excel with headers as: Telephone No. Name Recharge Date ...
June 17th, 2004 10:21 PM
by Alan Beban Go to last post
5 458
"countif" and "and" functions by PamO
Is it possible to use a "countif" function with an "and" function which will give the numeric value of cells in different columns, but the same rows, that meet...
September 14th, 2004 04:06 AM
by Max Go to last post
2 125
"COUNTIF(AND" by John_Lamb
I have 2 columns of data the first contains students classes, the second their gender. I would like to enter a function that counts the male or female students...
February 27th, 2005 11:33 PM
by John_Lamb Go to last post
4 112
"COUNTU" function in Excel to count unique entries in a range by WayneL
In order to count the number of unique entries in a range of cells, a very complicated nested set of functions (SUM, IF, FREQUENCY, MATCH, LEN, etc.)...
(Multi-page thread 1 2 3)
September 19th, 2008 03:50 AM
by T. Valko Go to last post
20 999
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du by TC
Excel 2003/ Is there a way I can use the "Criteria Range" in the "Data/Filter/Advanced Filter" tool to select duplicates in a multi-column, many-line...
May 12th, 2005 02:06 AM
by Jason Morin Go to last post
1 133
"Data Entry" by Don
I'd like to develop a sheet for entering client information. Single sheet looking something like an application. This data, upon hitting an enter...
May 27th, 2004 06:44 AM
by Frank Kabel Go to last post
1 162
"dated if" statement by todd
IF(AND(DATEDIF(Q14,V$7,"Y")-2,$C14=$C$1),($AA$2*8/24)* ($E14/40) Hi, I am working on a set of dated if statement that I have copied from an old worksheet. ...
November 11th, 2003 02:50 AM
by WShelton Go to last post
3 166
"Delete sheet" not an available option on File menu. by cj6855
I am trying to delete a sheet from a simple two sheet document. However, following MS's instructions - select the sheet tab then go to "Delete Sheet" under...
June 10th, 2005 09:22 PM
by Trevor Shuttleworth Go to last post
1 118
"delete" function by deb
I want to be able to delete an entire row, if a certain cell within the row comes up with a certain value. Example: IF(B12="NA",DELETE12:12) Is there a...
June 23rd, 2004 05:47 PM
by Juan Sanchez Go to last post
1 382
"Drop the lowest" in computing average by Matthew Leingang
Hello, First, let me say that I have a solution to this problem but I am looking for a better one. Second, I apologize if this gets a little long. I keep...
June 8th, 2005 12:31 AM
by Myrna Larson Go to last post
8 213
"E" for even numbers. "O" for odd numbers. by jenn
hi there I need a formula that will produce "E" or "O" for even or odd numbers in columnA. I have tried messing around with =if(A1=iseven,"E","O") but not...
June 24th, 2005 03:45 AM
by jenn Go to last post
9 136
"E" or "O" for the first, even or odd digit in a number by jenn
hi there! I need a formula, to say "E" if the first digit of a four-digit-number in A1 is even. and "O" if its odd. Thanks a lot!
June 24th, 2005 04:11 AM
by Ron Rosenfeld Go to last post
2 96
"END mode?" by Roland
If you hit the End key the word END appears in the status bar and there are shortcut keys to use when in "END mode". But I can not find an explanation of what...
August 12th, 2005 10:27 PM
by Chip Pearson Go to last post
2 103
"Excel Function Dictionary" new URL? by Markus L
http://homepage.ntlworld.com/noneley/ (Peter Noneley's excellent Excel Function Dictionary) is not accessible any more. Couldn't find a new URL. Hope somebody...
February 19th, 2005 06:02 PM
by Ron de Bruin Go to last post
1 100
"File" menu item disappeared from "Worksheet Menu Bar" by gettarun
Hi, I am using Excel 2000. Suddenly have found the "file" menu item missing (not near the "Edit" item) on the "Worksheet Menu Bar". Tried running - Excel /a...
May 1st, 2004 01:08 PM
by Dave Peterson Go to last post
1 439
"Find" through entire Workbook by AMMC
How do I use the "Find" function to search through an entire workbook instead of just one sheet in the Workbook?? Any advice would be greatly appreciated.
June 18th, 2004 04:40 PM
by Stephen Dunn Go to last post
3 188
"Fixed Objects will Move" by Kristen
When working with filters in large Excel spreadsheets, I get to a certain point where I start to encounter a message "Fixed Objects will Move" (to which I can...
September 3rd, 2004 04:16 AM
by Debra Dalgleish Go to last post
1 323
"Formula omits adjacent cells" Error. by John Prendergast
I have started using Excel 2002 on a XP Pro system. I use excel to chart stock values. With this ver of excel, the range of cells that are refereneing data...
February 7th, 2004 07:57 PM
by Gord Dibben Go to last post
3 512
"Global" search in a workbook by Görel
I have a large workbook with several sheets with similar contents. I need to search for various text strings in the workbook and want to find all occurrences,...
January 15th, 2004 11:16 PM
by A.W.J. Ales Go to last post
2 165
Post New Thread


Display Options
Showing threads 21 to 40 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:35 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.