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
How to print file path in footer as default option for all files? by Loisita
Every time I go to print format option and make a custom footer containing the file path. Can I make this a default option?
September 19th, 2008 07:45 PM
by John Bundy Go to last post
2 143
Excel drop down menus by Paetra
Alright so my question is how do you create a drop down list that once an item is selected it will automatically fill in the rest of the information for...
September 19th, 2008 07:43 PM
by Peo Sjoblom[_2_] Go to last post
1 108
Vlookup stops working??? by Steve Peel
I use this formula frequently and have had some trouble with it. Recently, I opened a file that uses this formula and got a message that said "Unable to...
September 19th, 2008 07:08 PM
by Steve Peel Go to last post
0 126
count function by monkeytrader
i have a column of 3, 4, and 5 letter symbols and want to separate the data according to numbers of letters. ex: abc abcde abcd def defg ghi
September 19th, 2008 06:53 PM
by Mike H Go to last post
2 99
Excel Function Help please by TotallyConfused
Please help with this function. I am using the following function to identify dupes in my list. "=IF(COUNTIFI(B$1:B$1000,B1)1,"DUP,"NO DUP")". However, I...
September 19th, 2008 06:30 PM
by T. Valko Go to last post
3 118
Countif excluding hidden rows by qh8519a
I would like to count the total number of "1"s and "2"s across a range of (b8:cu30000). I have an autofilter set up and I would only like to count the...
September 19th, 2008 06:22 PM
by T. Valko Go to last post
4 172
How can I display formula values instead of the formula? by Spiky
Ok, gotcha. I'm not sure how the Watch window helps show parts of formulas calculated. That's what confused me before. Well, you can highlight a section of a...
September 19th, 2008 06:01 PM
by Spiky Go to last post
0 122
Formula to find and list duplicates by Charlotte B
I have two columns consisting of 1000 cells that each have 7 digits. For example 8956743 8658237 8967842 8753689 8974389 8896536 These two...
September 19th, 2008 05:32 PM
by T. Valko Go to last post
4 185
not sure if i'm using the right thing by Tiffany
Hi, I have a spreadsheet that i have entered all my data and what i would like to do is creat dropdown menus at the top of each list so that i can easily...
September 19th, 2008 05:21 PM
by Tiffany Go to last post
4 121
How do I 'count' the number of entrances in filtered cells? by Mike Prentice
I am producing a speadsheet containing text date which I have filtered using the auto filter box. The raw date is a list of different categories of text...
September 19th, 2008 05:01 PM
by Dennis Go to last post
2 117
consolidate and compare workbooks in excel by SC Diane
I have a list in excel (version 2003) with employee data that I need to match to an insurance billing. Both workbooks have Employee names, SS#'s, Insurance...
September 19th, 2008 04:42 PM
by Peo Sjoblom[_2_] Go to last post
1 139
I have dual monitors, how can I view excel workbooks side by side by Johnson County
When I try to move an excel workbook from one dual monitor to another it pulls whatever excel workbook I have open over to that screen. It will only stack my...
September 19th, 2008 04:33 PM
by Dave Peterson Go to last post
1 139
formula help by Shallow
For me this seem like rocket science I have a feeling it will take you guys 1 min I am trying to build a football pool sheet I would like to have a formula...
September 19th, 2008 04:29 PM
by Shallow Go to last post
2 120
emailing excel worksheet from excel program d/n work? how to fix? by karlv
I am trying to email a worksheet from within the excel program. it worked before but now d/n work. this works with my other pc. is there a procedure to fix...
September 19th, 2008 04:21 PM
by Spiky Go to last post
1 120
how do i do profit formulas by wendy
HI IM DOING A ECDL COURSE AND I STUCK I NEED TO NO HOW TO DO PROFITS FOR SALE COSTS -- wendy
September 19th, 2008 04:02 PM
by Bob Phillips[_2_] Go to last post
1 102
IF - And - Then Statement question by MayJuneJuly
Could you help me to write and if-and-then statement? example: Col A Col B C BSY I am trying to have the statement read: IF Column A = C AND...
September 19th, 2008 04:00 PM
by MayJuneJuly Go to last post
4 117
Counting dates with Conditional Formatting by NM
I have 3 columns a,b,c.Column a,b contains dates.The dates in these columns turn red if it is less than today.Column c is Status field which contains D or...
(Multi-page thread 1 2)
September 19th, 2008 03:23 PM
by NM Go to last post
13 406
Vlookup Formula Help by Gmata
I have to spread sheets with similar fields but one has ITEM number and the other one doesn't. I need them to match so i can have the same item number on the...
(Multi-page thread 1 2)
September 19th, 2008 03:10 PM
by RagDyeR Go to last post
11 209
ListBox Drop Down Font Size by Phil B.
When developing a List Box using "Data/Validation" (Excel 2002), the drop down text font is very small. How can you change this font size? Thanks
September 19th, 2008 02:43 PM
by Phil B. Go to last post
2 128
Formula by Mark
I am having trouble with the following formula: =SUMPRODUCT(--(RBS!A2:A9999="1/4/2008"),--(RBS!A2:A9999="31/3/2009"),--(RBS!M2:M9999="Directors...
September 19th, 2008 02:16 PM
by Bernie Deitrick Go to last post
2 128
Post New Thread


Display Options
Showing threads 20161 to 20180 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 09:03 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.