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
how to unshared by Bingo
How to unshared workbook?
May 23rd, 2010 08:36 AM
by Ms-Exl-Learner Go to last post
2 323
returning a value in a table referencing ranges by tveith
I have a chart 1 that has a list of ranges and if the number falls with in the range I want the commision value returned to my new work sheet ex: Chart...
May 23rd, 2010 07:33 AM
by Ashish Mathur[_2_] Go to last post
2 308
Adding variable number of columns by fabio
Hi Using Excel 2003 I want to create a formula which will add a varing number of columns together depending on the entry in a particular cell, for a...
May 23rd, 2010 07:30 AM
by Ashish Mathur[_2_] Go to last post
8 530
Average with #DIV/0! by TG Engel
I'm having a problem with an Average formula. When I use a solution to a similar question =AVERAGE(IF(ISNUMBER(B8:M8),B8:M8,FALSE)), it eliminates the...
May 23rd, 2010 05:35 AM
by Ashish Mathur[_2_] Go to last post
4 296
Excel 2003 sum if or count if ... or is it something else ??? by Kawboy
I am using Excel 2003 and am really stuck on getting a sum or count function to work if it matches another column. I know this might be bread and butter to...
May 23rd, 2010 05:26 AM
by Ashish Mathur[_2_] Go to last post
6 593
condditional farmulation by RAMAN
sir, i want to do in excel such type of farmla through we can not leave blank cell or enter without giving number. like : 1 2 4 if we can not enter 3 than...
May 23rd, 2010 05:13 AM
by Ashish Mathur[_2_] Go to last post
2 236
Remove weekends by rhhince[_2_]
I have 2 dates and time: 5/21/2010 11:34 is in A2 5/25/2010 11:34 is in A3 If I subtract them, I get 4 days in cell A4. I would like to subtract the weekends...
May 23rd, 2010 04:57 AM
by Ashish Mathur[_2_] Go to last post
2 243
move to cells automatically by using tab button by bradleyGSK
good day firstlt i ave a sheet with 12374 cells which i have condition formated to change cell colour for value between a certain number.these cells are...
May 22nd, 2010 11:53 PM
by L. Howard Kittle Go to last post
1 312
Can I Use a Count Function for Text? by Joan NYC
I have been trying to calculate a column of Text in order to sum contents by certain criteria I have tried Count, CoutA and CountIF and cannot be able to get...
(Multi-page thread 1 2 3 ... Last Page)
May 22nd, 2010 07:17 PM
by Chris Reid Go to last post
106 3,771
Match / Index multiple criteria return multiple results by Marty
Help I'm stuck! Sample Data Sheet1 A B C Stock# Sales Person Type 90012 Bill ...
May 22nd, 2010 01:49 PM
by Max Go to last post
2 313
Overlap graph multiple axis by aquaxander
Hi, I am aware of secondary axis. But is it possible to plot more than 2 types of data? So, for example I want to plot over time (so week1, week 2, etc =...
May 22nd, 2010 01:15 PM
by Tom-S[_2_] Go to last post
1 221
Average a column containing numbers and text by Malcolm
I need to count text cells that contain the letter S and the text C/O. Can this be done. By the way this would be two different total cells, one for "S" and...
May 22nd, 2010 02:26 AM
by Malcolm Go to last post
6 198
putting a date in an if statement by pat67
When i write an if statement taht says this =IF(J26/1/2010,"N/A",J2), it always comes up false. How do make it see the date?
May 22nd, 2010 02:25 AM
by T. Valko Go to last post
5 209
Conditional Formatting - to highlight overwritten formulas by JohnG
A number of people can access and update a spreadsheet that I designed for them. The sheet contains a column with lookup formulas. I need to be able to...
(Multi-page thread 1 2)
May 22nd, 2010 12:33 AM
by Max Go to last post
13 516
Indirect.ext by Doug
How would I need to type this in? I have tried this several ways. This is what I have currently and it gives me an error "A formula in this worksheet...
May 21st, 2010 10:08 PM
by Dave Peterson Go to last post
1 228
How do I get all narrative to fit into one cell block? by Debbie111
I handle moves of sites. There is one field that requires some fairly extensive explanation of any issues that have occurred for history purposes. I have...
May 21st, 2010 09:37 PM
by Tom Hutchins Go to last post
2 166
IF Function by casdaq
I have this formula currently set up... =VLOOKUP($A14,$B$7:$J$10,5)*W14 but I needit to not reflect the calculation if W14 has a "-" dash in the cell. I've...
May 21st, 2010 08:37 PM
by jayray Go to last post
4 194
HOW DO YOU FORMAT A DATE? I KEEP PUTTING ONE IN AND IT CHANGES by LADYBIRDDI
I'M DOING A SPREADSHEET AND WHEN I PUT DATES IN THE COLUMN IT AUTOMATICALLY CHANGES TO A FUTURE DATE. NOT SURE WHAT I'M DOING WRONG
May 21st, 2010 08:36 PM
by jayray Go to last post
2 209
How to have a cell auto resize the font to make text fit in cell? by tanner08
I'm using Office 2007, and I would like to know how to make the font size automatically adjust to fit whatever I type into an individual cell.
May 21st, 2010 07:59 PM
by Dave Peterson Go to last post
1 241
How to retain part of formula's criteria as static by --Viewpoint
Below is a formula that I want A50:A100046 to remain static so when I "fill down" the information doesn't change. ...
May 21st, 2010 07:53 PM
by --Viewpoint Go to last post
7 269
Post New Thread


Display Options
Showing threads 381 to 400 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:24 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.