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
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 565
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 281
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 306
#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 300
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 298
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 372
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 249
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 298
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,496
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 388
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 263
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 575
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 880
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 243
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 414
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 309
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 340
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 253
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 412
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 514
Post New Thread


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