A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
I can not create an external link between two Excel 2007 workbooks by Bill R
Even by puttting the simplest = in the destination workbook cell then tabbing over to the source workbook, i can not create the link. When in the source...
August 27th 09 04:12 PM
by Gord Dibben Go to last post
1 1,475
How do I export a row of data into its own workbook by LMM_0809
I'm looking to send out a mass email to separate individuals. This email will include: cover sheet, sheet with Excel row of data per client I have all my...
August 27th 09 04:03 PM
by Luke M Go to last post
1 366
Worksheet compatability by Jewell
Can someone explain to me why when i got to save a worksheet/workbook that is say this format is not compatable and some data will be lost. My options are...
August 27th 09 03:48 PM
by Gord Dibben Go to last post
1 249
Simple? View named range from sheet1 on sheet2 by susiew32
I have a sheet with rows of data. I have named ranges for different rows and columns within that sheet. How can I view the each named range on a second...
August 27th 09 03:29 PM
by Pete_UK Go to last post
1 550
To return a blank cell rather than 0% in a vlookup. by Romileyrunner1
HI, when using a vlookup from a table that might have some blank cells in it, The returning refrences are showing "0%" when I want them just to appear as a...
August 27th 09 02:36 PM
by Max Go to last post
9 840
conditional formatting by Jules
I have a large spreadsheet and in some cells I have numbers and text. I have set up conditional formatting to show the cell as a different colour when the...
August 27th 09 02:36 PM
by Jules Go to last post
0 230
Excel is crashing when making a pdf of my workbook by Jewell
Can someone help me figure out why my Excel crashes when I go to convert the workbook as a pdf?
August 27th 09 02:24 PM
by Jewell Go to last post
0 394
Display formula on the cell by journey
Hi I wanted to display the formulas permanently besides a calculated value. When I go to Tools>Options>view, click on the window options Formulas, I achieve...
August 27th 09 11:23 AM
by macropod[_2_] Go to last post
2 279
CountA or DcountA, that is the question?? by Niqui
Hello, i am hoping someone can help, these forums are awesome for solving problems! To avoid anyone getting the worng idea, or having to ask a million...
August 27th 09 09:54 AM
by Sam Wilson Go to last post
1 326
Real teaser! by LiAD
Afternoon, Is it possible some-one could help with a formula to look inside a text string mixed of letters, numbers and symbols to return a number that...
August 27th 09 08:36 AM
by LiAD Go to last post
4 234
Countif multiple items by Romileyrunner1
HI, How do I countif a range where I want it to include more than 1 item. I`m usng the formula : =COUNTIF(AN10:AN89,{"W","SA+","ST","SA"}) This isn`t...
August 27th 09 07:49 AM
by Romileyrunner1 Go to last post
2 397
cells are automatically dividing each # I put in by 10!!! by Romileyrunner1
Hi, for some reason, every time I put a number in any cell, it is automatically didvide by 10!??? EG, type in 5, get 0.5 Put in 50, get 5!!! Weird and very...
August 27th 09 07:00 AM
by T. Valko Go to last post
5 496
Search a named range by rhhince[_2_]
I have numbers in column E8:F65500 which I named RANGE1, N8:O65500 which I named RANGE2. Column A is numbered 1 to 65500 referencing RANGE1, Column J...
August 27th 09 06:19 AM
by Lars-Åke Aspelin[_2_] Go to last post
1 419
Count with two criteria in a second worksheet by bec
I'm trying to count columns in a second worksheet. 1) If column A is = apple, then I want to count the entries in column B which are greater than "0" sheet...
August 27th 09 04:27 AM
by T. Valko Go to last post
1 299
SUM IF question (daily rainfall totals) by RedDixieCup
I have two colums of data, the first is a time date stamp (mm/dd/yyy hh:mm) and the second is a rainfall total for each entry (0.00). I need to get a daily...
August 27th 09 03:14 AM
by Fred Smith[_4_] Go to last post
9 702
Go to cell below last entry in column and total by Donna[_2_]
I am doing a macro and I would like for it to automatically go to the cell below last entry in a column and total. (row count will be different each time I...
August 27th 09 02:48 AM
by Jacob Skaria Go to last post
1 553
coefficient of determination by Jene
In the EXCEL curve fit function for a single dependant variable should the coefficient of determination be upper case R-squared or lower case r-squared?
August 27th 09 02:39 AM
by Mike Middleton[_2_] Go to last post
2 2,773
Rolling date looking 30 Days past by Chris
I'm logging data into a spreadsheet daily and keeping track of a rolling 30 days average and 1 std dev above the average. How do I easily create a way to...
August 27th 09 02:36 AM
by Max Go to last post
2 954
Help with Excel VBA by Howard
-- I have a spread sheet as follows: In Column B1 thru B8, I have listed names of workers. In Column C1 thru C8 are cells to hold total hours work. In...
August 27th 09 02:36 AM
by Howard Go to last post
2 350
Converting Text into Values by Terry Bennett
I have a column of data in which recent test results are recorded. Column A specifies the shop and in column B the data is recorded in the format 'AARAGG'...
August 27th 09 02:03 AM
by T. Valko Go to last post
6 424
Post New Thread


Display Options
Showing threads 10001 to 10020 of 88510
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 On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.