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
What If or conditional formatting? by Avicayia
I am trying to create a spread sheet for company shirt orders. I don't know if this is possible, but I hope that it is. I have two cells. In the first cell...
January 11th, 2010 09:23 PM
by JCS Go to last post
4 172
Format within a Function by JAC
I am using the "IF" function, and want to have a different format for the different values. For example, if the is true, I want to say "Window," but if the...
January 11th, 2010 08:58 PM
by Bernard Liengme Go to last post
1 166
Vlookup with more than 15 digits by Julie
I'm using Excel 2003 and need to do a vlookup with more than 15 digits. Is this possible?
January 11th, 2010 08:49 PM
by Eduardo Go to last post
2 148
CONCATENATE FUNCTION by tadwestie
Please I am so frustrated!! I have two columns of data, C and D In the first column it is a url, and the second column a file url. I need to combine the...
January 11th, 2010 08:42 PM
by Eduardo Go to last post
3 135
Specific word - font color change by Kerrie Riggs
Is there a way to type in a specific word in an excel spreadsheet and have that word only changed to a different font color? Submitted via EggHeadCafe -...
January 11th, 2010 08:37 PM
by Pierre Go to last post
1 189
Unable to see custom Ad-Ins ribbon tab in Excel 2007 + Windows 7 by JoeU in Texas
Worked fine in Excel 2007 on XP. This ad in file just links to several frequently used macros. It has been enabled via Excel Options/Ad-Ins, the location of...
January 11th, 2010 08:01 PM
by JoeU in Texas Go to last post
0 170
WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN? by twerp
I am trying to create a pivot table and I keep getting the message "Data source reference is not valid". What is that referring to?
January 11th, 2010 07:49 PM
by Pierre Go to last post
1 248
test posting calculations formula tab by Rebecca
Test posting -- working with customer service; please ignore Using complicated formula, link to another tab
January 11th, 2010 07:28 PM
by Rebecca Go to last post
0 136
test1 v-2masa by v-2masa
posting a new thread as per customer's request who's calling in MS customer service line reporting an issue about posting new questions. Please disregard....
January 11th, 2010 07:23 PM
by v-2masa Go to last post
0 88
Help with a formula by mom2hallie
I'm trying to create a formula to do the following, can someone please help?? I want to take the sum of B25 & B26 and divide that sum by the sum of B40 & B41...
January 11th, 2010 07:04 PM
by Lars-Åke Aspelin[_2_] Go to last post
1 94
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
conditional function? by Joann
I have two columns in a spreadsheet in which some of the data matches in column A and in Column B. I would like for the data to hilight if the data does not...
January 11th, 2010 06:22 PM
by David Biddulph Go to last post
1 123
Same Date a year ago by Joe
I am using =DATE(YEAR(B2)-1,MONTH(B2)-0,1) to return the same date for the previous year. If B2 is 12/31/2009 it returns 12/1/2008 instead of...
January 11th, 2010 04:14 PM
by Ashish Mathur[_2_] Go to last post
4 122
Parameter "TwoDimension" on RowVector function by andrew79
Hello, Once I have entered the 2 first parameters (InputArray, RowNumber) of the "ROWVECTOR" function, When I am entering the 3rd parameter called...
January 11th, 2010 04:06 PM
by David Biddulph Go to last post
1 106
Need help comparing 2 columns of number to find unique numbers by BP
I have 2 columns of numbers. The first column is a list of unique IDs (221 IDs) that have signed up for a training program. The second column is the full...
January 11th, 2010 04:05 PM
by Ashish Mathur[_2_] Go to last post
3 107
Restricting entry by scubas
Hi, I have a simple spreadsheet which I need help with. I need to prevent a customer from using more then one computer (C*) and or laptop. What I need is a...
January 11th, 2010 03:34 PM
by Stefi[_2_] Go to last post
1 102
Lookup functions-V lookup by Manju
Hi, can some one help me with below: I have a huge data in excel work book 2003 approx 25000 rows, For example 1: ID CODE Balance...
January 11th, 2010 01:32 PM
by Arvi Laanemets Go to last post
1 78
Listing only the workdays of a month by Joe
I want a formula that can check on a date such as 1/1/2010 and return all the work days for January for example. I...
January 11th, 2010 01:22 PM
by Arvi Laanemets Go to last post
4 114
Vlookup not working to merge workbooks? by Heather
HI, I have 8 workbooks, each with one work sheet containing an identical column A then the next three columns in each contain unique data that I want to...
January 11th, 2010 12:18 PM
by Heather Go to last post
2 107
Hide Raws even the Auto Filter is active by Saji
How to hide the raws permentanly of the Excel sheet 2003, even when the filter is active? If the filter is active, the hidden raws again unhide when we...
January 11th, 2010 11:42 AM
by Saji Go to last post
3 155
Post New Thread


Display Options
Showing threads 3981 to 4000 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:09 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.