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
INDEX function (array type) by Sean[_3_]
Maybe I'm missing a trick here. The formula =INDEX({1,2,3},1,2) will return the value 2 The formula =INDEX(A1,1,2) where the cell A1 contains the...
August 27th 09 10:06 PM
by Sean[_4_] Go to last post
4 385
Two Criteria = 1 by Jazz
I am looking for help with a formula. Write now if Sheet1 has a “10” in cell K4, and I put this formula {=IF('Sheet1'!K4="10",1,""} in cell P4 the number...
August 27th 09 10:04 PM
by Jazz Go to last post
7 298
Formular by Kanmi
Please can anybody provide me formular that perform this task below. I have workbook that can contain macro. when i run the macro it pick formular from column...
August 27th 09 09:29 PM
by Kanmi Go to last post
0 283
formulas to count dates by Brian
I have input the following dates into cells A1,B1,C1,D1 respectively...March 30, 2009, August 20, 2009, July 30, 2008, November 20, 2008. Cell Z1 is todays...
August 27th 09 08:53 PM
by Shane Devenshire[_2_] Go to last post
2 439
Conditional Formatting color doesn't show up: 90% by Stu
I have a cell formatted to show a number as percentage and the conditional formatting rule says Between 0.9 and 1 will be green. 0.9 is showing up no...
August 27th 09 08:45 PM
by Shane Devenshire[_2_] Go to last post
7 496
FULL SCREEN WITH TOOLBAR ACCESIBILITY by Roberta
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 332
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 415
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 942
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 612
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 329
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 358
#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 352
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 332
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 414
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 281
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 334
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,532
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 431
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 298
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 611
Post New Thread


Display Options
Showing threads 10001 to 10020 of 88524
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 11:33 AM.


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