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
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 04:18 AM
by ShamBos Go to last post
0 331
=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,515
Every cell has a page break?!?! by Garyntx
Someone at my office had a file that when opened. (Excel 2007) would show every cell with page breaks showing hidden lines around every cell. Couldn't figure...
(Multi-page thread 1 2)
11 2,091
Why can't I access the footer? by Renee
I have a standard footer in place on my worksheet and I want to customize it. I can't click on the footer, nothing happens (including that I can't see the...
8 4,816
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 04:55 PM
by cachmangmuasam Go to last post
3 452
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 04:54 PM
by cachmangmuasam Go to last post
3 390
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 08:40 PM
by GARYWC Go to last post
3 587
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 07:18 PM
by Nambud76 Go to last post
0 352
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 03:43 PM
by ebolaz Go to last post
0 414
words in cell keep repeating by Hyde Park
In a worksheet that has been created and that we used repeatedly in our business, one cell keeps repeating the name we are placing in it. Such as we type...
5 1,708
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 406
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 369
Print Row Number by Sayth Renshaw
> Hi, > > I would to know how to print Row Numbers from 1 to 100 in specific column, so he change the number by it self without I do that every time I need...
October 20th 16 02:03 AM
by Sayth Renshaw Go to last post
0 419
Print titles must be contiguous and complete rows or columns by [email protected]
On Thursday, June 17, 2010 at 9:50:35 AM UTC+5:30, tanvnit wrote: > "Print titles must be contiguous and complete rows or columns " > > solving this error :...
October 19th 16 09:49 AM
by hahuvoibimat Go to last post
2 315
Dependent Data Validation with Illegal Characters by hjneedshelp
Hello, I've read the link: http://www.contextures.com/xlDataVal05.html over and over, and I am able make a dependent data validation happen for simple...
(Multi-page thread 1 2)
October 14th 16 10:07 PM
by GS[_6_] Go to last post
10 2,181
Copy the formula by dragging but down but calculate by going left by F.G.
Hi, If I enter the formula: =$C$1-E75 and copy down by dragging the column will remain E and the rows will change to 76,77,78 etc. I need the opposite so...
October 13th 16 06:57 PM
by Claus Busch Go to last post
3 257
save in new destination by [email protected]
Hello, hope you can help. I have this macro which works for me, all I need is for the file to end up in this folder here with date & timestamp C:\Copy...
0 316
How to seperate people by Martin [_4_]
Hello, I have several sheets in a workbook with husband & wife In the first example how would i extract all of Mrs Hilary Johnston's details so that I could...
October 9th 16 02:27 AM
by Vfppro1692016 Go to last post
2 266
EXCEL averageif with different #of values to average per calculation,depending on two criteria by [email protected]
I need to take the average of a large data set, for example for the hour(C) 7 of day(B) 2, hour 8 of day 2 and so on. As you can see some hours have more data...
0 298
Excel Average of dates with different data point #s and values. by [email protected]
I need to take the average of a large data set, for example for the hour(C) 7 of day(B) 2, hour 8 of day 2 and so on. As you can see some hours have more data...
0 253
Post New Thread


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