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
Conditional Formatting 4th Condition by Dax Arroway
Help with conditional formatting please. I'm designing a "tickler" sheet to get cells to color by comparing itself to the date of another cell. There's 4...
April 2nd, 2010 05:45 PM
by Dax Arroway Go to last post
3 116
Conditional Format Tracker by Date by Dax Arroway
I'm building a tracker to make sure paperwork is done on time. Headers: A:Name B:IDNum C:Phone D:StartDate E:Plan F:Paperwork G:30DAuth H:90DAuth
February 3rd, 2010 09:14 PM
by Dax Arroway Go to last post
0 101
Simple Question Complicated Formula by Dax Arroway
I have a long formula that I'm trying to...
December 17th, 2009 03:03 AM
by Tom Hutchins Go to last post
1 104
CF to Color-Fill Row B:G w/Specific Text in One of the Cells by Dax Arroway
Hi All, I'm in Excel 07 and I have a worksheet which is populated from another worksheet, INDEX-formulas in all cells. Range is B2:G25. Column C gets...
December 2nd, 2009 08:11 PM
by Gord Dibben Go to last post
2 114
Room Occupied Checker Formula Help by Dax Arroway
I have a worksheet with Headers: A:Name, B:StartDate, C:Room#, and D:EndDate. I'm looking for a formula that will check the availability of a room based on...
December 1st, 2009 01:14 AM
by Dax Arroway Go to last post
5 90
Apply CF to Row after CF was applied to Column by Dax Arroway
Can someone please help me? I've read through the postings and the help files but still can't seem to figure out how to do this. I've applied conditional...
November 17th, 2009 07:51 PM
by Pete_UK Go to last post
3 101
CF to Row after CF is applied to Column by Dax Arroway
Can someone please help me? I've read through the postings and the help files but still can't seem to figure out how to do this. I've applied conditional...
November 17th, 2009 06:58 PM
by Dax Arroway Go to last post
2 115
CF for Row when CF is applied to Column by Dax Arroway
I've read through the postings but can't find an answer to my issue. Seems simple enough but I can't figure it out. I have a spreadsheet which I've applied...
November 17th, 2009 06:56 PM
by Dax Arroway Go to last post
2 133
CF Row after CF applied to Column by Dax Arroway
I've been reading the posts but still don't get it. I have data down columns A:O for 2000+ rows. In Column J, I selected the entire column and applied CF...
December 1st, 2009 06:24 PM
by Gord Dibben Go to last post
4 125
Help w/simple Date Formula please by Dax Arroway
I've got two columns (D, E) headed DOB and Age. Basically what I'm looking for is a forumula which looks at D, puts the amount of years in E as...
June 8th, 2009 10:16 PM
by Shane Devenshire[_3_] Go to last post
6 145
Charting % of Instances by Dax Arroway
I need a chart that shows a number of times that someone's been through our system. I have a list of names in column B. Some are there once, some are...
March 25th, 2009 10:36 PM
by Dax Arroway Go to last post
3 66
Day Counting - OPEN & CLOSED by Dax Arroway
I have three columns: A=Start Date B=End Date C=Days I'd like to count days if there is or is not an end date. So if the start date was two weeks ago but...
November 3rd, 2008 08:46 PM
by John C[_2_] Go to last post
9 255
Current Patient Count by Dax Arroway
Oh Excel Gurus, please hear my plea! I've got sheet1 named Patients with A = Name B = StartDate C = EndDate I'm looking for a formula that I can enter on...
November 19th, 2008 01:23 PM
by vezerid Go to last post
4 66
Count Names NOT #N/A by Dax Arroway
I have a list of names (column A) which ends in a bunch of #N/As (because they include formulas that are... well... N/A) and I'd like to count the names, not...
November 19th, 2008 12:07 AM
by T. Valko Go to last post
2 62
Pull Data from one sheet to another by Dax Arroway
This should be a pretty easy formula but I can't figure it out. Will someone please help? In SQL I'd say GET SS# from Sheet1 where NAME EQ Sheet2!A1. In...
November 20th, 2008 03:44 AM
by T. Valko Go to last post
1 63
CountIf Not Multiple by Dax Arroway
I'm trying to count a column that doesn't match a few selections. For example, I want to count all cells in column A which doesn't contain blue, green, or...
December 9th, 2008 07:51 AM
by xlmate[_2_] Go to last post
6 58
NUB Formula Question by Dax Arroway
How do you got part of the formula to stay and the other part of the formula to change when using the drag down handle? For example: I have A1=data ...
March 24th, 2009 07:46 PM
by Bernard Liengme[_2_] Go to last post
1 63
SUMIF NOT #VALUE Question by Dax Arroway
I'm trying to SUM a range Q3:Q33, but this range has values in it that get calculated from other places that will be calculated through time. In the last...
March 25th, 2009 12:58 AM
by Domenic[_2_] Go to last post
3 61
Excel is totaling wrong by Daxy
I am having a problem with the sum on only one cell of my spreadsheet. I have currency in cells G2 to G7, (ex: $64,000.00) I have a percentage in cells H2...
July 10th, 2006 07:38 PM
by Niek Otten Go to last post
1 131
finding duplicate addresses across 2 worksheets in the same workbo by DAY
I have 2 spreadsheets within the same workbook that contains duplicate addresses. I need a macro or a formula to compare all of the addresses in a column...
February 13th, 2010 01:32 AM
by Ashish Mathur[_2_] Go to last post
2 147
Post New Thread


Display Options
Showing threads 20241 to 20260 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 11:16 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.