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 Last Post Reverse Sort Order Replies Views
Conditional Formatting Separate Rows by Pete
I need to set-up three formali in each row of a 1000 row spreadsheet. The three forumli a =A4="x" then B4 : P4 strickthrough, green font =B4Today()...
September 23rd, 2008 09:49 PM
by Pete_UK Go to last post
3 716
signature line by pdaws
I have created a form in Excel 2002 that requires three different signatures. I would like for each signature's username to appear in the specific cell that...
September 23rd, 2008 09:52 PM
by Gord Dibben Go to last post
3 701
Conditional Sum? by PaulinaDi
I have a spreadsheet with different columns regarding all the invoices a certain supplier has given to my company. I have 15 columns and 3 of them are the...
September 23rd, 2008 09:57 PM
by PaulinaDi Go to last post
2 718
VLOOKUP returns unwanted/wrong values by wcollatz
I'm using the VLOOKUP function to return data from a named range which contains several data points (across the row) for several "sites" which are numbered...
September 23rd, 2008 09:57 PM
by T. Valko Go to last post
4 1,018
VLOOKUP Problems with formula by treeroot
I have a workbook on the first sheet is my "high priority" my email column is A4:A5764 and on sheet 2 I have a list of bad emails A1:A1199 that need to be...
September 23rd, 2008 09:59 PM
by treeroot Go to last post
5 612
Signature or Logo by Vercingetorix.XIII[_2_]
Is there a way to put something in an excel spreadsheet as a signature or logo or something to show that you made it?
September 23rd, 2008 10:01 PM
by Gord Dibben Go to last post
3 616
truncation with imports via html by jvblue
I am trying import HTML into excell, but if i choose to import the file it will truncate the excell with 65533 rows. However if i save the html as .txt and...
September 23rd, 2008 10:03 PM
by jvblue Go to last post
0 276
#VALUE error on SUMIF formula linked to multiple worksheets by bknutzy
I am receiving a #VALUE error on a SUMIF formula that I have linked to an external spreadsheet. If I only have the spreadsheet with the SUMIF formula open,...
September 23rd, 2008 10:06 PM
by Dave Peterson Go to last post
1 137
Conditional Formmating Help by [email protected]
I have a row of 5 numbers - I want to highlight the lowest number in the row using conditional formatting Help out there? -Steve
September 23rd, 2008 10:21 PM
by [email protected] Go to last post
2 119
Restart row count each time the value in a specific column changes by RC
Is there a formula that will restart the row count when the value in a specific column changes --- such as shown below when the value in column A changes the...
September 23rd, 2008 10:40 PM
by Max Go to last post
3 196
Time exported w/ space/comma, Convert to Number by al_ba
Hello, I have a sample Data below... A = original exported data, it has 1 space in front... for thousand, also with space in front and with comma. B = is my...
September 23rd, 2008 10:42 PM
by Max Go to last post
4 127
Vlookup for multiple values and return to one desired value by nsd
I have some data as under A B C D Jan John 2 3 Feb Peter 3 4 Mar John ...
September 23rd, 2008 10:44 PM
by T. Valko Go to last post
8 162
Password Protection on Excel Spreadsheet by Jim
I have a spreadsheet that is password protected. I can not remember the password that was used. How do I reset this function?
September 23rd, 2008 11:15 PM
by ryguy7272 Go to last post
3 181
Pop up message box? by Graciegirl
Is there a way to create a pop up message in Excel upon opening a workbook? I want to create something along the lines of "resave this file as xxxx". --...
September 23rd, 2008 11:17 PM
by Gord Dibben Go to last post
2 112
Proper() function handling of apostrophe by Valpey
The Proper() function incorrectly handles possessive apostrophes. (e.g. Proper(STEVE'S BAR AND GRILL) returns "Steve'S Bar And Grill". Is there a simple way...
September 24th, 2008 12:04 AM
by ryguy7272 Go to last post
2 148
Lookup last used Row un closed Workbook by ryguy7272
I am trying to link to a closed Excel file with this path: ='C:\Documents and Settings\rshuell\Desktop\Weekly Reporting\Friday\WeeklyForecastingRM'!B7 I want...
September 24th, 2008 12:10 AM
by ryguy7272 Go to last post
4 110
How can I display formula values instead of the formula? by Dan G[_2_]
I have a bunch of cells that contain formulas with values from all over the place and I would like to be able to see the values of each formula quickly. To...
(Multi-page thread 1 2)
September 24th, 2008 12:23 AM
by Bernard[_4_] Go to last post
10 221
drop down date by kalasha
i am trying to enter a drop down date in an excel worksheet for users to select a date from a calander. ex. select a cell (where the date is to be) and a...
September 24th, 2008 12:24 AM
by Tanya[_4_] Go to last post
3 169
transfer data? lookup? by GA85
Suppose Sheet 1 looks like this: 1 2340 Cash Received Payment 2,000 3578 Accounts Pay Received Payment ...
September 24th, 2008 01:30 AM
by ryguy7272 Go to last post
1 132
I'm having a problem setting up option buttons by Form Option Buttons
I'm trying to develop an electronic customer satisfaction survey with topics in column "a" and option buttons 1-5 in "b-f" then I want the totals at the...
September 24th, 2008 03:46 AM
by Form Option Buttons Go to last post
0 126
Post New Thread


Display Options
Showing threads 67781 to 67800 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:31 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.