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 Reverse Sort Order Views
Any experts on "countif" formula using nested conditions by Chuck
I'm trying to get the count of the number of cells that contain a multiple condition using dates. Count the number of instances in cells A1 to A300 which are...
(Multi-page thread 1 2 3 ... Last Page)
April 8th, 2004 06:54 PM
by Chuck Go to last post
31 1,000
Using COUNTIF to search for existence by Epinn
I want to use COUNTIF 0 to determine if a value in column A exists in another column. This works fine for non-blank and non-zero cells. COUNTIF appears to...
(Multi-page thread 1 2 3 ... Last Page)
October 27th, 2006 04:57 AM
by Epinn Go to last post
31 355
SUMIF or SUMPRODUCT to total cells containing multiple texts by Terranoman
I am attempting to set up a spreadsheet whereby I can summarise the weight load of a vehicle. The cells will contain a variation of abbreviated texts in the...
(Multi-page thread 1 2 3 ... Last Page)
October 12th, 2006 08:14 AM
by Terranoman Go to last post
31 235
Sumif / Countif - Not certain - want to extract data from cell and by M.A. Clark
Perhaps this feature is not supported in Excel but here goes.... I have data that represents Sick Time, Holiday Time, etc in single cells on a spreadsheet. ...
(Multi-page thread 1 2 3 ... Last Page)
January 10th, 2008 11:43 AM
by Bob Phillips Go to last post
30 399
Non updatable Unique Random Number by Ian
I work in a hospital and I have a worksheet of data from the patients we treat. One column has their ID number and I want to add a column next to this to...
(Multi-page thread 1 2 3 ... Last Page)
September 28th, 2006 08:19 PM
by Ian Go to last post
30 365
If And Help? by [email protected]
Here is what I need to do: Column G contains a claim number. L contains a combination of letters and numbers, its a code, like v3.7 etc. Column M contains a...
(Multi-page thread 1 2 3 ... Last Page)
August 20th, 2008 03:52 PM
by [email protected] Go to last post
30 240
sumif maybe? by Esradekan
lets try again. Column Headers are (B1:P1) Staff 1 Staff 2 etc A2:A27 is a date range (fortnightly dates range called "Date") B2:B27 are figures relevant to...
(Multi-page thread 1 2 3 ... Last Page)
August 31st, 2008 01:10 PM
by Don Guillett Go to last post
30 420
date criteria to select range by Kstalker
Hello I have a conundrum which is proving very difficult. I have a month set of data which has each day of the month as a header and then a series of metrics...
(Multi-page thread 1 2 3 ... Last Page)
August 23rd, 2005 07:19 AM
by Max Go to last post
30 335
With a Function, how can I get rid of formating codes like div ? by AFSSkier
I have a refreshable spreadsheet with data imported from Access. When the data imports, I get Access formatting codes like div, &nbsp and font codes (see...
(Multi-page thread 1 2 3 ... Last Page)
June 2nd, 2009 06:26 PM
by Ron Rosenfeld Go to last post
30 519
SIMPLE CONCATENATE FUNCTION by Rebecca
I apologize for asking such an incredibly newbie question, but I simply can't get this to work, despite reading the help files and searching this forum. I am...
(Multi-page thread 1 2 3 ... Last Page)
January 11th, 2010 06:38 PM
by Tom Go to last post
30 469
Counting odd & even #s by Ed
Is there a simple way to count "odd" numbers in a column/row? And is there any limit on the size of the actual number? Thanx in advance...
(Multi-page thread 1 2 3)
September 7th, 2007 03:56 AM
by Ron Rosenfeld Go to last post
29 146
Convert variable #'s in a gen. format to a # that can be used w/ma by Steve
I have this data that is pasted to my worksheet: Period: 01/23/2010 to 01/29/2010 - Days: 6 It is in general format. The day numbers will always be in the...
(Multi-page thread 1 2 3)
February 9th, 2010 02:19 AM
by T. Valko Go to last post
29 306
Color Cells Summing by HANYANA
Hi there, i have been trying to get the Color Index summing formula to work but i am unsuccessful, i went onto this...
(Multi-page thread 1 2 3)
January 10th, 2007 03:16 AM
by Max Go to last post
29 168
Cell validation by Sai Krishna[_2_]
Hi, I have a cell where in I need to enter an alphanumeric strictly as under AAAAI7504G The rule is : First 5 should be alphabets, next 4 should be numbers...
(Multi-page thread 1 2 3)
May 24th, 2008 09:41 AM
by Rick Rothstein \(MVP - VB\)[_510_] Go to last post
28 185
insert date by Larry
Hi folks, I'd like to inset a date automatically when ever a cell within a single column is selected. Can I do this?
(Multi-page thread 1 2 3)
July 15th, 2006 02:41 AM
by CLR Go to last post
28 598
extracting numbers by cj
i need a formula to extract numbers. if cell a1 is "3cash 5stock", i want to extract the number "3" to cell a2 and extract the number "5" to cell a3. the...
(Multi-page thread 1 2 3)
February 9th, 2006 04:01 AM
by Ron Rosenfeld Go to last post
28 318
Help with MID Function? by KLZA
Hi. I may not have explained myself well enough in my last post. So here goes again. I'm trying to capture / extract specific data within a string of text in...
(Multi-page thread 1 2 3)
February 4th, 2009 08:35 PM
by Ron Rosenfeld Go to last post
28 197
Array index, match problem by RAP
Hello, Folks. This is my first post to this Discussion Group. I must have Dain Bramage to not be able to come up with an answer, but I can't. I need some...
(Multi-page thread 1 2 3)
August 21st, 2005 07:19 PM
by Alan Beban Go to last post
28 532
Insert Cell Name of a value that matches a MAX function by Al Rios
I have a spreadsheat..with a Max formula, the formula works, but I am also trying to find the cell name of that output. Example Column Names: A1 ...
(Multi-page thread 1 2 3)
May 31st, 2004 08:10 PM
by Al Rios Go to last post
28 452
Counting Unique entry from Concatenated list by Rajat
example of Data -------------------- Col A Col B (By using CONCATENATE function) A a,a,b,d B d,d,c,a C b,h,r what i need in Col C is...
(Multi-page thread 1 2 3)
January 4th, 2007 05:18 AM
by Rajat Go to last post
28 196
Post New Thread


Display Options
Showing threads 41 to 60 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:22 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.