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 do Excel options need to be set to make formulas convert by Kmurray
New problem I think it is associated with the Excel options. In the past week I have been having issues with myVLOOKUP function. Sometimes it will not change...
September 3rd, 2008 05:28 PM
by Spiky Go to last post
3 137
Changing font colors by Tiny
Is there a way to save the colors I use from the pallet?
September 3rd, 2008 05:10 PM
by Spiky Go to last post
1 112
match formula question by Belinda7237
With this current formula: =IF(O221,"",IF(AND(O228,M2TODAY(),Q2100000),"X","")) What would i add to the formula if i wanted to also indicate that if...
September 3rd, 2008 04:48 PM
by RagDyeR Go to last post
1 96
sumif? countif? by Aaron Hodson \(Coversure\)
Hello, I need some help with the following: I require cell K3 (in worksheet named 'brokers') to count the number of times the data in A3 matches those in...
September 3rd, 2008 04:35 PM
by Pete_UK Go to last post
3 125
how to extract digits from a row of numbers by preydd
I have these data in a column: 5100-10650 sales 5100-11250 sales How can I extract only 10650 and 11250 and present it in another column? Thanks.
September 3rd, 2008 04:32 PM
by RagDyeR Go to last post
2 79
Round up whole sheet by Daddy Dool
How can I roundup the whole sheet?
September 3rd, 2008 03:53 PM
by Bernie Deitrick Go to last post
2 82
Import Spreadsheet w. Formulas/Functions into SharePoint List by eugenam1
My spreadsheet has formulas/functions in some of its columns. Can they be imported as part of a SharePoint list or do I lose all formula abilities?
September 3rd, 2008 03:10 PM
by eugenam1 Go to last post
0 80
countif or sumproduct? by arch0072
i have a column with over 2000 alpha character rows that i'm trying to count. I have a the one of the following letters hmyubsqzvtgxce in the rows of the...
September 3rd, 2008 03:02 PM
by Mike H Go to last post
7 78
lookup function to meet two conditions by Sean
I want to use a lookup function to meet two criteria. I have Sales Order numbers in one column and line items in another. So i want to say 'match the sales...
September 3rd, 2008 02:43 PM
by Max Go to last post
2 66
Excel 2007 External Data Links and Subtotals by Tyke
Up until recently I have been creating files in Excel 2003. A lot of these files have included external links to our on site ERP system via ODBC. No problems...
September 3rd, 2008 02:25 PM
by Tyke Go to last post
0 76
Combining duplicate row data by wagz
I have a sheet where the rows contain duplicate column data. I would like to combine the duplicate rows while combining the individual column data. ...
September 3rd, 2008 02:25 PM
by Joel Go to last post
3 70
2008 East Coast US Excel User Conference by Damon Longworth
Hello Atlantic City, New Jersey will once again host the Microsoft Excel / Access User Conference (Trump Taj Mahal) - On September 24-26, 2008. This year...
September 3rd, 2008 01:18 PM
by Damon Longworth Go to last post
0 62
Replace input cell data using Vlookup by gz3cx8
I have a number of employees who each have a unique 8 digit folio number. I have a spreadsheet that my boss wants filling in every day detailing where each...
September 3rd, 2008 01:17 PM
by Mike H Go to last post
1 99
Calculate how much time falls between set start and stop times by Polly
I have a fairly large amount of data involving time. I have a start time, a stop time and elapsed time. I need to know how much of the elapsed time falls...
(Multi-page thread 1 2)
September 3rd, 2008 12:12 PM
by Robin Go to last post
17 225
Reference to a Variable Part of a Cell by Hilvert Scheper
Hi there, Can I Please ask the following question; Is it possible to create a Cell-reference (as a Formula) that will give me just the first line of Text in a...
September 3rd, 2008 11:40 AM
by Hilvert Scheper Go to last post
7 83
area of a rectangle having two sides equal and two sides diffferen by Mr. Rai
How do I find area of a rectangle having two sides equal and two sides different; for example a rectangle having sides as 1.) 90 ft. 2.) 150 ft. 3.) 66 ft....
September 3rd, 2008 09:51 AM
by Rick Rothstein[_2_] Go to last post
3 130
Excel 2007 Ribbon by Clay
My Ribbon will not stay in place on my worksheet. The Formula bar is extra large and takes up the space where the ribbon normally resides. I can open the...
September 3rd, 2008 09:51 AM
by Clay Go to last post
2 99
Change lower case to upper case by Lou_07[_2_]
How do I change text in cells from lower case to upper case. Have tried using a macro but wasn't able to understand the process. I have 2 long columns to...
September 3rd, 2008 09:51 AM
by Mike H Go to last post
6 81
Calculate minutes between dates based on 9hr work days by JQS
Need to calculate "business minutes" between dates. ie...08/29/08 4:00p to 9/2/08 9:00a result in 120 minutes (due to 8a-5p work day, less weekends and...
September 3rd, 2008 09:14 AM
by Bob Phillips[_2_] Go to last post
1 86
Sorting Information by jasonharris10
I will try to explain this as well as I can. I'm mediocre on excel, all self taught so I'm just fumbling through this. I have two sheets. first sheet is...
September 3rd, 2008 08:53 AM
by Pete_UK Go to last post
1 68
Post New Thread


Display Options
Showing threads 20841 to 20860 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:38 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.