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
Using text values in Pivot Tables by Eric
I am creating a simple pivot table with one field of values, numbers to be summed, and a second field, occasional two letter alpha codes which are...
(Multi-page thread 1 2)
10 3,449
What determines location of VBA code from recorded macro? by Terry Pinnell[_4_]
I recorded a macro (as a basis for editing, maybe with help here). But how are you supposed to know where to find the VBA code please? I assumed it would be...
5 321
How to copy to a specific worksheet? by Terry Pinnell[_4_]
First, a reminder that I've long since lost what little VBA know-how I had around 15-20 years ago, so basically I'm a novice. Cut to the essentials, I want to...
(Multi-page thread 1 2)
March 4th 17 02:05 PM
by GS[_6_] Go to last post
16 378
How do I stop excel from rounding my numbers up? by lyndylou
I am calculating expenses and each time I enter an amount e.g 12.43 excel rounds it up to 13.
March 2nd 17 11:00 PM
by GS[_6_] Go to last post
3 463
Calculated field formula in pivot by Sarah H
Hi, guys, I have a pivot table with counts by month of H, L, & U. (high, low, or unchanged days in a stock index.) Change over Prior Day...
March 2nd 17 01:59 PM
by Sarah H Go to last post
0 179
Annual Escalator's and Total Contract Value by KevinM[_4_]
I am trying to find a way to find my total contract value on a deal that has a 3% escalator on the anniversary of the contract every year. Monthly Value:...
March 1st 17 03:43 PM
by KevinM[_4_] Go to last post
0 217
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...
9 5,256
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)
12 2,702
Excel disappearing text in formula bar by Adam Mania
I have this issue: No cell protection of any kind, yet formulas are not appearing in my formula bar. The cursor would appear at the end of the invisible...
February 27th 17 09:34 AM
by Adam Mania Go to last post
0 206
Why this date result? by Terry Pinnell[_4_]
Hopefully self-explanatory illustration: https://dl.dropboxusercontent.com/u/4019461/ExcelFormatVariations.jpg -- Terry, East Grinstead, UK
February 24th 17 09:56 AM
by Terry Pinnell[_4_] Go to last post
1 278
quick annualization by billyk81
Is there any formula built into excel 2016 for quick annualization? Or do I have to go into every cell every month to update the formula for the given month...
February 21st 17 07:02 AM
by Longberry Go to last post
1 337
Formula to find all possible 4 digit combinations using the numbers0,1,2,3,4,5,6,7,8,9 by Danelle Sanchez
Hi, I need to create a formula that will show the results of all possible 4 digit combinations using the numbers 0,1,2,3,4,5,6,7,8,9. I found a similar...
(Multi-page thread 1 2)
11 13,313
Go to a column in a selected row? by Terry Pinnell[_4_]
I have a full row selected and I've opened the Go To dialog. The text cursor is at its left end. What do I now type in the Reference field to select the cell...
February 14th 17 09:23 AM
by GS[_6_] Go to last post
7 525
divide and round up by Pammy
I have a formula: c5/4 I want a formula to divide: c5/4 then round up to a whole number. example: if the answer is 17.3 I want the answer to be 18.
8 18,348
Adding a Trendline Problem by Bob[_19_]
Hello, Using Excel 2007 and W 10 on a PC. Have a very simple graph. Just Blood p reading vs. date. Shows up fine. But no matter what I try or do, I can't...
February 8th 17 06:59 PM
by Claus Busch Go to last post
3 309
Formulae Required by Akash Maheshwari
Hi Team, Require help in creating a formulae. I have data in two Columns: A1 - A10 (Room No) (101, 102, 103, 104) B1 - B10 (Booking Source) (Online, Walkin,...
February 4th 17 12:23 AM
by zvkmpw Go to last post
1 367
How to XML Map Repeating Rows? by DaveLS
I'm trying to map XML to a range of rows but, for some reason, Excel (2007) is only mapping it to the first row of the range. I've created an XML file and...
(Multi-page thread 1 2)
10 6,883
I want to extract the pence from a currency sum by JulieS[_2_]
Hello I am working on a sheet where I need to breakdown a currency value into pounds and pence in separate columns without the pence showing the decimal point.
February 1st 17 05:30 PM
by JulieS[_2_] Go to last post
6 207
can't see highlighted colors in Excel except in Print Preview by Gator-N-Walterboro
We are having trouble at my job with Excel 2003. We can highlight cells in a worksheet but you will not be able to see the colored highlighted cell until you...
2 1,230
Run-time error '424': Object required by MrBadExcel
The code below allows me highlight one row at a time. I can scroll up and down a sheet using the arrow keys. Sometimes need to highlight two or more rows by...
January 31st 17 08:06 AM
by GS[_6_] Go to last post
5 335
Post New Thread

Display Options
Showing threads 21 to 40 of 146451
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 10:43 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.