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
Replace hard return with a delimiter? by Erin.
I have an Excel 2003 file with the full US address in one column. Street and city are seperated by a hard return as are state and zip. Ultimately I need to...
June 25th, 2009 10:10 PM
by Ethan Strauss Go to last post
3 161
SUMPRODUCT not working. by Gaurav[_7_]
can someone please help me understand what is wrong with the following formula? =SUMPRODUCT((Sheet1!$C$2:$C$3515=A2)*(Sheet1!$B$2:$B$3515="-2"))
June 25th, 2009 09:37 PM
by Gord Dibben Go to last post
2 100
Cycle Times by PAL
I am trying to calucate cycle times. I have 2 milestones (each with a planned and actual date Column A: Milestone 1 Planned Column B: Milestone 1...
June 25th, 2009 09:31 PM
by PAL Go to last post
4 128
Automatic Cell Copy to other worksheets by sharice.g
I made payment sheets for my cheerleaders in order to track orders and payments made. I have about 30 different worksheets in this one workbook. Workbook...
June 25th, 2009 08:42 PM
by Ron de Bruin Go to last post
1 92
Excel Comments by lisa
The option to view comments in Excel by doing a mouse rollover seems to have disappeared.
June 25th, 2009 08:42 PM
by lisa Go to last post
5 105
forgoten password by Leon
I have forgoten or mispelled my password. It keeps telling me that my caps lock needs to be adjusted. I have done every possible spellings with caps. So I...
June 25th, 2009 08:32 PM
by Hans Terkelsen Go to last post
4 108
lookup issue.... by John
I am stuck...cant figure out whats wrong with this formula....any help??? =if(isblank(Data Sheet!E3,"1",'Data Sheet'!E3)) Also if i want to use the above...
June 25th, 2009 07:45 PM
by Gord Dibben Go to last post
2 108
Using tab key in protected worksheet by bev
I have a worksheet that I am allowing users to edit only certain cells. In the protected mode, the tab key won't work, only the arrows and enter key. Any...
June 25th, 2009 07:35 PM
by bev Go to last post
4 158
Conditional Count Formula by Mully
If your up for a challenge please have a go at this formula as I'm stumped! What I want to do is create a formula that will analyze a historical table of...
June 25th, 2009 07:09 PM
by T. Valko Go to last post
3 136
how to use vlookup for more than 1line by LHM
I have severeal lines for every invoice number. Vlookup formula just bring the first line. I need a formula to bring all lines to my summary sheet.
June 25th, 2009 07:08 PM
by LHM Go to last post
3 116
is there a formula that will subtract todays date from a hire date by Heather
is there a formula that will subtract todays date from a hire date so that I could have a "years of service" column
June 25th, 2009 06:39 PM
by Jacob Skaria Go to last post
4 107
how to make a preforated page-break insert by KoldKream
I'm trying to make a preforated page-break on a spreadsheet. The preforated insert should show the "itty-bitty" cut lines where ever I have the page-break...
June 25th, 2009 06:13 PM
by Gord Dibben Go to last post
2 89
Sorting Coloumns that are Formula's by heritage1450
I have a set of data that I'm trying to sort. The data itself is coming from a formula, but when selected the full set of data, going to Data Sort, choosing...
June 25th, 2009 05:37 PM
by Eduardo Go to last post
1 95
Woman age 40 by Tony_student
Let's say one colomn is a list of different gender types (man, woman, man, woman and so on) and another colomn a a list og ages (25, 35, 40, 35 and so on)....
June 25th, 2009 05:34 PM
by JLatham Go to last post
9 125
Extracting email address from various data by Wade
Example of data: H: (111) 222-3333 W: (111) 222-3333 Cel: (111) 222-3333 W Fax: (111) 222-3333 Email: ...
June 25th, 2009 05:08 PM
by Jacob Skaria Go to last post
2 90
Copying Worksheets which contain Named Ranges by Terry Bennett
I have a workbook that has several sheets. On one of the sheets I have named several ranges of cells and formulae in other sheets refer to these...
June 25th, 2009 05:04 PM
by Terry Bennett Go to last post
0 91
i need some help in a type by Vatos
i have the first name o people in a row of names, and i want a type to check if the second to last letter is "η" then write the name without the last...
June 25th, 2009 04:53 PM
by Shane Devenshire[_3_] Go to last post
2 81
Merge two columns of data with a condition by Richard
Hello, I am trying to put information that is in two columns into a third column, but I don't the two columns concatenated. If the same information is in...
June 25th, 2009 04:40 PM
by Sam Wilson Go to last post
1 118
count value dependent on unique or repeated values in another colu by singing_inmysleep
if anyone can help with this i'll be so grateful, it's a bit complicated... firstly, i want to count the number of times "Referral" occurs in column D when...
June 25th, 2009 04:26 PM
by RagDyeR Go to last post
2 131
Check for CAPS by Heidi
I have a list of names in this format: Johnson,Dave Smith,Karen MENDOZA,JUAN I need to run a check and identify all the cells where the name is in all CAPS....
June 25th, 2009 04:21 PM
by Heidi Go to last post
3 90
Post New Thread


Display Options
Showing threads 9741 to 9760 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 02:12 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.