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
How to unhide and pictures in excel by TUNGANA KURMA RAJU
In one of my w/books I used McGimpsyes's macro "Looking up and displying pictures based on a cell value",http://mcgimpsey.com/excel/lookuppics.html ,by...
October 25th, 2009 02:48 PM
by Dave Peterson Go to last post
1 162
Run macro on exit by Steve
I have a multi-sheet document. Before I exit I like to click box A1 in all sheets so that when I open the document everything is all neat and tidy and I know...
(Multi-page thread 1 2)
October 25th, 2009 02:43 PM
by Dave Peterson Go to last post
12 154
Is it possible to convert solar date to lunar date using excel? by GOH
Is it possible to convert solar date to lunar date using excel?
October 25th, 2009 10:21 AM
by Mike H Go to last post
1 129
making a portion of reference to a worksheet variable in a formula by Celia
How do I make a portion of a worksheet reference variable. For example I am linking to a file that has multiple worksheets and I am getting the same data...
October 25th, 2009 09:27 AM
by Jacob Skaria Go to last post
1 112
Recalculating Subtotals by Haryadoon
Subtotals (and autosums) don't change when you add a new row at the bottom of the range. In both cases, the Excel function will generate a formula for you,...
October 25th, 2009 06:02 AM
by Haryadoon Go to last post
2 107
Look Up and provide multiple result by nsd
Hello again, I tried to post this, however I don't find it under my postings, hence sending it again. --- I have a worksheet in the following...
October 25th, 2009 02:10 AM
by Herbert Seidenberg Go to last post
4 167
How can i use > in lookup function? by AZHawkPilot
Column B has dates, 1 Jan 05 through 31 Jan 06. Column E has numbers .1,.2, up through 6. I need a lookup function that will find the last value in column E...
October 25th, 2009 01:32 AM
by smartin Go to last post
3 137
A way to display key info from a large database? by Nathalie
Hello everyone! I am currently working for a sales division at large Company as a sales rep. I would also like to add that I am not a CS person but a...
October 25th, 2009 01:05 AM
by smartin Go to last post
1 124
Best way to create a formula for 3 different matches. by Krish
I have a spreadsheet pulling data relating to pricing from MS Query from 2 different sources into 2 different worksheets. Both worksheets have common fields...
October 25th, 2009 12:51 AM
by smartin Go to last post
1 119
Excel 2007 Formatting is now not appearing in 2003. by andylawcc
Hi all, A few of my coworker have new computer that upgraded to Office 2007 while other are still using 2003. Compatibility was not an issue for a year or...
October 24th, 2009 08:42 PM
by andylawcc Go to last post
1 99
Convert qif/ofx/qfx to Excel file! by Sam[_27_]
How I can convert or import a qif/ofx/qfx file to Excel file format. Could you please help me about that. -- Sam
October 24th, 2009 08:27 PM
by PeterJordan Go to last post
2 160
How can I make the status bar to be displayed as default? by Aragorn
Currently everytime I open excel, I need to go to the Tools menu, click Options, and then click the View tab and then select the Status bar check box
October 24th, 2009 05:59 PM
by Gord Dibben Go to last post
2 91
Change colour of font in xls headers/footers by masonrj1
Can you change the colours of a header in XLS... am I missing something?
October 24th, 2009 04:09 PM
by Gord Dibben Go to last post
1 83
Excel 2007 Track Changes problems by Auntie
I have a shared Excel file which I created in Excel 2003. The worksheet has hidden columns and requires my users to filter and sort the data. The problems...
October 24th, 2009 03:14 PM
by Auntie Go to last post
0 123
hyperlink by calvin
how can i get hyperlink to just find the file and not ask to open it? i just want to find the file so i can just delete it
October 24th, 2009 02:35 PM
by Dave Peterson Go to last post
1 78
Combine Formulas by Canon
Excel 2007 I have a simple formula; =sum(E3/22.40), and I would like to combine the FLOOR function together with this so that the answer rounds down. 4.4689...
October 24th, 2009 02:31 PM
by Dave Peterson Go to last post
1 96
Runtime Error '91' Object variable or With block variable not set by Alec Coliver
I have a problem as per the subject line. The problem region of code is listed below. The actual error is occurring at this point of execution in the Sub...
October 24th, 2009 02:29 PM
by Dave Peterson Go to last post
2 109
EXCLUDE TOTAL FROM FILTER by Dave
Hi I am trying to create a row which will only sum whatever is in a filtered columns. Can this be done??
October 24th, 2009 01:07 PM
by Pete_UK Go to last post
7 99
A vlookup/index-match type problem by Andrew Mackenzie
Hi all, I hope someone can help me with this. I want to return a value from a table which is based upon two criteria. I have a table like this: A ...
(Multi-page thread 1 2)
October 24th, 2009 10:24 AM
by Bernd P Go to last post
10 140
loss of redo function after installing auto-save by JT Spitz
I am running excel 2000. Today I installed the auto-save function and set it for every 10 minutes with the prompt before saving check box checked. After...
October 24th, 2009 10:18 AM
by JBeaucaire[_133_] Go to last post
1 92
Post New Thread


Display Options
Showing threads 11121 to 11140 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 07:11 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.