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
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 270
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 587
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 580
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 988
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 689
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 673
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 691
copying absolute formulas by MJKelly
Hi, I have a large number of formulas in a table. All seven days of the week are represented. Monday has the correct formulas (and includes absolute...
September 23rd, 2008 09:41 PM
by Glenn[_6_] Go to last post
1 681
Question regarding VLookup and if it can check two columns of data by Smoke
Hi, My experience with any excel formulas is very limited and I was just wondering if someone could provide me with a formula / and or help with my current...
September 23rd, 2008 09:10 PM
by Smoke Go to last post
2 658
Txt to columns by Spiky
Well, you could record Text to Columns in a macro to shorten the keystrokes. Or someone could probably write a long, choppy formula using MID and FIND and such...
September 23rd, 2008 08:40 PM
by Spiky Go to last post
0 661
Txt to columns by Learn Excel
I work a lot on the database of the following format which contains just numbers. 5555 21 38 50 55 164 | 10 5 2 200 ...
September 23rd, 2008 08:38 PM
by Learn Excel Go to last post
2 663
Hyperlink to workbook location by jaclh2o
Hi I am trying to hyperlink to an Excel worksheet location from a word Document. I am following the instructions from help button but I am getting this...
September 23rd, 2008 08:28 PM
by jaclh2o Go to last post
0 628
Refresh columns not in query by vburns
Is it possible to refresh added columns on a worksheet when the columns included in the query are refreshed? For instance, I import items along with...
September 23rd, 2008 08:17 PM
by Spiky Go to last post
1 647
lastname, first name by plubeski
I have a spreadsheet with 400 names listed lastname, firstname in once cell. Is there a function in Excel that would create two cells, one cell for...
September 23rd, 2008 08:09 PM
by Mike H Go to last post
5 674
replying with attachements by John at Work[_2_]
Hi all. Is there a setting that would allow me to reply or reply to all when an email has an attachement, and I want that attachment to go too? Forwarding...
September 23rd, 2008 08:06 PM
by Peo Sjoblom[_2_] Go to last post
4 650
Sorting Rows and Levels by Mac
Can anyone help me with this problem. I am looking to sort warehouse locations by level and row. The locations are as follows: 210064C. The breakdown on...
September 23rd, 2008 07:58 PM
by Gord Dibben Go to last post
4 682
Get Last NonBlank Value by Scott[_17_]
In the range (B3:E3) below, I'm using FORMULA 1 and FORMULA 2 below to retrieve the last value that is "NonBlank and Not Equal To Zero". Both FORMULA 1 and...
September 23rd, 2008 07:49 PM
by Dave Peterson Go to last post
5 634
No Data Analysis item in Excel Tools menu. Now what? by ainoni
How do I get the Data Anlysis (for regression) into my Tools menu?
September 23rd, 2008 07:44 PM
by Gord Dibben Go to last post
4 730
Maximum Absolute values by HW
I have a set of values in 4 columns that I need to see as positive or negative. However, I need a 5th column to show me the maximum of the absolute values...
September 23rd, 2008 07:37 PM
by David Biddulph Go to last post
3 669
averages for cells by jatman
i have a spreadsheet that calculates averages, but as i add more columns, it always calculates the same columns: B F G H ...
September 23rd, 2008 07:24 PM
by Glenn[_6_] Go to last post
6 627
Post New Thread


Display Options
Showing threads 20001 to 20020 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:04 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.