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
Email addresses in a comma-delimited (CSV) file by email addresses in csv file
I am trying to create a csv from another application to be imported into Excel. One of the columns will contain email addresses. Is there a way that I can...
December 23rd, 2009 06:09 PM
by Dave Peterson Go to last post
1 145
Hyperlink Function to Tab by Matt
I'm trying to create a hyperlink using the hyperlink function that will go to a separate tab within the same worksheet. What I'm using is: ...
December 23rd, 2009 06:01 PM
by Hutch Go to last post
3 161
scale to page error in Excel 2007 by Thomas
somehow something has changed in my Excel 2007 setup where my "fit to scale" does not work appropriately. When I choose print preview, the preview screen...
December 23rd, 2009 05:44 PM
by David Biddulph Go to last post
3 117
how look up this way? by Ian Elliott
Thanks for any help. I would like to look up an array like this: A1-D1:Def Per x yrs,2008,2009,2010 A2-A5:0x=5,5x=10,10x=20,20x=120 (these could just...
December 23rd, 2009 05:21 PM
by Don Guillett Go to last post
2 124
Update date & time in a cell only when worksheet is changed by RJD
I have a workbook with multiple worksheets. I'd like to have the time & date in a cell in each worksheet update only when information in that worksheet is...
December 23rd, 2009 04:57 PM
by RJD Go to last post
6 121
World Cup 2010 Spreadsheet by Originalgoth
Hi All & Happy Christmas & New Year, I'm working on a World Cup spreadshhet. (Excel 2003) In one section of it I've got the Group table A ...
December 23rd, 2009 04:39 PM
by Pete_UK Go to last post
1 118
The reference in the formula has changed to eg =R[-1]C/R[-237]C by Kajsa
I donĀ“t know how it has happened, but I want to read the formula as eg =sum(A2/Z18) Old documents are shown like this and my new ones come out like this...
December 23rd, 2009 04:37 PM
by JLatham Go to last post
4 119
Calculation slowdown by thom
I am calculating three spreadsheet that have many formulaes in each. There are multiple files I need to perform this calculation. As I go thru the 2nd -3rd...
December 23rd, 2009 04:37 PM
by Jim Thomlinson Go to last post
1 116
sumif or suproduct--with two cretarias by Narendra Boga[_2_]
Dear All, I have a peculiar proble which I don't know wether I use sumif or sumprodut? My data A B Result 1 SRA Online...
December 23rd, 2009 04:13 PM
by Ms-Exl-Learner Go to last post
3 133
Denormalized data in Excel by Jabez Gan [MVP]
Hi, I'm not an expert in Excel, but I opened an XML file in Excel, and modified and now I'm trying to export it out. However it is telling me that: ____ is...
December 23rd, 2009 03:35 PM
by Dave O Go to last post
1 173
Excel 2007 & Outlook 2003 by Desrus
I cannot find a way of transferring data from old computer to new one (old one has Win XP & new one has Win 7) Any suggestions?
December 23rd, 2009 02:51 PM
by Bob I Go to last post
2 106
Adding more than 65,536 rows in Excel 2007 by WL
When I try to cut and insert 20,000 rows from one worksheet to another worksheet that already has 50,000 rows I get the error "To prevent possible loss of...
December 23rd, 2009 02:45 PM
by Dave Peterson Go to last post
5 118
macro help by puiuluipui
Hi, i need a macro to look in column B for a date ( 12/01 ) and then to add the date to column A till last filled cell in A. EX: (this is now) A ...
December 23rd, 2009 02:11 PM
by puiuluipui Go to last post
2 125
Blank dates showing as 00 january 1900 - help by Josuha
I'm using the below forumla to import data from a seperate workbook which contains dates.It does work for cells that have dates in them but not every cell...
December 23rd, 2009 01:22 PM
by Josuha Go to last post
3 106
Added details only if it is within a certain month of the year by Jim
Hello, I am struggling with a formula that i wondered if anyone could asssit me with? I am trying to get a calulation that only adds up all the figures in...
December 23rd, 2009 01:01 PM
by Ms-Exl-Learner Go to last post
4 161
text to columns by linto
hi I created a code to apply text to columns functionality and i assigned a button to it . It works perfectly. but when i created another button in a...
December 23rd, 2009 12:25 PM
by Gary''s Student Go to last post
1 102
Difference of empty cell and zero value when formatting by Al
I'd like to conditionally format a cell if the value zero is entered into it, however to leave the cell without formatting if the cell if empty. My attempts...
December 23rd, 2009 10:46 AM
by Al Go to last post
4 144
how to create a new sheet when adding values in column if it not e by Mahdi
What i want to do , is to make excel to create a new sheet, with the name of the content of the cells in a defined column. so that when i edit a new cell in...
December 23rd, 2009 10:33 AM
by Jacob Skaria Go to last post
1 155
How to transpose in excel file by vilfood
Hi I would like to make a transpose like this? From House Defect How much #1 Broken Sinks 1000 #1 Bad Paint 2000 #1 Bad...
December 23rd, 2009 09:26 AM
by Jacob Skaria Go to last post
3 102
Vlookup with a specific item by kattay
Hi, I would like to vlookup on employees' degree start date, eg.: A B C emp. no. Start date Edu 1 01/01/90 Dip 1 ...
December 23rd, 2009 08:21 AM
by Jacob Skaria Go to last post
1 120
Post New Thread


Display Options
Showing threads 8081 to 8100 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 10:07 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.