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
Calendar on multiple sheets by Antoine Balon
Hello, I have to create a schedule of employees for the year 2017. I fairly new to excel. How do I create a calendar on multiple sheets automatically with the...
December 20th 16 04:53 PM
by GS[_6_] Go to last post
1 348
LINEST with r2 = -1.18 ??? by alessio.toraldo@gmail.com
Hi all this is funny. Missing values are a problem with LINEST However, the very Excel that does not allow for missing values, ignores them when plotting a...
December 20th 16 09:13 AM
by alessio.toraldo@gmail.com Go to last post
0 301
1 Attachment(s) Sum columns based on conditions by shani1975
Hello, I need to figure out how many "true" Regular employees we have. As you can see, I have columns that are labeled FT, PT, REG, SEAS and INTERIM. A FT...
December 16th 16 08:10 PM
by Claus Busch Go to last post
1 343
Adding a max percentage to existing formula by JedSrq
I have the following example where the second column calculates 10% for every age. But when I get to an age over 5, I want the formula to only calculate a...
December 16th 16 07:06 PM
by JedSrq Go to last post
2 427
Unhappy
AVERAGE with multiple conditions by AaronR
Hello, I'm trying to calculate an average, but need to adhere to a couple conditions: - Average must be of A and B - A is capped at 125% - B is capped at...
December 16th 16 12:42 AM
by MyVeryOwnSelf[_3_] Go to last post
2 398
Round up by 0.5 if >=.25, down to integer if <.25 by brkling@gmail.com
Hi there, what would be the formula to take above criteria and apply to numbers from 1-6, for results like this: 4.15 would be 4.0 4.35 would be 4.5 4.65...
December 15th 16 06:12 AM
by Luannguyen992 Go to last post
4 532
Lock Cell After Data is Entered on Particular Cell by Moideen
We are maintaing an excel sheet for expense details, After Entering the data on Amount Coloumn Need to Lock The Amount Coloumn with Password. Please help...
(Multi-page thread 1 2)
December 10th 16 08:27 AM
by rupam.dey@pittiegroup.com Go to last post
12 2,489
How to put space in between each Character in same cell with formula by Sunil V
Hi, How to put space in between each Character in same cell with formula For example: ABCDEF which is in A1 Cell should be converted in to A B C D E F need to...
December 9th 16 03:50 PM
by DungSports Go to last post
7 408
Formula That Checks For Changes by tb
I have a spreadsheet with the following columns: * Col. A: Part numbers * Cols. B, C, and D: Current data that pertains to part numbers in col. A * Cols....
November 30th 16 06:58 AM
by Claus Busch Go to last post
7 643
merge cells disabled how do I enable by Gary
I have an xcel spreadsheet that has merge cells button disabled. How do I enable this button?
November 29th 16 08:41 PM
by yannbreliere@gmail.com Go to last post
4 3,386
Excel Pivot Table How to Sort data as Percent of Row by Pat
Excel Pivot Table How to Sort data as Percent of Row In Excel 2003 you could display data in a pivot table as percent of row then sort the percentage. In...
November 19th 16 10:34 AM
by bulong Go to last post
9 7,335
Prevent rounding up and down by TerrySmith33
Hi I have a table of data which has a series of percentages. The client wants these % displayed to 0 decimal places. However, Excel rounds anything 99.5% and...
November 15th 16 06:34 PM
by Claus Busch Go to last post
2 575
Excel spreadsheet formula to count numbers in PivotTable column by jacquesbardot30@gmail.com
I have a PivotTable with many rows. The last row of the PT is, of course, the sum of each column. I want to put a row of formulas a few rows below the PT that...
November 15th 16 06:20 PM
by GS[_6_] Go to last post
3 643
1 Attachment(s) Excel 2016 IF function wrong answer by Leilan
Hi, I'm confounded by excel's answer to my if function. My formula worked for column G. But in that column my condition was not >= but just =. When I tried to...
November 11th 16 07:32 AM
by Leilan Go to last post
0 615
Comparing Stop Watch Times by Curtopia
I am trying to compare stop watch times against a control time which is a touch pad time. I populated the touch pad times along with the stop watch times and...
November 10th 16 08:05 PM
by Claus Busch Go to last post
3 564
Extract date / extract time / strip data by Smurfy
I have the following string of text and I need to extract data for different columns. "POS 12/31/15 08:03 8931 PICK N PUMP " So I need to extract the date...
(Multi-page thread 1 2)
November 8th 16 04:50 PM
by cachmangmuasam Go to last post
14 1,182
Change Excel Date Format by kvance972@gmail.com
Can someone provide a way to mass change time formats from tt:00 PM or AM to tA or tP. Where t=time The minutes vary from :00, :15, :30, :45... If the minutes...
November 1st 16 05:11 PM
by tinhdauhcm1 Go to last post
1 740
Excel 2003 worksheet tabs missing at bottom of my laptop display by Quixote
How do I get multiple worksheet table to show at the bottom of my Vista laptop display? The do appear at bottom of my XP desktop display. Thanks.
October 24th 16 04:13 PM
by tonybrea101@gmail.com Go to last post
4 9,737
Highest total of any three consecutive numbers in a range. by skablaw@gmail.com
I am searching for a function or formula that might give me the biggest sum of three consecutive integers in a range. For example if I have the numbers...
(Multi-page thread 1 2)
October 14th 16 10:27 PM
by ryno_19 Go to last post
12 5,713
Help with multiple IF by Tarlis Machado
Hi I would like to indicate a certain value in a cell if a certain value is found in the next 3 cells. This seems simple yet I have tried several tims without...
October 11th 16 02:05 PM
by Claus Busch Go to last post
3 728
Post New Thread


Display Options
Showing threads 21 to 40 of 88509
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 12:03 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.