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
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,592
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 689
Excel spreadsheet formula to count numbers in PivotTable column by [email protected]
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 768
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 731
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 710
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,396
Change Excel Date Format by [email protected]
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 895
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.
4 9,889
Highest total of any three consecutive numbers in a range. by [email protected]
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 6,036
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 854
How to add random cells and get a sum value in another cell than status bar. by Umi
I want to make a function table in excel for example: a: 10 b: 20 c: 30 d: 40 When I select "a" and "b" it should add it and give the value "30" in another...
October 9th 16 04:07 AM
by GS[_6_] Go to last post
4 786
7 Attachment(s) sum cells with specific text in comments by phillip cole
Hello All, I would like to sum a range of cells in a column that have specific text in the comments and display the sum at the bottom of each column. I have...
(Multi-page thread 1 2)
October 6th 16 02:04 PM
by Claus Busch Go to last post
18 1,632
Simplify formula by [email protected]
On Wednesday, July 24, 2002 at 8:51:00 AM UTC-7, Harlan Grove wrote: > Glenn Schwandt > wrote... > >Thanks, but I don't think this would...
September 29th 16 09:24 PM
by Txlebang106 Go to last post
1 820
Array Formula to return Header by L. Howard
Trying to return the header of the cell in the range E2:P2 that has a value greater than 499 and less than 1500. Formulas, as is, returns header from P column...
September 29th 16 08:56 PM
by L. Howard Go to last post
8 808
Excel Dates by [email protected]
Hey there,, I am trying to make a weekly excel tab on excel. I have 53 tabs, the first tab being a running total and then 52 tabs all for each week of the...
1 752
Help with IF function by Michelle
Am trying to create a formula that will tell me: if the range of cells has the single letter "R" or the single letter "T" in the individuals cells, it will...
(Multi-page thread 1 2)
14 1,408
Dynamic Range Name that's driving me nuts by [email protected]
I've created a Dynamic Range Name that uses the OFFSET() function with some embedded MATCH(), VLOOKUP(), & SUMIF() functions. That Dynamic Range is being used...
September 14th 16 10:28 PM
by GS[_6_] Go to last post
8 1,002
how do I delete data in a cell without deleting formula? by tripy
after adding data to a formulatted cell on a worksheet, i save as, and then use the previous worksheet and delete data to start another worksheet. when doing...
5 3,690
First day of the next bi-weekly Sunday to Saturday payroll period after a given date by ElizabethWells
Hi, In a 401(k) plan, employees enter the plan on the first date of the next payroll period after they've been employed for 120 days. I can calculate 120...
September 4th 16 09:57 PM
by GS[_6_] Go to last post
6 977
Need Function that returns active sheet name by arcibald tuttle
something like the ACTIVE.CELL() function but ACTIVE.SHEET() and ACTIVE.WORKSHEET() which i guessed don't seem to work. anybody? thanks,
September 3rd 16 04:57 PM
by Claus Busch Go to last post
1 729
Post New Thread

Display Options
Showing threads 41 to 60 of 88516
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 06: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.