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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Needed Macro and Function Help by GEdwards
Using Excel 2003 I have 2 Workbooks. MY GOAL... WB1, worksheet "Input Data" needs to search for an entry in column B of WB2, worksheet "Data Sheet". If the...
April 21st, 2010 06:06 PM
by GEdwards Go to last post
1 178
Protecting an excell workbook by cufc1210
I have a workbook which has 15 worksheets in it. It is on a network drive so other people can access it. I want to allow people to view the workbook without...
April 21st, 2010 05:41 PM
by trip_to_tokyo[_3_] Go to last post
2 254
defaulting to Euros by dstiefe
Somehow my excel file defaults to formatting numbers in Euros how do i change that in 2007? when i first started everything was just entered as a regular...
April 21st, 2010 05:01 PM
by dlw Go to last post
3 262
When I search this group w/my user name nothing from 2010 comes up by Meenie
Why aren't 2010 questions coming up in search?
April 21st, 2010 04:57 PM
by JLatham Go to last post
3 224
How do you automatically display a vba form in excel 2007 by Kathryn
I have created a form in excel 2007 developer that manipulated data on two of the sheets. Somehow I want the customer to be able to activate the form from...
April 21st, 2010 04:51 PM
by JLatham Go to last post
1 261
Default font/Size in Comments Box by Paul Calcagno
I'm running MS Office 2007 on a Vista Home Premium OS SP2, all WU's current, with 2 GB of RAM. Windows defender, Spyware Doctor, MBAM, SAS. Everything's...
April 21st, 2010 04:47 PM
by Dave Peterson Go to last post
3 362
Conditional Format by andiam24
Hello, I would like to set a conditional format to color each unique value a different color. It will also be applied to multiple occurences of the value....
April 21st, 2010 04:41 PM
by andiam24 Go to last post
2 189
Problem with subsets for multiple Report Filters in 2007 PivotTabl by Gordon
I have 2 fields in my PivotTable's Report Filter section - 'Country' and 'City'. When I filter by 'Country' it doesn't automatically restrict the possible...
April 21st, 2010 03:31 PM
by Roger Govier[_8_] Go to last post
1 220
Subtotals in Excel by Julie
Hi Everyone, im stuck.... im doing my NVQ Level 3 in IT and one of the things i have forgotten is the subtotals function i've set it all up correct but it is...
April 21st, 2010 03:21 PM
by Julie Go to last post
0 196
Arrow Keys by Terry
my arrow keys (up down right left) decieded not work only in Excel. What did I turn off?
April 21st, 2010 03:12 PM
by Jacob Skaria Go to last post
1 231
bahttext by javed
THE BAHTTEXT FUNCTION RETURNS THE VALUE OF A NO. IN BAHT TEXT. IN THE HELP OF THAT PARTICULAR FUNCTION, IT SAYS THAT THIS FOIRMAT CAN BE CHANGED TO OTHER...
April 21st, 2010 03:02 PM
by Jim Thomlinson Go to last post
1 173
Can an If statement return a formula for false? by mellors
Help... =IF(I3="Closed","Closed",D3-$D$1) Column I = Open or Closed D1 = =TODAY() The rest of column D = =DATE(YEAR(C3),MONTH(C3)+6,DAY(C3)) Can you return...
April 21st, 2010 02:45 PM
by Fred Smith[_4_] Go to last post
1 171
lookup row number by Michael
Hi, can you tell me how to lookup the row number of a name in a list. EG say I have a list of names as below: Andrew Mike Steve Ian Paul
April 21st, 2010 02:42 PM
by Michael Go to last post
3 226
Concatenate lists by Hanspeter
Is there an Easier way to Concatenate a number of cells greater than 50 cells in once cell without using A1&"_"&A2&"_"& and so on. HAns
April 21st, 2010 02:26 PM
by Jacob Skaria Go to last post
3 221
Segregating Duplicate Transactions by Radhakant Panigrahi
Hi, can anybody help in the below query i have the below data with me RECEIPT_NUMBER TRX_NUMBER PAYMENT_AMOUNT Comments 9907893007 7000604737 151.06 ...
April 21st, 2010 02:15 PM
by Radhakant Panigrahi Go to last post
3 173
Lookup formula by Michael
Hi, I have a lookup formula like this: =IF(ISERROR(IF($D1="ruth baybutt",HLOOKUP(A$3,ruth baybut!F:N,3,0),HLOOKUP(A$3,sheet1!F:N,3,0))),0,IF($D1="ruth...
April 21st, 2010 02:14 PM
by Michael Go to last post
1 255
letterhead in excel by dsh
can letterhead be inserted into excel?
April 21st, 2010 02:04 PM
by Bob I Go to last post
1 211
How do I add extra data to a pivot table? by Max
I know this might sound slightly simplistic, but my pivot table pulls data from a separate tab. I know if I go in and amend the data in that table and then...
April 21st, 2010 01:41 PM
by Roger Govier[_8_] Go to last post
3 312
charts with percentages by Mar
I have made a chart in word with percentages in a data label, when I change my figures in my excel worksheet it changes the pie chart shape, but not the...
April 21st, 2010 01:33 PM
by Mar Go to last post
0 201
need a formula to find "*" in s string and multiply by preceding andfollowing values by Tonso
I have cells enrties which can look like this: Cell Entries: Desired Results Cars 6 ...
April 21st, 2010 01:31 PM
by Roger Govier[_8_] Go to last post
5 235
Post New Thread


Display Options
Showing threads 1961 to 1980 of 139764
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:20 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.