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
My spreadsheet opens in full screen without the toolbars showing at the top. I can use the right click on the mouse to then close full screen which will...
August 27th 09 08:05 PM
by Sean Timmons Go to last post
1 314
How to reverse data of a single column? by Denish D
How to reverse data of a single column? Example: Column 2254 245 148
5 388
How do I average cells that contain #DIV/01? by Pullge
i am using the follow formula to average cells and not average blank cells or a 0.00 =AVERAGE(IF(B2:E2<>0,B2:E2,"")) This portion of the formula works...
August 27th 09 06:03 PM
by Pullge Go to last post
2 898
How do I write formula to check a range of cells? by Tayo
Please I have the following: COLUMN A COLUMN B COLUMN C ROW1 500 ...
August 27th 09 05:53 PM
by Luke M Go to last post
5 582
Need help with sumproduct formula by Nielly
I was given this formula =SUMPRODUCT(--(E2:E10="Dawn"),--(F2:F10="X")) yesterday which worked perfectly. I tried to apply a "date" to one of columns as a...
August 27th 09 05:35 PM
by T. Valko Go to last post
1 303
conditional if or lookup by Redi
HI all, i posted another one like this but i can't seem to find it here in the group. I need your help with a formula that would be on column d. if b1=b2 then...
August 27th 09 05:14 PM
by Redi Go to last post
0 328
#DIV/0! by KelD
I've read almost all of the threads. Now I'm REALLY confused. I need to get an average using data that is put in by the user. I'm adding a bunch of cells...
August 27th 09 04:56 PM
by Luke M Go to last post
1 321
ordering a column by incidence by colensa
How can I order a column by the number of incidences of a value e.g. by the number of times a name appears in that column, ordered by greatest to lowest. I...
August 27th 09 04:52 PM
by Don Guillett Go to last post
1 314
How to find and move a value based on multiple criteria by JeffZ88
I have a very large spreadsheet consisting of columns with first names, last names, ID numbers, and other data. I would like to search and copy ID#'s...
August 27th 09 04:27 PM
by JeffZ88 Go to last post
0 385
Pivot table column help by Mr CheeZe
I have created a pivot table where i need to change the data frequently and sum up the total minutes per week of an activity. i am using a 'week number'...
August 27th 09 04:17 PM
by Mr CheeZe Go to last post
2 264
Display text automatically by OKY
I need to enter a text in A1 if i enter text in B1. In other words, if I enter any text in B2 I want A1 to display "OPEN" Thank you for your help.
August 27th 09 04:15 PM
by Niek Otten Go to last post
3 316
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,509
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 400
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 271
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 585
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 900
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 262
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 430
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 320
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 351
Post New Thread

Display Options
Showing threads 10001 to 10020 of 88519
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 02:48 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.