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 Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Trying to Run a Formula on the Combinations of Info from Different Books by [email protected]
Trying to make a quick solution to a problem I have come across. If a combo of cells in Row 1 (R1) workbook 1 (WB1) matches the same combination in any row of...
December 7th 16 01:26 PM
by seoclerks.com Go to last post
4 559
How to show full cell contents? by Terry Pinnell[_4_]
Why can I not see the full contents of B2, '03/12/2016 11 :19', extending into the next empty column, just as in the row above? I don't want to widen col...
2 525
How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) by KJ7
I've got a template I'm using (in Excel 2003) where I need to subtract two time-based fields from one another. (Seems simple enough). However... this is for...
(Multi-page thread 1 2)
December 3rd 16 10:03 AM
by Vfppro1692016 Go to last post
14 2,514
Black triangle in cell corner by [email protected]
On Friday, August 10, 2001 at 12:27:34 PM UTC-4, Darryl Abrahms wrote: > Hi, > > I'm using Excel for Windows 2002 in Windows ME. I opened a vendor price...
December 3rd 16 06:20 AM
by vietthai Go to last post
8 667
Pivot Table Grouping by Carol Chan
I have created a Pivot table with the data grouping in month format, but it shown Chinese character (i.e. 1月) instead of english (i.e. Jan), how can I...
2 1,022
Find 2nd & 4th saturday for every month by Nikhil
I enter a date in one column, in the second column i want the day for that date. If the day happens to be the 2nd or the 4th saturday in that month, it...
November 26th 16 05:13 PM
by aloinam109 Go to last post
9 3,828
Cannot add borders by Michael Graubart
I created a number of worksheets in Mac Excel 2008. I have now upgraded to Office 2011 and therefore Excel 2011, and have 'saved as' my worksheets (originally...
November 24th 16 04:28 PM
by aokoa12 Go to last post
3 750
Excel 2007 - Can't scroll thru worksheet by Harriet
Has anyone figured this one out?! Add me to the mix...I'm having the same problem...can scroll directly on the screen but cannot use the mouse scroll and...
3 2,659
formula needed for complicated lookup by coreyk88
Hello, I have a rather complicated workbook that I have an issue with Column A Column B Column C Column H Date Amount ($) ...
November 21st 16 08:45 AM
by dulich2017 Go to last post
6 1,066
Can you lock the column width? by Nightshade
I would like to lock the column width, but still allow data to be entered in the column. Is this possible?
(Multi-page thread 1 2)
19 4,541
Excel 2007: How do I group rows upwards instead of downwards? by BoB SGW
Was fine in older versions but can't find the settings for grouping rows or columns.
7 2,722
Total Interest Calculation by ShamBos
Loan Amount 15000 Term 36 Rate 3% Balloon Payment after 36 months 5000 Payment Interval Monthly Interest calculation method declining balance Need formula to...
November 15th 16 03:18 AM
by ShamBos Go to last post
0 598
=CELL("filename") returns #VALUE! by SupperDuck
Dear Friends, When I use =CELL("filename") in Turkish regional style, it gives #VALUE! error but if I change the settings to USA, it works! Why? And how I...
(Multi-page thread 1 2)
14 1,985
Excel 365 very slow opening files by Terry Pinnell[_4_]
Anyone else seeing the subject behaviour please? More important, how to fix it? It's such a disappointing aspect compared to my old Excel 2000 with Win XP. On...
November 8th 16 03:55 PM
by cachmangmuasam Go to last post
3 830
Cannot drag Excel 365 (2016) window by Terry Pinnell[_4_]
Frequently I cannot drag the Excel 365 (2016) window to another position. Wherever I left click in the crowded green area, it enables one of the menu options....
November 8th 16 03:54 PM
by cachmangmuasam Go to last post
3 752
Sort isn't sorting correctly by GARYWC
Is there a formula/function (not a macro!) that I can use to verify whether the cells are in ascending order?
November 5th 16 07:40 PM
by GARYWC Go to last post
3 932
Complex: Date Ranges and Aggregating Data using IF Statements by Nambud76
First, anyone and everyone that can help is much appreciated. I am a new user here with some level of Excel experience--just not advanced by my standards. I...
November 5th 16 06:18 PM
by Nambud76 Go to last post
0 612
All my entries turned to #VALUE!s by ebolaz
Hi! I have several MS Excel *.xls files that are lists of things (e.g., list of books, that contains author, title, publishing date, genre info in separate...
November 4th 16 02:43 PM
by ebolaz Go to last post
0 720
Excel 2013 shift end down by Dave H
One of my co workers had excel 2013 installed. We work on large amounts of data 10k plus rows is typical. In the past and on other with computers with excel...
October 28th 16 11:50 PM
by mikerickson Go to last post
1 727
Make a decimal number return to zero by [email protected]
I am looking to make a decimal number return to zero. Example if AI EQUALS 37.5 I want to do a formula that divides AI by 2 and when it comes out to 18.75...
October 28th 16 01:15 AM
by mikerickson Go to last post
2 685
Post New Thread

Display Options
Showing threads 81 to 100 of 146459
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 02:11 AM.

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