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 Reverse Sort Order Replies Views
Offset 2nd ref. by houAstros1989
A B ONE 1 TWO 2 THREE 3 ONE 4 Is there a way I can use the offset to look up a duplicate reference? To where I ref ONE...
December 1st, 2009 08:47 AM
by Ashish Mathur[_2_] Go to last post
3 101
Not to inlcude zero in COUNT by enna49
Hi Please can you help with this problem. I need a count in a column with amounts. The problem being I do require to count the Credits and Debits, but NOT...
December 1st, 2009 07:35 AM
by T. Valko Go to last post
9 88
Data validation - restrict duplicate value by Michelle
Hi! How to set data validation function (in column B) to restrict user from entering same invoice number from same supplier? Column A: Supplier Column B:...
December 1st, 2009 07:35 AM
by T. Valko Go to last post
8 111
Summary by Months by Furby73
I am trying to make a summary of deliveries on a monthly basis A B 1 1/11/09 20.19 2 ...
December 1st, 2009 06:22 AM
by Jacob Skaria Go to last post
2 108
totaling data from a drop down list by cp
Using Excel 2007, I have created a survey and some cells have drop down list. For example, the responses include items such as private practice, physician...
December 1st, 2009 05:50 AM
by cp Go to last post
2 149
Creating a Sheet Index of all Excel Worksheets by K Smith[_2_]
I have been trying find information on creating an Index of all worksheet tabs, within a workbook, that will continually update with changes to the tabs. I...
December 1st, 2009 05:03 AM
by Ashish Mathur[_2_] Go to last post
2 104
Another Question regarding Multiple Criteria by enna49
My apologies if I have repeated myself. As I thought I may have closed off the question yesterday. Hi Following on from this and thank you for your help, is...
December 1st, 2009 04:32 AM
by T. Valko Go to last post
2 128
Current Month with real date by Keyrookie[_33_]
Hey all, I'm trying to have a cell always reflect the current month and year. I'm sure it's a simple formula but I need some help. I'm wanting this formula...
December 1st, 2009 04:20 AM
by Ron Rosenfeld Go to last post
2 101
Calculating total number of days in rolling year by Suede
I'm a novice to Excel and using Excel 2002 ver. I need to keep track of employee absences for my company in a "rolling" 12 month period. e.g. if an...
December 1st, 2009 03:46 AM
by Fred Smith[_4_] Go to last post
1 105
attendance with sorting by cathyong
hi. Needs help. I have an attendance workbook with the 400 names listed as present, absent or excused. Our office needs to see at a glance who are absent for...
December 1st, 2009 03:42 AM
by cathyong via OfficeKB.com Go to last post
4 145
summing adjacent data in a worksheet by Suzie
I have a column of data and I need to sum the values in adjacent cells when they are bounded before and after by cells that contain a value of 0. Then I need...
December 1st, 2009 02:17 AM
by Pete_UK Go to last post
3 131
Prevent functions from changing when new rows are added by Gregg[_3_]
I have a worksheet configured as a timesheet, where each row represents a task performed. For any given day, I track the task(s) performed and the hours...
December 1st, 2009 01:50 AM
by Gregg[_3_] Go to last post
0 113
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
Validation list based on criteria by Gotroots
Hi I want to create a data validation list based on certain conditions. Let me try to explain by example. A1 = oranges B1 = oranges A2 = apples B2 = no...
November 30th, 2009 11:22 PM
by Gotroots Go to last post
0 80
Need to alphabetize data from separate cells within same row by marketingchickie
Hi there, I have a worksheet with 6,500 rows of data. In each row, there are up to 6 cells containing a name in "Last, First" format. I need to alphabetize...
November 30th, 2009 10:55 PM
by Gord Dibben Go to last post
2 96
SumProduct - With Or Function by Benjamin
=SUMPRODUCT(--(A1:A24="Tom"),--(B1:B24="May"),--(C1:C24)) First Array (Names) & Second Array (Months) and Third Array is numbers to sum up. Now I can easily...
November 30th, 2009 10:08 PM
by David Biddulph Go to last post
3 95
Printing issues by DJ
I can print some pages within an Excell workbook, but not all of them. I am getting a security warning. -- DJ
November 30th, 2009 09:34 PM
by DJ Go to last post
0 84
PRINTING ISSUES by DJ
I am having trouble with one page not printing within a workbook. I can send some pages to the printer and they will print but one page in particular will...
November 30th, 2009 09:32 PM
by DJ Go to last post
0 95
Pull data from one worksheet and place in a new worksheet by smiall
I am looking for a way to use a cell value to separate a worksheet into multiple worksheets. Any help, macro, etc.. please
November 30th, 2009 09:06 PM
by Luke M Go to last post
2 142
Comparing 2 worksheets in Excel 2007 by Sue
I am trying to compare 2 worksheets in a large workbook. One sheet is named 1st Proposed HMIs. The other is named 2nd Proposed HMIs. Both spreadsheets are...
November 30th, 2009 08:13 PM
by ryguy7272 Go to last post
1 132
Post New Thread


Display Options
Showing threads 5041 to 5060 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 07:53 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.