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 Replies Reverse Sort Order Views
In Excel, how to count a list of check boxes some are checked? by M. Zak
I have a list of names/accounts, in front of each there's a check-box which tells if the account was completed or not (checked or cleared - false or true). How...
September 11th, 2006 12:32 PM
by Ashwini Go to last post
6 152
LOOKUP a phone number? by Laura
Is this possible? I would like to create a LOOKUP formula that would tell me the phone number if I put in the name. For instance, I have one worksheet that...
September 8th, 2006 07:18 PM
by Biff Go to last post
6 144
VLOOKUP, INDEX & MATCH ERROR HELP by sahafi
Hi All, I keep getting #N/A error every time I execute this formula. Here's the situation: My lookup range data resides in 'Data' sheet, and my formulas in...
September 12th, 2006 11:26 PM
by sahafi Go to last post
6 136
Convert Dates by Jo Anna
How do you convert a Julian date with a 4 digit year into a standard calendar date?
September 8th, 2006 11:31 PM
by Gord Dibben Go to last post
6 155
tricky search and replace by john
I need to search for a particular string in a very large spreadsheet, and when I find it I need to replace it with the contents of, or a reference to, the cell...
September 11th, 2006 04:41 PM
by john Go to last post
6 117
conditional format if the cell contains a formula by ellebelle
I would like to colour code all the cells in my spreadsheet based on whether they contain a formula or not. is this possible?
September 12th, 2006 09:04 AM
by ellebelle Go to last post
6 100
How do i increase the height of the worksheet tab in Excel? by DailyExcelUser
I really would like to increase the height of the worksheet tab at the bottom of the screen. I have so many tabs and hate scrolling. Would rather have the...
September 11th, 2006 09:46 PM
by Gord Dibben Go to last post
6 122
Autosum and Manual Sum not working by Gaileen
I want to simply add several rows in a column - all containing currency formatted cells. No matter what I do the total always appears as "0.00". My formula...
September 11th, 2006 11:06 PM
by Gaileen Go to last post
6 75
Change second digit from 4 to 6 by Steved
Hello from Steved I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks
September 11th, 2006 10:01 PM
by Steved Go to last post
6 139
#N/A in calculations by JonR
Hi I'm trying to work around some #N/A values in calculations. Columns A and B are populated with a conditional formula, and I'm trying to sum them in...
September 10th, 2006 07:33 PM
by Aladin Akyurek Go to last post
6 106
Can excel list the possible combinations from a range of cells by Syndrome
I have 15 cells with differing data in them, for example Andy in A1, Lesley in A2, Keith in A3 etc etc. I want to calculate and list the different...
September 9th, 2006 09:00 AM
by Syndrome Go to last post
6 100
GETPIVOTDATA() with relative reference by Sune Fibaek
Hi, Is there a way of cheating GETPIVOTDATA() into using a cell reference as the data field argument? As in =GETPIVOTDATA(J8;$A$7;"Rep";$J$9:$L$9). I've...
September 3rd, 2006 10:39 PM
by Max Go to last post
6 135
alphanumeric range by [email protected]
I have more than 3 different choices, ( ab, cd, ef, ghij, kl). They are also aphanumeric, (.01 ab, 6 cd, .50 ef, 8 ghij),etc. The numbers may range from .01...
September 3rd, 2006 12:09 AM
by [email protected] Go to last post
6 77
CONVERT TO (###) ###-#### by JSM123456
How do you convert a phone number in this format xxx-xxx-xxxx to (###) ###-####? I've tried format, cells, custom, (###) ###-#### and "(###) ###-####" but...
August 31st, 2006 08:45 PM
by Sloth Go to last post
6 50
problem conditional formatting? by _Bigred
I have a sheet that has approx 7,000 rows. Until I get all the data into it many columns will contain: #DIV/0! or #VALUE! I would like to do some...
September 4th, 2006 06:02 AM
by Max Go to last post
6 133
How do I enable emailing a worksheet in Excel? by Roger Fulton
I can email the entire workbook but not just a worksheet. We use Exchange Server and Office 2003.
September 6th, 2006 09:39 PM
by Roger Fulton Go to last post
6 108
automatically fill in blank cells?? by AlaskaMX
Can I type info in 1 cell and have it automatically put different info in the next cell? Kinda like autofill but not that exact option. This would be...
September 5th, 2006 05:32 PM
by Gord Dibben Go to last post
6 71
Problems with MAX by carlo
Hi all got a problem with the MAX statement: have a range with let's say 20 cells. Each cell has a formula, which either produces a Number or "". If i want to...
September 5th, 2006 12:51 PM
by carlo Go to last post
6 86
Delete first two characters in a cell... by ChuckF
I have a spreadsheet which shows the first inital and a space for everyone in our company. I am trying to cut that down to simply show the last name. Can...
September 5th, 2006 08:46 PM
by bj Go to last post
6 87
Detect Presence Formula by Ken
I need a formula that will detect the presence of a value in an unsorted named array. Column A would be the named array. Column B would be the value I want...
September 12th, 2006 06:43 PM
by Ken Go to last post
6 136
Post New Thread


Display Options
Showing threads 10001 to 10020 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 09:11 PM.


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