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
Excel 2007 compatibility issue - speed between cells by Simon Whale
Hi, I have a document for a user that was originally created in Excel 2000. We recently upgraded to Office 2007 Basic. The problem we have for a...
November 11th, 2009 01:06 PM
by Charles Williams Go to last post
2 228
Calc duplicates by backmara
Hi, I need function to calculating duplicates, how I create this? A1: 1 A2: 2 A3: 2 A4: 3 A5: 3 A6: 3 A7: 4 A8: 5
November 11th, 2009 01:04 PM
by Ms-Exl-Learner Go to last post
3 244
Pivot Charts by GD
hi, i'm using a pivot chart to show some data in which the X Axis is a Month, the Y Axis from 0 to 100, and then 5 series with monthly figures between 0-100...
November 11th, 2009 12:38 PM
by GD Go to last post
0 210
"Dynamic" hyperlink by Espen Rostad
I have to create a large wb with one sheet per day named actual dates. On the front page i need a cell to put the desired sheet (by entering date) to go to....
November 11th, 2009 11:31 AM
by Jacob Skaria Go to last post
8 200
Pivot tables and percentages by Ajay
Morning All I have a pivot table formatted as below: Company Business Unit Calibration Result Count ABS 123 ...
November 11th, 2009 10:53 AM
by Ajay Go to last post
0 200
"File Open" box Excel is full screen, how can I size it down? by Dervil
I must have accidently hit something now every time I want to open file the box fills the screen. I can't pick it up by top bar nor can I size it - it's...
November 11th, 2009 10:52 AM
by Jacob Skaria Go to last post
1 195
Unable to open .xls saved files by other users. by Vinod
Hi All, I've connected to one of our remote desktop with my user login credentials and placed an excel file with macro. On execution of macro will create new...
November 11th, 2009 10:44 AM
by Vinod Go to last post
0 224
New link by flyfree
I have two identical spreadsheets and when I update the first I want the second to be updated also. (Step-by-step please, I haven't set up a link before)
November 11th, 2009 10:31 AM
by flyfree Go to last post
3 214
Default format of cell comments by Al
When I create a comment against a cell, it seems that the default formatting is “Don’t move or size with cells.” This causes many problems when I hide...
November 11th, 2009 09:03 AM
by Al Go to last post
4 248
how do I work out age in years, months, days in excel by Tru Colours
I'd like to be able to work out ages in years, months and days - in excel - but I just can't figure it out. I've managed to do years and points (tenths) of a...
November 11th, 2009 09:01 AM
by Jacob Skaria Go to last post
1 198
List with files and sub-dir + comments that can be updated by Bobi
Hi Could some one please help me with a sciprt that can do the following thing: 1. Create a list with filenames incl. subfolders in excel (file in column a,...
November 11th, 2009 08:49 AM
by Bobi Go to last post
0 173
Variable statement by doobie
I need a fn to substitute for a variable value in a SUM fn., in other words my problem as indicated in below table (Hrs) 2 2 3 1 Student ...
November 11th, 2009 08:42 AM
by doobie Go to last post
3 200
Quick way merge 2 databases using a unique field. by ch
Hi Gurus, I have 2 databases containin details of the same unique field eg serial number Is there a simple quick way to merge them by the unique serial number...
November 11th, 2009 08:34 AM
by ch Go to last post
2 224
subtraction task by Jamie
Excel 2003 I'm tracking weight loss. In one column I have a list of #'s. The top # is the beginning weight. Each # under the beginning weight is from...
November 11th, 2009 06:51 AM
by Jamie Go to last post
5 208
Additions by Marc
Hi, I have data similar to the bottom. I want to add all the Zauri Inds, Zyden Gentec, Zydus Wellness, Zylog Systems. How do i do that? I want to drag a...
November 11th, 2009 06:35 AM
by Ms-Exl-Learner Go to last post
1 187
Named range labels in formulas by KLUG
I created names ranges in an existing workbook. In order to get formulas to use the named range in the formula, I hit F2 in a formula cell and ENTER as...
November 11th, 2009 06:09 AM
by T. Valko Go to last post
1 197
Convert julian date by JHL
I have a julian format of YYDDD. The formula I'm using is off a day and a century. Formula =date(left(a1,2),1,(mid(a1,3,3)) 05059 = 3/31/1905 How can I...
(Multi-page thread 1 2)
November 11th, 2009 05:51 AM
by JHL Go to last post
15 485
location of a link in server by Lowan Chan
Hi, I have an excel file saved at server. I am trying to link some photo files which are also saved at the same server. But everytime after I save the...
November 11th, 2009 05:24 AM
by Lowan Chan Go to last post
2 201
Loss of Right Button Functionality in Tabs by Netorius77
I have lost the right click functionality when I right click on an Excel Tab (Excel 2003) I can still right click in a cell and get the standard options...
November 11th, 2009 04:51 AM
by Netorius77 Go to last post
3 190
Conditions by Jim
Hello, Thanks in advance for the help. I want to return the word "TRUE" in column G2 if column A2 shows "SF" and Column I2 is blank. If column A shows...
November 11th, 2009 04:31 AM
by Ms-Exl-Learner Go to last post
4 237
Post New Thread


Display Options
Showing threads 10201 to 10220 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 12:18 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.