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 : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Reverse Sort Order Last Post Replies Views
excel by
What does the function or symbol ^ mean?
October 11th, 2003 10:16 PM
by James Silverton Go to last post
1 143
Updating data with an ODBC link to ACCESS by
Does anyone know the best approach for this? I have (roughly) 200 EXCEL files that have VLOOKUPs to 5 additional spreadsheets which have ODBC links to various...
July 6th, 2006 02:09 PM
by Go to last post
1 79
Simplifying my previous Request for Assistance by
I suspect that (since I didn't get any response on my previous request for assistance) I may need to approach this in stages ... Assuming that Information...
July 6th, 2006 02:06 PM
by Go to last post
1 92
Running Macros by
I have the following Macro (which I need to run on approximately 200 different workbooks) -- what is the BEST way to achieve this? Should I use a Function...
July 6th, 2006 03:42 PM
by Go to last post
0 81
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? by
I'm not certain if this one belongs in the EXCEL or ACCESS Newgroup ... ==================================== I have an Aggregate Transfer Spreadsheet Macro...
July 12th, 2006 10:08 PM
by Go to last post
0 122
want a list of selectable names on my worksheet by
Hi You could use Data/Validation/List. Prepare your list in another sheet and point your validation at the list. Hope this helps. Andy. "Boze"...
August 7th, 2006 08:49 PM
by Boze Go to last post
4 88
Using Excel 2000 VBA Application on Excel 2003 by
I have a VBA application written in Excel 2000. The appl contains several forms and custom menus. I tried running the appl on Excel 2003, but got errors. (I...
August 8th, 2006 02:36 AM
by Go to last post
0 86
Is there a formula for inches to feet and inches? by
I work with lengths, in inches (sometimes 50000 +inches), but need a quick way to convert them into feet and inches. Here is an example: a1 144.625 b1...
August 12th, 2006 12:45 AM
by daddylonglegs Go to last post
2 106
Making cell reference absolute makes cell format text by
Hi Weird one here! I've been browsing the Excel forums for years and not seen this. One sheet is called Special One Off Deals, and in cell C2 is Aug 06 -...
September 22nd, 2006 04:47 PM
by Go to last post
2 98
how can I split one cell's data into two cells? by
I am using Excel as a database, and have a column with cells with a person's name (text) in it...e.g., John Smith. NOW, after the fact, I wish to have...
May 15th, 2006 01:19 AM
by Go to last post
3 143
Number of items in a colum by
Hei, I would like to found out how many same items are in one Excel column. If the column has the values 1 3 4 2 5 6 7 9 3 6 7 8 3 the funktion should pic up...
May 9th, 2006 01:56 PM
by Ardus Petus Go to last post
1 85
offset/match by
I am trying to create an offset/match formula that pulls data from a separate worksheet, but it is not working. is there any restrictions on this?? thx,
October 31st, 2003 12:18 AM
by Harlan Grove Go to last post
3 154
editing chart source data by
NO more new fonts may be applied to this workbook
November 18th, 2003 06:00 PM
by Jim Go to last post
1 200
How to Build an External Link Using Data from Cells by
I want to import data in a cell from an external spreadsheet located at 'C:\Data\MySheet!$H$5. I want to build it using cells from the current worksheet such...
January 20th, 2004 01:25 AM
by Harlan Grove Go to last post
2 508
Need Help WIth a Function by
I am Trying to create a Weekly Time schedule for my business. I have to deduct a half hour from each shift if more than five hours are worked. i want the...
February 2nd, 2004 11:31 AM
by Frank Kabel Go to last post
3 154
calculate Score by function by
what should I have to do if i want to give score 5 at 1000 and with every increase or decrease of 25 in 1000 .25 should be added in 5 or subtracted...
July 19th, 2004 12:35 PM
by Frank Kabel Go to last post
1 112
how to switch a #N/A value into 0 by
I used the vlookup function to get pricing from a=20 database which is multiplied by a specific volume. When I=20 have no pricing in the database for a product...
July 22nd, 2004 10:51 PM
by Aladin Akyurek Go to last post
2 93
Duplicate enties by
I have a spreadsheet with about 20,000 rows and 10 columns of data. Is there a way of finding if there are duplicate entries using a unique field. Is there...
September 19th, 2004 11:51 PM
by Max Go to last post
1 121
use "button" to make calculation ignore a cell by
How can I create a macro "button" over a series of columns that will cause a formula in another part of the sheet to ignore the value that the...
March 21st, 2006 05:54 PM
by Go to last post
5 102
Extract email addresses by
Hi I have been looking for an answer to this for weeks - and I admit defeat! I have a column of data with email addresses in there, somewhere. Each email is...
December 15th, 2006 10:05 PM
by RichardSchollar Go to last post
9 86
Post New Thread


Display Options
Showing threads 41 to 60 of 87787
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 03:08 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.