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 : New Users to Excel Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Question
Set date minuse 1 working day by lostgrave2001
Hello Im struggling and cant locate a fix please help. i have a date Exp: 20/01/13 in cella A2 and i want cell B2 to show me the previous working day....
July 17th 13 11:03 AM
by Ron Rosenfeld[_2_] Go to last post
3 757
1 Attachment(s) Creating a line graph with recurring Y values by |ApeX|
Hello, I am a bit new to Excel and I am trying to create a line graph that tracks student progress over time. Setting up the Y-axis is what creates a problem...
July 12th 13 12:10 AM
by |ApeX| Go to last post
0 698
Vlookup and Countif by bbkdude
Alright, I have an odd question/desire. Data would be something like this http://i42.tinypic.com/2wpifjl.jpg In the F column, I would like it to display the...
July 10th 13 01:17 AM
by bbkdude Go to last post
0 696
Summing Numbers ending in letter by bbkdude
Hello All, So here's what I am trying to accomplish: 1,500C 1,000C 2,500C 5,000C My Sum is 10000C, but I would like it to read 10,000C with the comma.
July 6th 13 05:07 PM
by Claus Busch Go to last post
3 686
Setting up a chapter a word-count inventory for a novel by FretLess
Hi, as per the title, I'm halfway though my first novel and I would like to automate the process of tracking my cumulative word count. I have a manual...
July 6th 13 01:08 PM
by Stan Brown Go to last post
1 653
Thumbs up
Excel File need to unprotect by Asrar Ayub
Hi All, I have a excel file, and password is forgot. Now i have to open that excel file. Regards, Asrar ayb
July 4th 13 11:08 AM
by rinyvangogh Go to last post
2 745
Help with column accumulation needed by [email protected]
Column A has a set of random values. Many of them are repeated but are not consecutive to each other. Column B has a value for each column A entry. For example...
June 30th 13 10:42 AM
by Spencer101 Go to last post
1 658
Smile
Help with formula! by NubianNewbie
I need to do a formula that would show if E6 plus H6 is greater than or equal to 60 then show 60 but if its less than 60 to show 5% of that number. I see to be...
June 28th 13 03:52 AM
by joeu2004[_2_] Go to last post
2 1,065
Ppmh by jolietjake
Can someone help me with the formula I need for tracking parts per man hour? My goal is 32 units produced in 8 hours with 6 people. I need a formula that...
June 13th 13 12:57 PM
by Claus Busch Go to last post
1 876
Question
Highlighting a whole row. by lostgrave2001
hello I am trying to highlight an entire row (e1-e5) if E5 if over 9999.99. i need the whole row to be highlighted in red is this possible?? im using Excel...
June 9th 13 11:36 AM
by Claus Busch Go to last post
4 772
Complarisons and lookup help by Nullform
So I'm having an issue with creating a formula to make an "easy to read" chart. Here is the data I have to work with 300 some odd "sites", about 500+ doors...
June 2nd 13 08:07 PM
by Spencer101 Go to last post
1 773
1 Attachment(s) Help by ahmed1972
Hi.... I am new in excel and want help ... please check the attached file.... i wand to checke C4 - AX4 if they contain "D", ... if it is true then return...
June 1st 13 08:05 AM
by Spencer101 Go to last post
1 783
Identifying Unique ID's in a Single Column by MichaelPK
Hello - I have thousands of ID's in a single column and need to find all ID's that have a (-#) the # are varied; 1, 2 3 etc... at the end. Sorting does not...
May 23rd 13 06:44 PM
by MichaelPK Go to last post
2 726
Fit a Logistic Curve by teh2heartedale
Hello all First time poster, so I apologize for any formatting issues. I am working on an assignment, and am posting here because I couldnt make it to class...
May 21st 13 05:43 AM
by teh2heartedale Go to last post
0 733
Question
Copying out amount only by lostgrave2001
hello i have the following text in cell A2 123456 batman 15000.00 i would like to be able to coy just the amounts in to cell D2. could anyone please...
May 20th 13 10:49 AM
by Claus Busch Go to last post
5 786
Working out what clothes to get. by Grant0193
Hey, Im trying to work out what clothes I need for the works. I need to find out how how many of size and type of clothes I need. Eg; Nick: Jacket Size:L...
May 18th 13 12:43 PM
by Claus Busch Go to last post
3 906
Partial match of a text by aikhalif
Hi, I am trying to match a portion of the text in a given array and return the corresponding complete value of the array. Example: A ...
May 15th 13 06:06 PM
by Ron Rosenfeld[_2_] Go to last post
6 1,032
1 Attachment(s) Sum multiple worksheets and summary tab that would sum and count by rep name by angie.chang
I have multiple worksheets within the workbook. There are tab 1,2, 3, etc. Each tab represent days of month(May). I have a rep stats summary tab to sum up by...
May 15th 13 04:39 PM
by angie.chang Go to last post
0 565
Smile
VBA Error Message HELP!!!!! by Tansy
I'm coming up with the error message below, does anyone know what it means: 'An unexpected error has been detected Description is:0, Subscript out of...
May 14th 13 11:15 AM
by Tansy Go to last post
0 543
Cell Validation by JLW SR
I am a novice any and all help will be greatly appreciated! I need to provide a list of valid usernames for cell #1, then have the user enter their password in...
May 8th 13 04:42 PM
by Ron Rosenfeld[_2_] Go to last post
2 760
Post New Thread


Display Options
Showing threads 101 to 120 of 13664
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 04:36 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.