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
Data Validation by dinna
can anyone help me !!!! I am trying to create a drop down list in excel with data from another tab. Is this possible, if so how can I do...
September 17th, 2003 09:13 PM
by Debra Dalgleish Go to last post
1 288
odd and even addresses by Dino
I saw a previous post about sorting odd and even numbers, and the formula generates an "E" or an "O". I need to sort odd and even street addresses. I could...
September 30th, 2008 05:47 PM
by Dino Go to last post
3 85
How do I delete formulas but save numbers? by Dino
How do I delete formulas but save numbers?
June 26th, 2006 07:43 PM
by Dino Go to last post
4 82
Concatenate or "&" problem by Dino
I have tried to concatenate or use the "&" in my database with no luck so far. I get either the #VALUE! or #NAME? result. I have addresses that are separated...
December 28th, 2005 10:06 PM
by C. Cunningham Go to last post
6 119
Removing links by Dino
I inherited a workbook that has a link to another workbook that no longer exists. Every time I open this workbook, a message pops up that it can't find the...
October 5th, 2005 05:11 PM
by Dino Go to last post
2 67
assigning a unique value by Dino
I have a spreadsheet of names, and I need to assign a unique number to each of the names. Some entries are repeated, so each duplicate should have the same...
(Multi-page thread 1 2 3)
May 7th, 2005 12:12 AM
by Harlan Grove Go to last post
27 356
footer with complete path by DINO
Is there a way to insert the file name with complete path in the footer of an Excel document? I see that you can insert the file name alone, page numbers, and...
October 1st, 2004 05:03 PM
by Frank Kabel Go to last post
1 149
Rounding issues by DINO
I get lists of dollar amounts that I need to sum. The actual numbers have four or five digits to the right of the decimal, like $25.5637 I need to sum only to...
March 10th, 2004 02:17 PM
by Ron Rosenfeld Go to last post
9 188
Counting cells with specific date ranges by Dino
How would I count cells within specific date ranges? For example, if I have a column of cells that have different dates in them, how would I count the number...
October 9th, 2003 08:00 PM
by Paul B Go to last post
1 444
Date stamping entries by Dino
I hope that someone can help me with this: I am setting up a 20,000 item spreadsheet, where my staff will put an "X" in an adjacent column when they are...
October 9th, 2003 02:52 AM
by Gord Dibben Go to last post
2 139
colums in uppercase only by Dino Thomas
I am trying to create a spreadsheet where all text entered in columns A,C, and H from row 5 to row 50 shows in uppercase
August 14th, 2005 09:43 PM
by Bob Phillips Go to last post
1 68
e mailing attatchments excel always come out as scrambled words? by dino32
Hi Please can anyone help me ? I am attempting to e mail 2 attatchments of excel spreadsheets very important as I need to e mail these every week to...
December 22nd, 2006 03:59 AM
by Gord Dibben Go to last post
4 73
How do I find more than two digits at the same time? by dinopino
I want to use the Find and Replace function to find all the digits 5, 8 and 3 in my spreadsheet using the function once.
October 21st, 2006 09:10 PM
by Bernard Liengme Go to last post
1 127
#div/0 errors and blank cells by dinouk
Hi wondering if anyone can help me with this one... Have 31 cells in a row which i want to get the average value from, some of these 31 cellsmay or may not...
July 15th, 2007 10:39 PM
by T. Valko Go to last post
7 108
importing a particular excel worksheet into another excel file by dinouk
Im am trying to import the data off one worksheet in one file into another file as an object Here is what i have got... The person who plans our production...
August 10th, 2006 02:03 PM
by dinouk Go to last post
0 47
Works spreadsheet-find circular ref. by dino[_2_]
I have a spreadsheet with a lot of data and up pops the "circular reference in a cell" message. Is there a quick way to find it? I've spent a good amount of...
October 22nd, 2007 05:52 PM
by David Biddulph Go to last post
1 44
How do you get an A3 worksheet in Excel by dinternational
How do you get an A3 worksheet in Exel?
December 21st, 2006 07:16 PM
by David Biddulph Go to last post
5 84
Limitations to 2 variable data tables? by DInwood
I'm getting an odd result with 2 variable data tables in a complex spreadsheet - only the 1st (top left) cell returns the proper value, the rest are either...
June 26th, 2007 04:15 PM
by Max Go to last post
2 98
how do i put color in a cell based on data in a second cell by Diogie
Cell A1 has 8 digit number manually entered each day. Cell B1 has a single letter manually entered each day (same time as A1 entry). The background color of...
September 5th, 2007 12:32 AM
by Diogie Go to last post
5 83
Designating color in one cell based on data entered in another cel by Diogie
I need a way (formula, format, etc) for the background color in one cell to be determined by the data entered in another cell. For example: Cell C6 will...
September 8th, 2007 04:55 PM
by Gord Dibben Go to last post
3 65
Post New Thread


Display Options
Showing threads 22161 to 22180 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 11:16 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.