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 Replies Reverse Sort Order Views
Negative by Jon
I have a summary sheet for a month's worth of data and I need the negative's that appear to come out as zero's -- Jon
(Multi-page thread 1 2)
April 30th, 2010 03:22 PM
by Jacob Skaria Go to last post
14 355
Leading Apostrophe by Phil-T
I was sent an Excel file and opened with my Excel 2003. And in every field, the data is prefaced with an apostrophe. When looking at the cell you can't see...
(Multi-page thread 1 2)
December 15th, 2009 03:42 AM
by Sheeloo Go to last post
14 221
Identify condition using multiple criteria WITHOUT sumproduct?.. by MeatLightning
Hi all - Not sure if this is possible but... I have data that looks like this: ID | UNIQUE ID | LINE | VALUE | TYPE | 01 ...
(Multi-page thread 1 2)
December 19th, 2009 03:35 AM
by T. Valko Go to last post
14 275
shade cell shortcut without bringing up palette by Erik
When I use the keyboard shortcut to shade cells it always brings up the color palette, and I have to select the color manually. Using the keyboard, is there...
(Multi-page thread 1 2)
January 7th, 2010 02:14 AM
by Bod Go to last post
14 166
My Excel file is not calculating! by Accesshelp
Good morning all, I have an Excel file with two worksheets: Report and Data. The worksheet Data has data where the data are stored, and the worksheet...
(Multi-page thread 1 2)
December 31st, 2009 11:17 AM
by Max Go to last post
14 231
File Size Jump by New2Macros
I can't figure out why my Excel file size is jumping from 550kb to 35mb. I am running some formulas to copy data, and some special links from other pages,...
(Multi-page thread 1 2)
January 26th, 2010 02:41 PM
by Dave Peterson Go to last post
14 232
rename by Martin ©¿©¬ @nohere.net
Hi I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc
(Multi-page thread 1 2)
March 26th, 2010 06:54 PM
by Dave Peterson Go to last post
14 272
Excel, Macro, Drop down list by Ajgoodson
I have a list that I want to make into a drop down list that when each individual item is selected, cause a macro to run. Can anyone assist?
(Multi-page thread 1 2)
February 11th, 2010 12:23 AM
by Dave Peterson Go to last post
14 222
Full path-name in title bar ? by Stefan
Hello, Is it possible to put the full path name of the opened file in the bleu title bar from excel, this always en automatically. -- Microsoft Excel -...
(Multi-page thread 1 2)
January 13th, 2010 12:00 PM
by john Go to last post
14 205
How can you restore grid lines? by Pma
I am trying to restore the grid lines on a work sheet and can't get them back. The tools/options/view button is not doing it. Any help?
(Multi-page thread 1 2)
April 13th, 2010 09:58 AM
by Roger Govier[_8_] Go to last post
14 362
Formulas by Copying VLOOKUP formulas
I have the following formula inserted into a cell. I know it works because it returns the correct value. =VLOOKUP(K4,A3:C714,3,FALSE) I now need to copy...
(Multi-page thread 1 2)
November 21st, 2007 01:54 AM
by Dave Peterson Go to last post
13 80
Add Seconds To Date by FrankM
I have two columns, one has Date and the other has seconds (they aren't necessarily related). Example B2 has the value 7/12/2003 6:43:47 PM and cell C2 has...
(Multi-page thread 1 2)
November 14th, 2007 10:01 PM
by FrankM Go to last post
13 151
how to insert rows by formula. by Johnny
Hi anyone know how to insert a blank rows by use formula at cell A between 1&2, 2&3, 3&4. cell A ...
(Multi-page thread 1 2)
November 18th, 2007 01:38 PM
by Billy Liddel Go to last post
13 150
How to get the final "result" to show in one cell? Excell 2002 by Lisa Ann Kashner
Hello, I am soooo confused with this scenario.... I have checkboxes set up. cell H8 has: 1st checkbox formula is: =IF(D8=TRUE,60,"") cell I8...
(Multi-page thread 1 2)
November 11th, 2007 08:27 PM
by Lisa Ann Go to last post
13 361
lowest of two closest numbers by Susie (SFAngelgirl)
excel 2003 In comparing a range of numbers; I need to find the two closest numbers and have the lowest value returned. Anybody? Susie - SFAngelgirl
(Multi-page thread 1 2)
November 8th, 2007 11:29 PM
by Susie (SFAngelgirl)[_2_] Go to last post
13 155
SUMPRODUCT: Help to use this to find min date in range for criter by Gwynneth
I am trying to find the minimum date in a range, which contains blanks. subject to a criteria. As the range contains blanks, these are currently picked up...
(Multi-page thread 1 2)
November 16th, 2007 07:40 PM
by Blueglass Go to last post
13 344
Problem with rounding? by AmImad?
Hi I use excel for calculating calibration errors based on range/target value/actual value, and then round the answers to two decimal places. I have noticed...
(Multi-page thread 1 2)
October 18th, 2007 04:34 PM
by Sandy Mann Go to last post
13 149
compare worksheets by Ivano
Hi, I have an excel file which is updated regularly and then a backup was made. unfortunaltely the orginal as well as the backup have been updated. is there...
(Multi-page thread 1 2)
October 16th, 2007 11:33 AM
by Rajula Go to last post
13 181
Excel files not opening by [email protected]
Hello, I am currently using Excel 2007, when I double click on an excel file, Excel opens up to a blank screen. If I go to options and then cancel out,...
(Multi-page thread 1 2)
November 16th, 2007 04:58 PM
by Aron Go to last post
13 254
How can I search for words in all caps in Excel? by Nexan
As part of a macro, I'd like to be able to identify and re-format only cells containing words in all caps. Is that doable? Thanks!
(Multi-page thread 1 2)
November 28th, 2007 01:58 AM
by T. Valko Go to last post
13 214
Post New Thread


Display Options
Showing threads 1001 to 1020 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:26 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.